Voow, I am almost done. On this Sunday night, at Panera, I have enjoyed writing while listening to the jazz and drinking coups of tea (3, so far). Alright, let's summarize briefly what we have done so far in these series: After giving some intro, In this complete but simple web application, we import...

Part II of the Southeast Valley .NET User Group ORM comparison happened yesterday.  It started off nice and calm but ended with a bang or two.  No there were no fight or arguments between the presenters or attendees but mother nature let loose on the Phoenix area last night.  Especially...

The July July and August 2008 meetings of Southeast Valley .Net Users Group ( SEVDNUG ) will host a comparison of different Object Relational Mapper / Data Access Layer technologies. Requirements have been to established so that there is a common database and user interface to compare these technologies...

So in researching another series I am writing I got a wild desire to do some Linq to SQL performance testing. So I whipped up a database table and populated it with data and went about writing some code. What you'll see in the code is 4 tests one with a fairly standard Linq query and a loop through the...

I've just discovered something very beautiful in LINQ to SQL (which I already loved before seeing this). This is one of the most difficult problems to overcome using Microsoft SQL Server, and the solution that the LINQ team came up with is very clean and insightful. It's a quick read: http://www.singingeels...

Problem: You want (need to because of the stubborn dba!) to use stored procedures in your next project and would also like to take advantage of the new features in .Net 3.5 like LINQ and extension methods, implicitly typed variables etc. I particularly don't like to use the implicitly typed variables...

Gospel of the GUID - Answers to your Burning Questions, Comments and Insults. First and foremost, I was blown away with the number of nice responses and questions to my Gospel of the GUID post. For the most part, I got a lot of “wow, I never thought of that” and “cool, we do that too, glad to see someone...

The Gospel of the GUID There is only one commandment in the Gospel of the GUID: I. Thou shalt always use a GUID to uniquely identify a row in a table. Whenever I hire a new member for my team, this is one of the first rules that I teach them. At first, they almost always look at me like a puppy with...

Over the last few weeks I've been writing a series of blog posts that cover LINQ to SQL. LINQ to SQL is a built-in O/RM (object relational mapper) that ships in the .NET Framework 3.5 release, and which enables you to model relational databases using .NET classes. You can use LINQ expressions to query...

Over the last few weeks I've been writing a series of blog posts that cover LINQ to SQL. LINQ to SQL is a built-in O/RM (object relational mapper) that ships in the .NET Framework 3.5 release, and which enables you to model relational databases using .NET classes. You can use LINQ expressions to query...