How to use Entity framework for MS Access database

entity-framework c#-4.0 jet-ef-provider
Shivam Sachan picture Shivam Sachan · Jul 11, 2012 · Viewed 73.4k times · Source

I have to develop a desktop windows application in C#.Net 4.0 that will run in three different databases ie. MS Access 2007 onwards, Oracle 11G, and SQL Server 2008. Now I want to use Entity Framework in my application. Is this a best choice to use EF for my application ? If yes, then how can I use entity framework for Access database? Thanks in Advance.

Answer

bubi picture bubi · Jan 5, 2015

You can use the EF with Microsoft Access using an Entity Framework provider for Microsoft Access. You can find an EF provider for Access

https://github.com/bubibubi/JetEntityFrameworkProvider

Related questions

No Entity Framework provider found for the ADO.NET provider with invariant name 'System.Data.SqlServerCe.4.0'

I got the following error when I used sqlce 4.0 with entityframework 6.0 No Entity Framework provider found for the ADO.NET provider with invariant name 'System.Data.SqlServerCe.4.0' My app.config looks like this .... <configSections> <section name="…

Read More
Better way to query a page of data and get total count in entity framework 4.1?

Currently when I need to run a query that will be used w/ paging I do it something like this: //Setup query (Typically much more complex) var q = ctx.People.Where(p=>p.Name.StartsWith("A")); //Get total result …

Read More
How to "let" in lambda expression?

How can I rewrite this linq query to Entity on with lambda expression? I want to use let keyword or an equivalent in my lambda expression. var results = from store in Stores let AveragePrice = store.Sales.Average(s => s.…

Read More