how to Connect to access Database using Entity framework 4.0

Question

Hi,

I am using provider Microsoft.Jet.OLEDB.4.0 for Microsoft Access Database. I want to connect to access database with entity framework 4.0. how do I achieve it?

Regards,

Bhaskar J

Answer 1

There is no oob implementation provided by EF for Access, you can writer your own provide though!!

---

Regards, Madhukar Gilla

Answer 2

If you're just interested in leveraging Linq over your data, you could try using Linq to DataSet - 

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

---

Adi Unnithan | Software Design Engineer | SQL Server Developer Tools | Please mark the post as answered if it sufficiently answers your question

Answer 3

How would one achieve this? I'm in the same bind, too many sites have Access databases that my code will need to talk to, a whole sale conversion of this to sql is not viable-as this is the local content database (though sql is used as the central datastore).

Answer 4

For EF 6 you can find a provider on NuGet (search for JetEntityFrameworkProvider).

If you need DB First you need to download the source code (of the whole provider) from here:

https://jetentityframeworkprovider.codeplex.com/