There is a tool called Linqer, but be careful: transliterating from SQL to LINQ can give you the worst of both worlds. For instance, suppose you want all purchases of $1000 or greater paid for in cash or by customers who live in Washington. Here’s the query in SQL: SELECT p.* FROM Purchase p LEFT … Read more
I figured it out, thanks for the suggestions anyway. The solution is to do this (2nd attempt in my question): var qry = (from a in Actions join u in Users on a.UserId equals u.UserId select a).Include(“User”) The reason intellisense didn’t show Include after the query was because I needed the following using: using System.Data.Entity; … Read more
LINQPad defines two extension methods (in LINQPad.Extensions), namely Dump() and Disassemble(). Dump() writes to the output window using LINQPad’s output formatter and is overloaded to let you specify a heading: typeof (int).Assembly.Dump (); typeof (int).Assembly.Dump (“mscorlib”); You can also specify a maximum recursion depth to override the default of 5 levels: typeof (int).Assembly.Dump (1); // … Read more
I wrote an extension method to Object that uses the Json.Net serializer with the pretty format option. JSON is easy enough to read when formatted like that. You miss type info, but I don’t know that you need that, especially considering how easy this is. Hasn’t failed me yet. I use Json.Net and not MS’ … Read more