LINQ to SQL - TOP 5 of problems - Anko Duizer
Anko Duizer, in years the oldest Class-A-er. Anko will blog about his favorite product Microsoft SQL Server. Furthermore, you may find post about architecture, WF, MSF and software development general. LINQ to SQL - TOP 5 of problems The last few weeks I had the opportunity to present several times about LINQ to SQL. I am very enthusiastic about the possibilities of LINQ to SQL. But I experience some problems with the LINQ to SQL technology as well. Although I realize that we will experience the real problems the upcoming months I like to publish the problems I experience today: #1 LINQ to SQL is designed for a two tier scenario. LINQ to SQL does not fits natural with a multi layer architecture. #2 It is not possible to tune the SQL Server queries generated by LINQ to SQL. #3 LINQ to SQL generates dynamic SQL. The technology strongly motivates to use dynamic SQL instead of stored procedures. #4 LINQ to SQL encourages to a "SELECT *...