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
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…
Muhammad.Net
  • 9
  • 3
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
  • 78
  • 7
1
vote
2 answers

Scaffold existing local MS Access via .NET Framework: System.TypeLoadException: Method 'Create' in EntityFrameworkCore.Jet not implemented

I want to represent the datas of an existing local Access DB on a Homepage. For that I use ASP.NET MVC with Framework 4.7.2. I have to use EntityFrameworkCore.Jet, so I can't use Core. Following packages were…
mark_da_rat
  • 51
  • 8
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
  • 301
  • 1
  • 9
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
  • 298
  • 3
  • 11
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.
  • 799
  • 6
  • 19
1
vote
1 answer

Duplicate values Error on Non-Index, Non-Unique property change

I ask a similar question here, but this is a different situation that results in the same error message. I am updating an NON-index, NON-unique property, PageNumber. And I am receiving the following error OleDbException: The changes you requested…
TheColonel26
  • 2,618
  • 7
  • 25
  • 50
1
vote
1 answer

duplicate values in the index, primary key, or relationship

Using JetEntityFrameworkProvider and an MS Access/Jet File I am updating values of an Entity, and I am receiving the following error when I save changes. OleDbException: The changes you requested to the table were not successful because they would…
TheColonel26
  • 2,618
  • 7
  • 25
  • 50
0
votes
0 answers

How to migrate `bool` data type to `Yes/No` field?

I'm using EntityFrameworkCore.Jet and I have a model class with a bool data type: public class MyTestClass { ... public bool BoolField {get;set;} ... } When creating and applying a migration involving this class the target BoolField…
ShamilS
  • 1,410
  • 2
  • 20
  • 40
0
votes
1 answer

OleDbException Microsoft Access cannot find MSysAccessStorage

My project uses EntityFrameworkCore.Jet.OleDb v3.1 with provider in connection string Provider=Microsoft.ACE.OLEDB.12.0. The code's go through several iterations including RemoveRange followed by AddRange. Currently it's this boards.ForEach((board)…
Hey Mikey
  • 101
  • 6
0
votes
1 answer

Error opening MDB file on network location with EntityFrameworkCore.jet.oledb 3.1

I have a project opening up MS Access DBs on a network folder. The project is a .net core 3.1 webapi. EDIT: I'm using EntityFrameworkCore.Jet.OleDb v3.1 with provider in connection string Provider=Microsoft.ACE.OLEDB.12.0. It very simply updates a…
Hey Mikey
  • 101
  • 6
0
votes
0 answers

.NET 5 Connecting to MS Access mdb with Odbc

I am trying to connect my web application to an old MS Access mdb file. I found this page: https://learn.microsoft.com/en-us/dotnet/api/system.data.odbc.odbcconnection?view=dotnet-plat-ext-6.0 But I can't figure out how to work with connection…
ItsRicked
  • 1
0
votes
1 answer

Locking issue when trying to alter column data in migration up

I am trying to add an sql statement to an up-method of a migration for my current project. The database is an Ms Access database. The migrations get applied during run-time. The situation is as follows: I have a base Initial-create migration, which…
Tobias
  • 78
  • 7
0
votes
0 answers

JetEntityFrameworkProvider setup in VS2017

After compiling my project in VS2017 15.9.21 for.NET 4.5, I got following error, what am I missing? Unable to determine the provider name for provider factory of type 'JetEntityFrameworkProvider.JetProviderFactory'. Make sure that the ADO.NET…
Wojciech Szczurek
  • 3
  • 6
0
votes
0 answers

Cannot Scaffold-DbContext with EntityFrameworkCore.Jet on EF Core 5

I want to scaffold an old ms access database (.mdb). So I create a sln with Visual Studio 2019 for a console app. Then with nuget I add the following packages: EntityFrameworkCore.Jet" Version="3.1.0-alpha.4" Microsoft.EntityFrameworkCore"…
dgxhubbard
  • 703
  • 2
  • 7
  • 18
1
2
3