VS 2010 and Entity Framework: accessing SQL Server 2000 databases

Posted by pcampbell on Stack Overflow See other posts from Stack Overflow or by pcampbell
Published on 2010-05-13T20:00:18Z Indexed on 2010/05/13 20:04 UTC
Read the original article Hit count: 831

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

The first step is creating a new ADO.NET Entity Data Model item.

The Entity Data Model Wizard prompts for a Data Connection.

alt text

When creating a new Connection, you will need to use a provider other than SqlClient. Usually it's SQLOLEDB.

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

alt text

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

© Stack Overflow or respective owner

Related posts about visual-studio-2010

Related posts about entity-framework