开发者

Does EntityFramework work against an Access 2007 db (.accdb)?

开发者 https://www.devze.com 2022-12-19 12:25 出处:网络
I\'m trying to create an MVC application that uses an Access 2007 DB (.accdb).I 开发者_如何学Gocan create the Model using DataSet.But if I try to create a Model using EntityFramework, I can\'t get pas

I'm trying to create an MVC application that uses an Access 2007 DB (.accdb). I 开发者_如何学Gocan 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?


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 :

  • SQLite
  • MySQL
  • DevArt providers for several DBMS (commercial)

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

0

精彩评论

暂无评论...
验证码 换一张
取 消