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.

29 questions
25
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
  • 271
  • 1
  • 4
  • 9
12
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
  • 8,230
  • 28
  • 75
  • 136
5
votes
2 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
  • 90
  • 1
  • 8
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,035
  • 1
  • 17
  • 27
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
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
  • 43
  • 3
3
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,298
  • 8
  • 33
  • 56
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 wich adds the…
Maddin
  • 138
  • 1
  • 10
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,138
  • 5
  • 22
  • 43
1
vote
0 answers

I can't compile JetEntityframeWork

I wanna use the MS Access database as DbFirst in my project using JetEntityframeWork. I try to enable DbFirst according to the installation guide of JetEntityframeWork here, but I can't. this is my steps to enabling: Download JetEntityframeWork…
Mhandes.Mohammad
  • 11
  • 2
1
vote
3 answers

Access database cannot create table with default datetime in migration

I have some trouble getting the migrations to create default datetime values for my tables. I am using the EF Core Jet provider and need to use MS Access-MDB-Files. My Connection string is the following: Provider=Microsoft.Jet.OLEDB.4.0;Jet…
Tobias
  • 36
  • 7
1
vote
0 answers

Perform CRUD operations on JetEntityFrameworkProvider

Question. How to perform CRUD operations on JetEntityFrameworkProvider? Description. I want to apply Entity Framework to work with MS Access. I am using: JetEntityFrameworkProvider. I created a project. I am running debugging. Result: Error: "Table…
climivin
  • 181
  • 8
1
vote
2 answers

EntityException: The underlying provider failed on Open. Can one server closing a db connection, make another server fail on opening?

I am experiencing database connection errors with an ASP.NET application written in VB, running on three IIS servers. The underlying database is MS Access, which is on a shared network device. It uses Entity Framework, code first implementation and…
Maddin
  • 138
  • 1
  • 10
1
vote
1 answer

EF Core JET: AccessViolationException when 'updating' changed objects in MS Access

I'm building a .NET Core 3 console app with EF Core 2.2.x and EntityFrameworkCore.Jet to perform some generic reading and writing from/to an access database (mdb). I'm compiling for x86 as the docs say. Goal is to migrate lost and lots of data from…
Erik J.
  • 756
  • 5
  • 18
1
vote
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
  • 138
  • 1
  • 10
1
2