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...

Previously I have been talking about the limitations of Linq to SQL for your data layer. You should read it here . This post is part of the Linq to SQL series . Linq to SQL is a great technology I found that adding the data layer on the web application will just work until you are deploying the application...

LINQ to SQL came out with 3.5 and I am still amazed that many people accomplished to stay away from that simple technology. When you ask them, they've heard about but they are not sure how everything works together. Instead of looking it up to learn to see if there is something that may improve their...

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...

In this post, I will show you how you can architect your Linq To Sql repository which will have 100% code coverage. I will use our favorite Northwind database along with my ongoing UnityCommonServiceLocatorMVC project. First, lets add a Linq To Sql diagram in our project and drag n drop the Category...

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 am writing a small web shop application using ASP.NET MVC Framework . As a part of this project I also write unit test and integration tests. I am using LINQ To SQL Classes as a mapping solution in my project. I found one misleading behaviour of LINQ To SQL Classes when writing integration tests. Look...

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...