title: Entity Framework with OleDB connection - am I just plain nuts?
body: <p>I'm experimenting with the Entity Framework and I want to connect to an Access 2007 database.</p>
  
  <p>The following code is inspired by <a href="http://msdn.microsoft.com/en-us/library/system.data.entityclient.entityconnection.connectionstring.aspx" rel="noreferrer">http://msdn.microsoft.com/en-us/library/system.data.entityclient.entityconnection.connectionstring.aspx</a> </p>
  
  <p>I suspect that I've got the wrong end of the stick...</p>
  
  <pre><code>OleDbConnectionStringBuilder oledbConn = new OleDbConnectionStringBuilder();
  
  oledbConn.DataSource = @"..\..\..\..\Pruebas.accdb"; //yep Access 2007!
  
  EntityConnectionStringBuilder entityBuilder = new EntityConnectionStringBuilder ();
  entityBuilder.Provider = "Microsoft.ACE.OLEDB.12.0";
  entityBuilder.ConnectionString = oledbConn.ToString();
  EntityConnection ec = new EntityConnection(entityBuilder.ToString());
  ec.Open();
  ec.Close();
  </code></pre>
  
  <p>The EntityConnectionStringBuilder tells me that it doesn't support the DataSource property.  I can connect fine with ADO.net so I know that the path and the provider are correct.</p>
  
  <p>Is this just the complete wrong approach?</p>