There is no doubt that tehre are some drawbacks to Linq to Sql. One of them is that the Sql statement is built dynamically so it is needed to be parsed and compiled each time you run it. Fortunately .Net 3.5 has a solution for this problem. System.Data.Linq namespace includes a class named CompiledQuery which [...]
Posts Tagged ‘Linq to sql’
Speed up Linq to Sql with compiled queries
Posted in C#, SQL SERVER, tagged C#, Compile, Compiled Query, Linq, Linq to sql, Performance, Query, SQL on August 15, 2008 | 2 Comments »
A 3-Tier Architecture with LINQ TO SQL
Posted in Architecture, C#, tagged 3-TIER, Architecture, BUSINESS LAYER, COMMON LAYER, DATA ACCESS LAYER, LAYER, Linq, Linq to sql, N-TIER, SQL on July 28, 2008 | 5 Comments »
Recently, I posted a 5-part article about developing a 3-tier architecture using ADO.NET. In this post, I am going to mention how to develop such an architecture using Linq to Sql. Since the last article was too long, I am going to make this one short. Therefore, the architecture is not changed and [...]
