Stack Overflow
Stack Overflow

Questions tagged [jet-ef-provider]

Use for questions about connecting to mdb files and accdb files using Entity Framework and the JetEntitiyFrameworkProvider

The JetEntityFrameworkProvider is an open source Entity Framework provider that's independently developed (not by Microsoft) that's used for connecting to Access databases (*.mdb, *.accdb) using Entity Framework.

It only supports code first.

You can download it at GitHub or install it using NuGet.

38 questions
29
votes
3 answers

How to use Entity framework for MS Access database

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…
Shivam Sachan
  • 311
  • 1
  • 4
  • 9
13
votes
2 answers

Does Microsoft Jet DB work with Entity Framework?

In this forum here , someone mentions that Entity Framework does not work with Access (Jet DB - .mdb). However it seems that there is a provider for Jet DB as described here Which makes me think that the only thing I need with Entity Framework is to…
Saher Ahwal
  • 9,015
  • 32
  • 84
  • 152
9
votes
3 answers

Error Could not load type System.Data.OleDb.OleDbConnection from assembly System.Data when using Scaffold-DbContext, EntityFrameworkCore.Jet, .NetCore

I am trying to use Scaffold-DbContext from Entity Framework Core to create Models from an existing MS Access Database. In Package Manager Console when I run the command: Scaffold-DbContext "Provider=Microsoft.ACE.OLEDB.12.0;Data…
Fernando Ribeiro
  • 190
  • 1
  • 2
  • 9
6
votes
1 answer

Entity Framework Core and MS Access

I'm attempting to use an Access database from a WPF MVVM application using JetEntityFrameworkProvider and I can't get it to work. I've created the models, created the migrations using Add-Migration but when I run Update-Database, the command never…
mack
  • 2,715
  • 8
  • 40
  • 68
5
votes
1 answer

JetEntityFramework vs EF 6?

Throwing this up here since the author asks for help requests to go to StackOverflow. Have an existing app in progress, originally wrote to SQL Server. Sadly now there is a very old Access Database that I must talk to. Trying to use…
JoeHz
  • 2,136
  • 1
  • 18
  • 29
4
votes
1 answer

JetEntityFrameworkProvider - database first

I've been unable to get the JetEntityFrameworkProvider to work. Couple questions/comments (running VS2017, 6.4.1 nuGet for JetEntityFrameworkProvider) wanting to connect to a MS2016 access database. I watched the video but when I looked at the…
sleepybadger
  • 49
  • 1
3
votes
0 answers

Unexpected(?) dependency on Microsoft Database Engine Runtime 2010

I am using EntityFrameworkCore with the Jet-Provider to connect to an mdb-file. I am using the OleDB drivers with following connection string Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin; Data Source={0};Mode=Share Deny None;Jet OLEDB:Database…
Tobias
  • 78
  • 7
3
votes
1 answer

EntityFrameworkCore.Jet returns an error when trying to connect to MS Access DB

I'm new to Entity Framework, and I was trying to develop a simple C# script today, which would use Entity Framework Core Jet in order to list all of the companies specified in local MS Access DB. However, I keep getting an error in "OnConfiguring"…
Aleksandar Randjelovic
  • 63
  • 4
3
votes
2 answers

Rename column (and preserve data) with Entity Framework (code first) using Jet Engine

I am looking for a solution to rename a column of a table preserving the values using a Entity Framework code first migration with Jet Engine database provider (MS Access Database). I have tried several approaches from which none of them have worked…
Maddin
  • 298
  • 3
  • 11
3
votes
2 answers

HowTo update every row with unique value on migration using entity framework code first implementation

I am looking for an appropriate way to expand an existing database, based on entity framework 6 code first implementation, and adding unique values to the new field for every existing row in the table. So far I have created a migration which adds…
Maddin
  • 298
  • 3
  • 11
2
votes
1 answer

EntityFrameworkCore.Jet for .NET 6

EntityFrameworkCore.Jet is .NET Standard 2.0 compatible. Is there a pure .NET 6 version of a similar Access Database EF driver/provider? [Update] Clarification: By "pure .net 6.0 build" I don't mean to have (developed) MS Access .mdb and .accdb…
ShamilS
  • 1,410
  • 2
  • 20
  • 40
2
votes
0 answers

Connect to Microsoft access database from .net core version 6.0 project

I get error that error when I try to use EntityFrameworkCore.Jet with my .net core 6 app Method 'AppendIdentityWhereCondition' in type 'EntityFrameworkCore.Jet.Update.Internal.JetUpdateSqlGenerator' from assembly 'EntityFrameworkCore.Jet,…
Mohamed_R
  • 21
  • 4
2
votes
2 answers

Linq to SQL cannot translate because RowNumberExpression isn't supported

I have been trying to run a query where I want to group all the records by a specific property, then select the first from each list. I've been through a few iterations of this but it's safe to say the EF Core 3.0 onwards makes this a very hard…
sliminytim
  • 21
  • 2
2
votes
1 answer

Unable to Scaffold-DbContext with EntityFrameworkCore.Jet

I've been trying to generate the Entity Framework Models for an existing Database. I'm using the EntityFrameworkCore.Jet-Provider (v2.1.0 preview 5) with EntityFrameworkCore (v2.1.2) in Visual Studio 2017. I used the following command within the…
Severin Jaeschke
  • 661
  • 7
  • 22
2
votes
1 answer

How do I define Entity Framework provider in code?

I am using the JetEntityFrameworkProvider. I am trying to connect to an MS Access file (it has ext .sep but it is indeed an Access file). I am trying to define the connection string and provider in code, but it is not working. Before I run I get the…
TheColonel26
  • 2,618
  • 7
  • 25
  • 50
1
2 3