Subsonic 3 LINQ 与 LINQ to SQL
我在一个项目中使用SQL Server 2005。 我必须决定数据层。 我想在我的项目中使用 LINQ。 我看到 SubSonic 3 支持 LINQ，而且我还可以选择 LINQ to SQL，因为我可以从 LINQ to SQL 输入列表。
我想知道 LINQ to SQL 和 Subsoinc 3 LINQ 之间有什么不同，哪个有好处？
谢谢！ 贾米尔
I am using SQL Server 2005 in a project. I have to decide about datalayer. I would like to use LINQ in my project. I saw SubSonic 3 supporting LINQ and I also have option for LINQ to SQL, because i can have typed lists from LINQ to SQL.
I am wondering what is different between LINQ to SQL and Subsoinc 3 LINQ, Which is beneficial?
Thanks!
JAMIL
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
如果您还没有阅读过本文，Subsonic 网站有一个相当长的概述，介绍了 LinqToSql 和 Subsonic（以及 NHibernate）之间的一些差异。
http://subsonicproject.com/docs/Comparisons
除了技术的具体差异之外，您还可以想要考虑使用开源第三方工具与微软官方产品的影响。 各有利弊！ ;)
In case you haven't read this already, the Subsonic site has a pretty lengthy overview of some differences between LinqToSql and Subsonic (and NHibernate).
http://subsonicproject.com/docs/Comparisons
Outside of specific differences of the technologies, you may also want to consider the implications of going with an open-source 3rd party tool vs an official Microsoft product. There are pros and cons to each! ;)
虽然NHibernate比Linq2SQL有更好的ORM，但是NHibernate Linq非常非常有限。
如果想法是使用 LINQ，请选择 Linq2SQL，因为 Subsonic 也有一些限制。
如果从等式中删除 LINQ，那么 NHibernate 将是最佳解决方案，但仅适用于复杂且大型的应用程序。
对于小型企业，使用 Subsonic 甚至 Linq2SQL
although NHibernatebe greater ORM than Linq2SQL, NHibernate Linq is very very limited.
If the idea is to use LINQ, choose Linq2SQL, because Subsonic also have several limitations.
If you remove LINQ from equation, then NHibernate will be the best solution, but only for complex and bigger applications.
For small ones, uses Subsonic or even Linq2SQL
LinqToSql 有许多非常显着的缺点，而且它几乎从来都不是正确的解决方案。
SubSonic 3 具有 LinqToSql 的许多优点，但缺点很少。
如果你必须在这两者之间做出选择，SubSonic 是一个非常明显的赢家。
最后，NHibernate 明显优于两者，对于大多数项目来说，它显然是最好的选择。
也就是说，SubSonic 可以让您走得更远，它是一个很好的产品。 您只需要意识到存在一些限制以及 NHibernate 无法做到的地方。
LinqToSql has many very significant downsides and it's almost never the right solution.
SubSonic 3 has many of the benefits of LinqToSql with few of the downsides.
If you must choose between these two, SubSonic is a very clear winner.
In the end, NHibernate is significantly better than both and for most projects it is clearly the best way to go.
That said, you can go a long way with SubSonic and it is a good product. You just need to be aware that there are limitations and places it won't go that NHibernate will go.