ADO.NET Entity Framework with OLE DB Access Data Source ADO.NET Entity Framework with OLE DB Access Data Source database database

ADO.NET Entity Framework with OLE DB Access Data Source


To the best of my knowledge, this is not possible using an entity framework. You can however, use linq to dataset to access your Access (no pun intended) database.

http://msdn.microsoft.com/en-us/library/bb386977.aspx


EF cannot use OLE DB directly because an EF provider have to translate c# into specific SQL syntax (OLE DB is a connection to several DBMSs with several SQL syntaxes).

If you need an EF 6.1 provider for MS Access you can have a look herehttps://jetentityframeworkprovider.codeplex.com/