Geek Answers Handbook

Does EntityFramework work with db Access 2007 (.accdb)?

I am trying to create an MVC application using DB Access Access (.accdb). I can create a model using a DataSet. But if I try to create a model using EntityFramework, I cannot get past VS2008, wanting to make the connection string an SQL server. Am I missing something, or is EF not playing with Access?

+5
source share
1 answer

Entity Framework only works with ADO.NET providers that support it. To use the Access database, I assume that you are using an OleDB provider that does not 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 DBMSs:

There are probably many others, but as far as I know, nothing is for Access (that IMHO is not in the DBMS anyway ...)

+6
source

More articles:


All Articles