LINQ2SQL和SQL Server 2000 [英] LINQ2SQL and SQL Server 2000

问题描述

美好的一天！

我已经在SQL Server 2005中使用了LINQ2SQL，但是现在我需要在SQL Server 2000中使用它.我在MSDN上只发现了一篇文章，讲述了SQL Server 2000的Skip()和Take()怪异之处(这是因为我想缺少ROW_NUMBER()，仅此而已.

I have used LINQ2SQL with SQL Server 2005, but now I need to use it with SQL Server 2000. I have found only article on MSDN that tells about Skip() and Take() oddities on SQL Server 2000 (that's because it lacks ROW_NUMBER(), I suppose) and nothing more.

无论如何，有人对LINQ2SQL和SQL Server 2000的组合有经验吗.

Anyway, does anybody have experience with LINQ2SQL and SQL Server 2000 combination.

P.S.只是想知道:是否有可能在视图而非实际表上对LINQ2SQL类进行建模?

P.S. Just wondering: is it possible to model LINQ2SQL class on view, not a real table?

推荐答案

我一直在SQL Server 2000中使用Linq-to-SQL，并且可以正常工作-不确定Skip()和Take()-我没有不用.

I've been using Linq-to-SQL with SQL Server 2000, and it works - not sure about the Skip() and Take() - I didn't use those.

是的，您当然也可以将数据库中的视图拖到Linq-to-SQL设计器中-就像一个魅力.

And yes, you can definitely also drag views from your database into the Linq-to-SQL designer - works like a charm.

这篇关于LINQ2SQL和SQL Server 2000的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！