I've Left Query Analyzer Hell For LINQPad Heaven

aneyfamily.com — So now that LINQPad has enabled intellisense SQL Server Management Studio, Query Analyzer, and even Joseph Albahari's (LINQPad creator) own QueryEx have all been zapped from my memory. I'll no longer flounder in antiquated ANSI SQL, but instead flourish in fully typed C#/LINQ code. This post explores extension methods that make LINQPad an even more power tool. read more...

add a comment | category: Linq | Views: 4

LINQ to SQL Batch Updates/Deletes: Fix for 'Could not translate expres

aneyfamily.com — I've found and posted a new fix in the code from my original post: Batch Updates and Deletes with LINQ to SQL. I'm not sure of the etiquette for this sort of thing: new post (like I'm doing) or just a comment in the original post. I want to be sure to make anyone who downloaded my code aware of an issue/fix (assuming they are monitoring via a RSS feed). read more...

add a comment | category: Linq | Views: 2

Batch Updates and Deletes with LINQ to SQL

aneyfamily.com — A couple weeks ago, I read the article, LINQ to SQL Extension: Batch Deletion with Lambda Expression by Jeffrey Zhao. In case you didn't read the article, it discusses the downside of most O/R Mapping frameworks when it comes to multiple updates or deletes. He states the fact that a SQL statement for each row flagged as update/delete in the entity set is created. I went about implementing something similar to what Jeffrey envisioned and I'll explain some of the hurdles I had to overcome to achieve it. read more...

add a comment | category: Linq | Views: 31