LINQ to SQL is fascinating - the more I work with it, the more I hate it, and then love it again all at the same time. Recently we had an issue while using it in a slightly older version of our N-Tier WCF application which uses LINQ to SQL as it's primary ORM solution (yes, I know). I'll try to briefly...

Batch deletion in the O/R Mapping frameworks is always depressing. We need to query all the entities we want to delete from the database, pass them to the DeleteOnSubmit or DeleteAllOnSubmit methods of DataContext, and finally invoke SubmitChanges to delete the records form database. In this case, we...

Building functions instead of expression trees. The functional programming features of the latest versions of C# allow developers to harness a very expressive programming paradigm to solve challenges in new, elegant ways. Two of the very interesting new features are the “Func<>” delegate and the...

Yesterday I posted an entry describing a method for building functions as opposed to building expressions to get a more succinct syntax, and in general a more functional approach. There was a touch of reflection in there though, so I wasn’t too sure what the performance would be like. Even though the...

I have been using LINQ to SQL on a WinForms project. I have played around with LINQ in the past but have never had the opportunity to use it on a project. I have used SQL Server for probably about 10 years now and consider my T-SQL skills to be pretty decent. So something such as renaming a column in...

Recently when I was using LINQ to SQL (which I happen to love so much) and using the LINQ to SQL debug visualizer tool (which can be found here ) to see what query was getting generated I came across an issue. below is a screen-shot of the query I was looking at. If I inspected it in the quick-watch...

[ LINQ via C# series ] The core of LINQ to Objects is IEnumerable<T>: Query methods are designed for IEnumerable<T> as extension methods , like Where(), Select(), etc.; Query methods are designed to be fluent, LINQ to Objects queries can be written in declarative paradigm via method chaining...

[ LINQ via C# series ] Since LINQ to SQL is translating C# methods into SQL, all the C# methods are required to make sense in SQL. According to MSDN : A local method call is one that is executed within the object model. A remote method call is one that LINQ to SQL translates to SQL and transmits to the...

[ LINQ via C# series ] After understanding: object model generating from SQL Server schema query method chaining on IQueryable<T> SQL are translated from expression tree, which is required by IQueryable<T> now it is time to take a deeper look at the detail of SQL Server data CRUD manipulation...

[ LINQ via C# series ] In LINQ to Objects, lamda expressions are used everywhere as anonymous method, like Where(): public static IEnumerable <TSource> Where<TSource>( this IEnumerable <TSource> source, Func <TSource, bool > predicate) while in LINQ to SQL, mostly lambda expressions...