EntityFrameworkCore.Jet
EntityFrameworkCore.Jet copied to clipboard
bubibubi
Entity Framework Core provider for Access database
With .Net 7 and Entity Framework Core 7 out now I have created this topic for any questions regarding the status of EFCore.Jet for EF 7
Many environment variations (x64/x86, ODBC/OLE DB, ACE 12.0/16.0) currently crash the test runner. Probably (at least in part) related to #43. Recent discussion in #152.
> [...] > It should also be mentioned, that recent Access database versions have an actual (opt-in) [large number data type](https://support.microsoft.com/en-au/office/using-the-large-number-data-type-5b623f6e-641d-4e97-8bdf-b77bae076f70). > [...] > _Originally posted by @lauxjpn in https://github.com/bubibubi/EntityFrameworkCore.Jet/issues/151#issuecomment-1759785304_...
I tried to run a skip on and got error: > "Jet does not support skipping rows." Could you implement skip functionality usings the method below taken from https://stackoverflow.com/a/10455965/12439476: If...
Just wanted to let everyone know that if you are getting this COM exception while running the tests, installing the [Microsoft Access Database Engine 2016 Redistributable](https://www.microsoft.com/en-us/download/confirmation.aspx?id=54920) will solve this hard...
 Microsoft.EntityFrameworkCore.Database.Command: Error: Failed executing DbCommand (4ms) [Parameters=[@__TypedProperty_0='?' (Size = 50)], CommandType='Text', CommandTimeout='30'] SELECT 'TotalDebit' AS `Name`, IIF(SUM(`t0`.`AMMOUNT OWE`) IS NULL, 0.0, SUM(`t0`.`AMMOUNT OWE`)) AS `Value`, 'TotalPaid' AS...
@lauxjpn Microsoft have removed the page for downloading the 2010 version of the access database engine. Thus our CI system fails on all 2010 workflows
If no suitable driver is installed on the machine this code throws exception: https://github.com/CirrusRedOrg/EntityFrameworkCore.Jet/blob/4dda3e41d5e2e55beb87b2efb20a576c7dcd7c9a/src/EFCore.Jet.Data/JetConnection.cs#L586 The message in log in this case does not say the problem: ` An error occurred...
Opening this issue for any questions on the EF Core 9 support. Work has begun and the `master` branch is now targeting EF Core 9 (dependent on preview 7). EF...