Entity Framework for MS Access

Question

Hi All Can I create .edmx from MS Accss database ?

Umberto Ballestrazzi · Answer

There is an EF 6.1 provider for MS Access you can check it here https://jetentityframeworkprovider.codeplex.com/ Actually it does not support DB First so I think you can't create edmx files

Jignesh Trivedi · Answer

hi i think Entity Framework does not support OLEDB connections. so you can use LINQ to SQL instead of this and must use strongly type dataset. please refer http://social.msdn.microsoft.com/Forums/en-US/linqtosql/thread/d9fd4cf1-dd2e-4857-990b-07b148f08505 http://p2p.wrox.com/book-stephens-c-programming-visual-studio-2010-24-hour-trainer/86339-lesson-38-using-linq-sql-access.html hope this will help you.

Jay S · Answer

There isn't actually a provider for EF to MS Access... An alternative is to use Linq to Dataset: http://msdn.microsoft.com/en-us/library/bb386977.aspx http://blogs.msdn.com/b/adonet/archive/2007/01/26/querying-datasets-introduction-to-linq-to-dataset.aspx