tags:

views:

994

answers:

2
+3  Q: 

Which versions of SQL Server does LINQ to SQL support?

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

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

+3  A: 

Yes, you can.

LINQ to SQL adapts the generated queries to work with 2000.

Mehrdad Afshari  2009-01-16 21:19:19
I'd be happy to know the reason for downvote!
Mehrdad Afshari  2009-01-18 21:31:41
Me too...the answer was basically correct so I upvoted you to get rid of the downvote.
Mark Brittingham  2009-01-22 11:22:22
+8  A: 

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.

Mark Brittingham  2009-01-16 21:21:17
It is also available in 2000 but it is less efficient. LINQ to SQL uses a nested SELECT TOP n statement for that case instead.
Mehrdad Afshari  2009-01-16 21:25:55
Hi Mehrdad - good tip but you are right, that grows very inefficient very quickly as you page through the dataset!
Mark Brittingham  2009-01-16 21:28:24
I've updated my answer to reflect your comments.
Mark Brittingham  2009-01-16 21:32:42
But it's still much better than paging on the client side.
Mehrdad Afshari  2009-01-16 21:33:50

related questions

How to find an implementation of a C# interface in the current assembly with a specific name?
Learning about LINQ
LINQ to SQL Mapping From Money to Double
SQL Server 2008 vs 2005 Linq integration
Aging Data Structure in C#
LINQ-to-SQL vs stored procedures?
LINQ, entity that implements Interface and exception in mapping
How can I remove nodes from a SiteMapNodeCollection?
Conditional Linq Queries
LINQ query on a DataTable
Expression.Invoke in Entity Framework?
How to return a page of results from SQL?
Import Namespace System.Query
Has anyone run performance benchmarks comparing LINQ
Beginners Guide to LINQ
Querying like Linq when you don't have Linq.
Linq to objects - select first object
C# 3.0 Where extension method with lambda vs LINQtoObjects to filter in memory collections.
How much database performance overhead when using LINQ?
LinqDataSource - Can you limit the amount of records returned?
LINQ on the .NET 2.0 Runtime
How do I most elegantly express left join with aggregate SQL as LINQ query
How do you page a collection with LINQ?
How do I get a distinct, ordered list of names from a DataTable using Linq
How do I fill a DataSet or a DataTable from a LINQ query resultset ?