So with the recent news of LINQ to SQL going DOA a lot of those who have developed applications around it are probably hurting. I myself was shocked to hear that Microsoft would do such a foolish thing. This is one of the things that turns off people from using .NET and other Microsoft technologies....

I fully agree with Tim Mallalieu to recommend LINQ to Entities as the data access solution for your application. Sure, for an object-oriented view of the database LINQ to SQL was somewhat useful but in essence this is a scenario that the Entity Framework supports as well. Yes, in some ways the Entity...

Emitting live from a big ass room filled with data access geeks while doing a factory restore without Lenovo's crapware. Approximately two hours away from a cold beer and typical US food. DataSet Queryable, remotable, in-memory relation collection DBMS-Specific ADO.net data provider Direct access to...

Must use a common EntityKey throughout type hierarchy (database design consideration) Relationships must be based on EntityKey Functions results must be mapped to EntityTypes Can't map multiple entities to different columns of a single row If used, modification functions must include all CUD operations...

A topic that hasn't been addressed much really in documentation or talks is the customization of the generated data classes. According to Mike Pizzo we basically have the following four options each varying in terms of difficulty to use and/or implement in your own application scenarios. Generated Partial...

The Useless Introduction You Used To :) This post has taken so long to be started in writing. I’ve been busy with many events in my life lately. Suffering from frequent limited internet access lately, and, all this moving between companies thing has been eating me. And yes, I admit, I' have been as tired...

Not sure how many people are planning on attending the PDC (Professional Developers Conference) this year, but it is going to be a fantastic conference. We announced some huge announcements on the PDC web site.  http://www.microsoftpdc.com/ We have Read More......( read more )

Don't be fooled with the EDM designer in SP1 beta for VS.NET 2008. Apparently there was no need "yet" for in depth customizability of the store model schema. For my class table inheritance example I'm using table prefixes since I'm running many examples on the same database. The prefix I'm...

I must be overlooking something. The ID field in my SQL Server database is configured to autoincrement through setting the Identity seed and Identity increment properties. For some reason the generated code allows the end user of the conceptual EDM model to set the ID property since it’s public...

.NET VS2008 SP1 Beta and .NET Framework 3.5 SP1 Beta is now available Connection Pooling, ADO.NET, SPIDs The CLR Profiler for the .Net Compact Framework Series Index Introducing LINQ To Regex 11 More Visual Studio Shortcuts You Should Know Other IIS - Sample ISAPI Filter doing Redirection to another...