Is EntityFramework compatible with an Access 2007 database (.accdb)?

entity-framework ms-access

Question

I'm trying to create an MVC application that uses an Access 2007 DB (.accdb). I can create the Model using DataSet. But if I try to create a Model using EntityFramework, I can't get past VS2008 wanting to make the connection string be a SQL server. Am I missing something, or does EF not play with Access?

1
5
2/10/2010 2:01:50 AM

Popular Answer

The Entity Framework works only with ADO.NET providers that support it. To use your Access database, I assume you use the OleDB provider, which doesn't support EF. Microsoft provides only two ADO.NET providers that support EF : SQL Server, and SQL Server CE. However you can find third party providers for other DBMS :

There are probably many others, but as far as I know, nothing for Access (which IMHO in not much of a DBMS anyway...)

7
2/9/2010 9:04:10 PM


Related Questions





Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow