Answered by:
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
Thursday, August 18, 2011 5:57 AM
Answers
-
There is no oob implementation provided by EF for Access, you can writer your own provide though!!
Regards, Madhukar Gilla- Proposed as answer by madhugilla Thursday, August 18, 2011 10:08 AM
- Marked as answer by Larcolais Gong Thursday, August 25, 2011 9:44 AM
Thursday, August 18, 2011 7:23 AM -
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- Marked as answer by Larcolais Gong Thursday, August 25, 2011 9:44 AM
Thursday, August 18, 2011 8:04 AM
All replies
-
There is no oob implementation provided by EF for Access, you can writer your own provide though!!
Regards, Madhukar Gilla- Proposed as answer by madhugilla Thursday, August 18, 2011 10:08 AM
- Marked as answer by Larcolais Gong Thursday, August 25, 2011 9:44 AM
Thursday, August 18, 2011 7:23 AM -
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- Marked as answer by Larcolais Gong Thursday, August 25, 2011 9:44 AM
Thursday, August 18, 2011 8:04 AM -
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).Monday, September 19, 2011 7:25 AM
-
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:
Tuesday, January 5, 2016 8:28 AM