LINQ to SQL支持哪些版本的SQL Server? [英] Which versions of SQL Server does LINQ to SQL support?

问题描述

SQL Server 2000可以用作LINQ to SQL的数据库吗?

Can SQL Server 2000 be used as the database for LINQ to SQL?

LINQ to SQL是否依赖于特定版本的Microsoft SQL Server?

Does LINQ to SQL rely on a specific version of Microsoft SQL Server?

推荐答案

是的，LINQ to SQL可以与SQL Sever 2000一起使用，但有一个例外:您确实需要ROW_NUMBER()函数(仅在SQL Server 2005/2008中可用)才能执行以下操作:支持高效的服务器端分页.没有它，分页功能(如Mehrdad所指出的)将使用经典的Top N策略来传递-在遍历数据集的过程中，非常效率很低，因为最终您会舍弃大多数选定的记录第三页.

Yes, LINQ to SQL works with SQL Sever 2000 with one exception: you do need the ROW_NUMBER() function, available only in SQL Server 2005/2008, to support efficient server-side paging. Without it, paging functions (as Mehrdad points out) are delivered using the classic Top N strategy - very inefficient as you page further and further through your dataset because you end up throwing out most of your selected records from the third page on.

这篇关于LINQ to SQL支持哪些版本的SQL Server?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！