LINQ TO SQL
Linq-To-SQL is the lightweight,
straightforward, MS-SQL Server only technology
Advantages:
- Reduction in work, Faster development
- Strongly typed code (Type Safety).
- A common syntax for all data.
- Compile check when database changes
- Auto-generated domain objects that are usable small projects
- Lazy loading feature can speed up performance & at least simplify the code a lot.
- Debugging support
Disadvantages:
- Support for SQL Server only
- No direct execution against database
- Not suitable for handling large amount of data, like filling dataset.
Performance:
- Insert operations are better in LINQ, the read operation is superior in ADO. (http://www.codeproject.com/KB/linq/performance_comparisons.aspx)
- In some Real world comparison, it shows LINQ is much slower than the SqlDataReader (http://devtoolshed.com/content/performance-benchmarks-linq-vs-sqldatareader-dataset-linq-compiled-queries-part-2)
- While handling large amount of data, It is advisable to swap some linq queries with stored procedures or ADO.NET
Tags: Advantages of linq to sql, limitations linq to sql, linq to sql performance, about linq to sql
No comments:
Post a Comment