title: VS 2010 and Entity Framework: accessing SQL Server 2000 databases
body: <p>Consider a Visual Studio 2010 project whose requirement is to model the data using Entity Framework. The datasource is a SQL Server 2000 database.</p>
  
  <p>The first step is creating a new ADO.NET Entity Data Model item.</p>
  
  <p>The Entity Data Model Wizard prompts for a Data Connection.</p>
  
  <p><img src="https://i.imgur.com/6fD6e.png" alt="alt text"></p>
  
  <p>When creating a new Connection, you will need to use a provider other than <code>SqlClient</code>. Usually it's <code>SQLOLEDB</code>.</p>
  
  <p>The list of data providers only has <code>SqlClient</code> or ".NET Framework Data Provider for SQL Server".</p>
  
  <p><img src="https://i.imgur.com/anGWO.png" alt="alt text"></p>
  
  <ul>
  <li>Is there a work-around for Visual Studio 2010 to create or use data connections to SQL Server 2000 using the Entity Framework?</li>
  </ul>