ADO.NET - 实体数据模型与LINQ to SQL

时间:2022-10-14 02:13:42

I am trying my best to understand what is the difference between "ADO.NET - Entity Data Model" and "LINQ To SQL", but I cannot figure it out. Can someone please explain the differences between the two and the advantages and disadvantages?

我正在尽力理解“ADO.NET - 实体数据模型”和“LINQ To SQL”之间的区别,但我无法弄明白。有人可以解释一下两者之间的区别和优缺点吗?

Thanks Frank

2 个解决方案

#1


Linq to SQL was actually a proof of concept for Linq. See The Origin of LINQ to SQL. Microsoft is putting its weight behind Entity Framework, although I believe it's not quite ready for prime time.

Linq to SQL实际上是Linq的概念证明。请参阅LINQ to SQL的起源。微软正在重视实体框架,尽管我认为它还没有为黄金时间做好准备。

Anyway, this * post provides some additional detail about the differences.

无论如何,这个*帖子提供了一些关于差异的额外细节。

#2


Linq to SQL is said to be dead (I don't think so though - it was way to well received by the development community). Entity Framework is its successor, if you want. It can access more data sources (more database types, and also different kinds of sources such as reporting services, business intelligence etc.). It's much more complex than Linq to SQL, and has a steeper learning curve, for example EF allows one class-multiple tables mapping. Other things are not possible with EF, such as specifying deferred loading - that's Linq to SQL only.

据说Linq to SQL已经死了(我不这么认为 - 这是受到开发社区欢迎的方式)。如果您愿意,实体框架是其继承者。它可以访问更多数据源(更多数据库类型,以及报告服务,商业智能等不同类型的源)。它比Linq更复杂,并且具有更陡峭的学习曲线,例如EF允许一个类多表映射。 EF无法实现其他功能,例如指定延迟加载 - 仅限Linq to SQL。

#1


Linq to SQL was actually a proof of concept for Linq. See The Origin of LINQ to SQL. Microsoft is putting its weight behind Entity Framework, although I believe it's not quite ready for prime time.

Linq to SQL实际上是Linq的概念证明。请参阅LINQ to SQL的起源。微软正在重视实体框架,尽管我认为它还没有为黄金时间做好准备。

Anyway, this * post provides some additional detail about the differences.

无论如何,这个*帖子提供了一些关于差异的额外细节。

#2


Linq to SQL is said to be dead (I don't think so though - it was way to well received by the development community). Entity Framework is its successor, if you want. It can access more data sources (more database types, and also different kinds of sources such as reporting services, business intelligence etc.). It's much more complex than Linq to SQL, and has a steeper learning curve, for example EF allows one class-multiple tables mapping. Other things are not possible with EF, such as specifying deferred loading - that's Linq to SQL only.

据说Linq to SQL已经死了(我不这么认为 - 这是受到开发社区欢迎的方式)。如果您愿意,实体框架是其继承者。它可以访问更多数据源(更多数据库类型,以及报告服务,商业智能等不同类型的源)。它比Linq更复杂,并且具有更陡峭的学习曲线,例如EF允许一个类多表映射。 EF无法实现其他功能,例如指定延迟加载 - 仅限Linq to SQL。