none
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

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