If you're considering a move into the world of LINQ and Entity Framework, you have to consider the possibility that LINQ and Entity Framework won't let you issue some bizarrely complicated SQL ...

"I have seen simple select statements [in Entity Framework] with 4 or 5 includes result in nearly 5,000 line SQL statements when an equivalent hand-written SQL statement is [about] 15 lines." So reads ...

Unlike Entity Framework, LINQ to SQL is best used as a simple query and update mechanism without any customization aside from basic table mappings.

You can use the Object Services Layer to perform CRUD operations against the Entity Data Model. The Object Services layer also provides support for querying data using Entity SQL and LINQ.

Handling concurrency conflicts in Entity Framework Let’s now understand how each of these strategies work in Entity Framework.