LINQ to SQL Performance Considerations
The text of this article is not in this database — only its details are. Read it on the old site: LINQ to SQL Performance Considerations
4 Comments
Join the conversation! Your thoughts help the community grow.
Sign in to leave a comment.
Mike GaleeditedPosted Apr 8, 2010, 6:16 PMEdited Apr 8, 2010, 7:40 PM
It's great to see a real world evaluation from somebody who knows the territory and is thorough. This sort of thing is a gold mine for serious developers. If you tied this up with the recently announced profiling product for L2S, http://l2sprof.com/, you might get some additional insights. I've been playing with the fundamental choice of L2S, L2EF vs Plinqo recently. It's complex but L2EF seems not yet ready. Plinqo has some optimisation and control over bare L2S, which I haven't tried, but which promises better performance. The text/blog/forum discussions about that choice are difficult and time consuming to figure out. So I put together a suggestion system that might help others with the decision, it's at http://www.decisionz.com/Services/Samples/LinqToolRating.aspx. If it garners enough interest I'll consider taking it a bit further. (With an introduction to it here.
madishetti shiva shankarPosted Apr 5, 2010, 10:40 AM
GOOD to know when to use LINQ against the database for queries madishetti shiva shankar