How to decide whether to use LINQ to SQL or ADO.NET

I'm just wondering which of the above technologies should use, and when SQL Server

  • What are the factors that can be used to determine which technology should be used.
  • Whether the performance of these technologies will act differently in a web application and a standalone application.

thanks

+4
source share
2 answers

Well, Linq2Sql is an extra layer on top of ADO.NET. Here is an ORM comparison for 4.0.net: Best ORM to use with C # 4.0

I would also recommend EF over Linq2Sql, even if EF still doesn't have simple things (like enumeration support).

+3
source

If you want to use the Linq2Sql adventure, but we will find out about it.

I suggest you use EntityFrameWork if you are using .Net Framework 4.0 .. In EntityFramework you can use Linq queries better than Linq2Sql files.

ADO.Net become old, and we need to learn new things from time to time.

0
source

Source: https://habr.com/ru/post/1401581/


All Articles