Update Detached Entities
Probably one of the most asked questions with LINQ to SQL, is how do you update detached entities. Often people will simply resort to doing a SELECT to get the entity into the datacontext and then update the data.
Steve Michelotti describes how to do it here:
http://geekswithblogs.net/michelotti/archive/2007/12/17/117791.aspx
and if your entity has child objects check this post out:
http://geekswithblogs.net/michelotti/archive/2007/12/30/118076.aspx
Entity Framework Tutorial/Overview
For an excellent write up on Entity Framework that is both an overview and tutorial in one, see Stefan Cruysberghs 3 part series.
It covers enough that it’s not too much information, but detailed enough to get you going rapidly.
Optimistic Concurrency Updates with Entity Framework
Cesar de la Torre has an excellent write up for managing concurrency with the Entity Framework.
Dynamic LINQ
Good blog post the describes using dynamic LINQ to create lambda expressions to use in LINQ.
Improve LINQ to SQL performance
While it is easy to get carried away with using LINQ to SQL, developers have the responsibility to understand what is going on under the hood and to ensure that things are running as smoothly and efficiently as possible.
The following blog post describes 10 tips from improving LINQ to SQL performance, highly recommended for anyone using LINQ to SQL.
LINQ Links
I recently came across a fairly good set of links all related to LINQ:
http://blogs.msdn.com/charlie/archive/2006/10/05/Links-to-LINQ.aspx
Entity Framework FAQ
With LINQ become more predominate every day, eventually some important will be asked as developers need to adopt new and different ways of accessing data repositories.
I recently came across a great (and detailed) FAQ that is sure to answer most questions.
http://blogs.msdn.com/dsimmons/pages/entity-framework-faq.aspx
I certainly answered my question, but not with the answer I was hoping for
. Automatic mapping between Enums and a column in a table is not supported.
http://blogs.msdn.com/dsimmons/pages/entity-framework-faq.aspx#_Does_the_EDM/EF
I hope they rethink this as that kind of simplicity is what increases adoption of new technologies. It’s one the things that convinced me to start using NHibernate. Even LINQ to SQL supports automatic enum mapping.