How do I convert an access.mdb file into an.edmx model?

.net asp.net-mvc-3 c# entity-framework ms-access

Question

Is it possible to create Entity Data Model (edmx file) from MS Access Database mdb file? If yes then how? I have tried using Entity Data Model Wizard, but there I could only choose sql databases.

I have website in MVC3 and I need to connect it to dsatabase that is in mdb file.

Any help much appreciated!

1
3
10/19/2011 12:52:19 PM

Accepted Answer

you are right, I was expecting to have also OLEDB or ODBC listed but there is only SQL Server and SQL Server Compact. Anyway if you are doing serious development at minimum use SQL Express or SQL Compact, both free and probably way better than old MS Access.

With the latest version of SQL Compact (4), it runs also in IIS and with Partial Trust so you can use it without any issue with your Hosting Provider, in case you do not want to pay for SQL connectivity.

like you find here: Microsoft SQL Server Compact 4.0

Enabled to work in the medium or partial trust environments in the web servers, and can be easily deployed along with the website to the third party website hosting service providers.

6
10/19/2011 1:02:22 PM

Popular Answer

MS Access is not supported by EF.



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