Comments at DigitallyCreated Blog (for blogs tagged: "LINQ")

Adalton commented on "More Dynamic Queries using Expression Trees"

Adalton — Thu, 08 Sep 2011 17:46:49 GMT

This example is fantastic. Congratulations!!!

I have a doubt. In this example, you put only Equal condition.

In my scenario, I'd like put the LIKE Command. For example, tag.Name Like "abc".

Again, congratulations!!!

bbqchickenrobot commented on "Dynamic Queries in Entity Framework using Expression Trees"

bbqchickenrobot — Mon, 08 Aug 2011 13:23:59 GMT

Ok, answered my own question... the answer is yes. You can create multiple where clauses and chain them. Another question would be how to do and clauses...

bbqchickenrobot commented on "Dynamic Queries in Entity Framework using Expression Trees"

bbqchickenrobot — Mon, 08 Aug 2011 13:09:41 GMT

So, let's say you have multiple parameters for the where clause... how would one go about implementing that? Is it as simple as creating two where expressions? Great blog post!

Daniel Chambers commented on "More Lessons from the LINQ Database Query Performance Land"

Daniel Chambers — Thu, 21 Jul 2011 05:56:48 GMT

@Simon: Yes, convoluting your LINQ can degrade your maintainability, however, you might be able to improve the maintainability of the LINQ queries where you've done weird esoteric hacks (such as the ones discussed in the previous blog post I linked at the top of this one) by using an expression rewriter like the one I discussed here:

http://www.digitallycreated.net/Blog/66/sweeping-yucky-linq-queries-under-the-rug-with-expression-tree-rewriting

However, with respect to this blog post, I wouldn't consider the alternative query structure proposed here unmaintainable. In fact, it looks very much like SQL! Your only issue is communicating why the query has been written that way and not some other way, which a process of LINQ best practices education amongst your developers would help with.

Simon Raik-Allen commented on "More Lessons from the LINQ Database Query Performance Land"

Simon Raik-Allen — Thu, 21 Jul 2011 01:41:46 GMT

On the flip side, convoluting your source to effect the output could degrade its maintainability. Not that that will always be the case, but its another thing to add to the balancing act. Damned if you do, damned if you don't :-)

A Linq2Sql cheat sheet for these tips would be cool.

Thanks, again.

Daniel Chambers commented on "More Lessons from the LINQ Database Query Performance Land"

Daniel Chambers — Thu, 21 Jul 2011 00:09:13 GMT

@Simon: Short answer: it depends. :)

Long answer: It depends (ha!) just how much pain LINQ is giving you, and how difficult it is to fit SQL into your application. Entity Framework lessens the pain as the LINQ query provider is better. L2S and EF both support compiled queries, so you can reduce the performance impact of using LINQ. At the end of the day, however, if you simply can't get LINQ to generate reasonably performing SQL (note that I didn't say "neat" SQL; who cares what it looks like so long as it performs acceptably) you've always got the option of hooking stored procedures into either L2S or EF. My experience with LINQ so far is that you can almost always get it to write decent SQL... with some tweaks to the LINQ. And as you discover and learn these tweaks, your productivity in LINQ increases. L2S is harder to get right, as it'll happily do stupid stuff like N+1 queries generated from your one LINQ query. EF won't do that, which helps immensely.

Simon Raik-Allen commented on "More Lessons from the LINQ Database Query Performance Land"

Simon Raik-Allen — Wed, 20 Jul 2011 10:11:59 GMT

Nice post Daniel. I tend to find myself falling back to writing manual SQL for basically anything of importance (i.e., pulls lots of data or is called often).

What is your guideline for when to intervene with hand-crafted queries?

Daniel Chambers commented on "Sweeping Yucky LINQ Queries Under the Rug with Expression Tree Rewriting"

Daniel Chambers — Tue, 03 May 2011 06:43:45 GMT

As a spelling and grammar Nazi myself, I feel honour-bound to fix this. Thanks :)

Patagonian Toothfish commented on "Sweeping Yucky LINQ Queries Under the Rug with Expression Tree Rewriting"

Patagonian Toothfish — Tue, 03 May 2011 00:10:30 GMT

Nicely done!

Just one little nitpicky comment - the verb form of recursion is 'recur', not 'recurse' :)

Otherwise, a brilliant post...

-J