Using the ADO.NET Entity Data Model and an ACCESS Database?

Question

I'm using:

Visual Studio 2013
.NET Framework 4.5.1
Microsoft Access 2010

I'm currently working on a C# school project that doesn't require us to use a database at all, however we can grab some extra credit if we implement a database.

I've worked with SQLite so far and had not much trouble setting up the connection, however we are limited to Access for the project.

I would like to use the database in an ADO.NET Entity Data Model, but upon trying to add the .edmx Item via the solution explorer it doesn't let me choose "Access Database".

Is there any way to get an Access Database and the EDM to work together?

Download Access ADO.NET Provider then install it the option will be availible — imdisney
– imdisney, Commented Jan 31, 2018 at 12:46

magicandre1981 · Accepted Answer · 2018-01-31 15:48:57Z

1

There is a JetEntityFrameworkProvider available on github. Compile the code and run the Install.cmd from JetDdexProvider folder:

To get DDEX Provider installed.

answered Jan 31, 2018 at 15:48

magicandre1981

29k5 gold badges93 silver badges134 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Using the ADO.NET Entity Data Model and an ACCESS Database?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related