VS 2010 and Entity Framework: Access to SQL Server 2000 Databases

Question

Consider a Visual Studio 2010 project whose task is to model data using the Entity Framework. The data source is a SQL Server 2000 database.

The first step is to create a new Entity Data ADO.NET data item.

The Entity Data Model Wizard requests a data connection.

When creating a new connection, you need to use a provider other than SqlClient . This is usually SQLOLEDB .

The list of data providers has only SqlClient or the ".NET Framework Data Provider for SQL Server".

• Is there a need for Visual Studio 2010 to create or use connections to SQL Server 2000 using the Entity Framework?

Answer 1

Unfortunately, SQL Server 2000 is not supported.

Entity Framework v2

Answer 2

We were able to use EF with sql 2000 by setting the initial context to vs2005 and then upgrading to vs. 2010. Awful, but it worked.

UPDATE:

I decided to write instructions for everyone who needs to do this. We have not seen any side effects and allow the use of the constructor VS 2010.

How to use Entity Framework 4 with Visual Studio 2010 and SQL Server 2000