ADO.NET Entity Framework with OLE DB Access Data Source

Question

Has anyone found a way to make the ADO.NET Entity Framework work with OLE DB or ODBC data sources? Specifically, I need to work with an Access database that for various reasons can't be upsized to SQL.

This MSDN page says:

The .NET Framework includes ADO.NET providers for direct access to Microsoft SQL Server (including Entity Framework support), and for indirect access to other databases with ODBC and OLE DB drivers (see .NET Framework Data Providers). For direct access to other databases, many third-party providers are available as shown below.

The reference to "indirect access to other databases" is tantalising but I confess that I am hopelessly confused by all the different names for data access technology.

This is outside my bailiwick, but have you consider mounting the Access/Jet/ACE database as a linked server in SQL Server, and then utilizing the SQL Server provider? That would be the way I'd read the reference to "indirect access." — David-W-Fenton
– David-W-Fenton, Commented Feb 14, 2010 at 20:02
I'm pretty sure the "(including Entity Framework support)" bit applies only to SQL Server insofar as the MS provider goes. Linked server might be worth a shot. — Craig Stuntz
– Craig Stuntz, Commented Feb 15, 2010 at 14:21

JeremyS · Accepted Answer · 2012-03-01 12:17:29Z

1

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

edited Mar 1, 2012 at 12:17

answered Mar 1, 2012 at 11:12

JeremyS

3291 gold badge3 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

bubi · Accepted Answer · 2014-12-01 16:08:08Z

1

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 here https://jetentityframeworkprovider.codeplex.com/

answered Dec 1, 2014 at 16:08

bubi

6,5013 gold badges32 silver badges50 bronze badges

Comments

Lee · Accepted Answer · 2011-08-15 09:00:36Z

0

I am not so sure about using Access with EF in particular, but it does seem possible to use linq with access. http://social.msdn.microsoft.com/Forums/en/adodotnetentityframework/thread/985a1048-cf56-4bb0-b664-61fbf4957890

answered Aug 15, 2011 at 9:00

Lee

8,81415 gold badges58 silver badges92 bronze badges

Collectives™ on Stack Overflow

ADO.NET Entity Framework with OLE DB Access Data Source

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related