3191ca6851
Fix some conversion errors when getting a numeric value. See detailed notes in the GetInt32 function
2 years ago
a594e2f81f
DISTINCT AND TOP can't be in the same stateement with Jet. Push DISTINCT into a subquery
2 years ago
2281916b88
Fix generating sets (union, intersect). The code was originally executing and returning before it could handle adding the SQL for the Alias in (including wrapping the section in brackets). This realigns with how the parent VisitSelect works
2 years ago
d78256f53d
update tests
2 years ago
a2dc62d12d
Fix the formatting for a string literal of a byte
2 years ago
1090ee3b8f
Make sure the start index for Instr is set. Normally is optional but it seems some sections seem to prefer it to be defined
2 years ago
34f124c0f8
Update to .Net 8
2 years ago
6f38fe6e90
Update tests
2 years ago
db7a513b64
Remove the DeepSkip tag on FirstOrDefault. When generating the sql it was preventing the TOP expression from being generated
2 years ago
fbf0f794a7
use .GetMAppStoreObjects to try get the correct table (this is especially needed for properties in split tables). Default to the original storeObject if can't find anything
2 years ago
9e6617903f
v7.0.3
2 years ago
3ff59259ed
Use the correct function in SQL for Date (Jet doesn't do GetUTCDate)
2 years ago
2dbd0fde32
Rewrite some INNER JOIN's. According to the docs Jet doesn't support an INNER JOIN being nested under a LEFT JOIN. We try to figure out which one's they are and rewrite it. As an INNER JOIN is a join where both sides have a value, we can rewrite it as a LEFT JOIN and then filter out the rows where the columns the join is on is not NULL
2 years ago
83b0bea0b8
another test update
2 years ago
78f9226030
Update tests
2 years ago
c46f980c09
Start work on some support for sequence value generation. Still under investigation if possible
2 years ago
7cee2d0581
update dependencies
2 years ago
673e56ed60
Add a whole heap of new tests. Work to implement all the test bases so that All_test_bases_must_be_implemented can pass
2 years ago
944843bfad
Some datetime parameters don't work unless they have been properly converted
2 years ago
70af0c286c
Set query splitting behaviour. Prevents errors due to it not being set
2 years ago
629398c76b
Set CanExecuteQueryString to false. When running tests, if it is set to true, the Query Asserter will also try to create a query string from the IQueryable. While most cases are fine, the problem comes in when there are parameters. Creating the query string declares the parameters and values at the beginning of the query and the DbCommand is set up with no parameters. While this can work in Sql Server (see the DECLARE keyword), this is not supported with Jet.
...
The Query Asserter already runs the CreateDbCommand on the IQueryable which creates the DbCommand with the parameters all set up. Creating the query string and running that as a separate command is not really necessary.
By the looks of it this only affects the test system which specifically creates a query string from an IQueryable and creates a new DbCommand with that as the command text. It doesn't seem to affect anywhere else
2 years ago
3ef1503bb9
Translate the Atan2 function
2 years ago
5e32650f6d
Dispose of any new JetCommands created when splitting commands properly. This were not being disposed of and still holding a link to the database thereby preventing some file access e.g. Deleting a file
2 years ago
424c9fc8f3
Update dependencies
2 years ago
3f5c1b6005
Make sure a DateTime in a constant has a DateTime Type Mapping
2 years ago
429c67ca3a
Some skip...take optimization and fix using multiple take after a skip
3 years ago
cbf7daca08
Update tests for Skip...Take
3 years ago
8c9dff5d36
Initial support for Skip....Take. Take...Skip and Skip currently do not work properly
3 years ago
d7268307bc
Fix generating a custom OleDbException for the tests
3 years ago
54a53915bc
v7.0.2
3 years ago
fd57f4a3bd
Rename some extension methods so that it doesn't interfere with other providers (namely sql server)
3 years ago
fd6c2aec01
Revert ca0feb49 . Same name extensions when using sql server and jet
3 years ago
84e40f5085
Fix some string resources
3 years ago
a34dafb7bd
Update version for nuget
3 years ago
595a68e5e4
Update azure-pipelines.yml
3 years ago
6bf5bba937
Merge pull request #139 from 0xced/delete-unnecessary-references
...
Remove unnecessary references in `EntityFrameworkCore.Jet.Data`
3 years ago
cbb3f94440
Remove unnecessary references in `EntityFrameworkCore.Jet.Data`
...
Now that `EntityFrameworkCore.Jet.Data` targets `net6.0` those references are not required anymore.
Note that the `Microsoft.Win32.Registry` package reference was the root cause of the failure to publish the `EntityFrameworkCore.Jet.Data` 7.0.0 package because of [warning NU5104][1] (treated as error):
> A stable release of a package should not have a prerelease dependency. Either modify the version spec of dependency "Microsoft.Win32.Registry [6.0.0-preview.5.21301.5, )" or update the version field in the nuspec.
[1]: https://bubibubi.visualstudio.com/EntityFrameworkCore.Jet/_build/results?buildId=280&view=logs&j=67ea8d94-b5a7-504b-2d4b-07baddfad3f1&t=1e07b7f6-b7a1-55f6-9cca-c04683790a41&l=37
3 years ago
3cfed1cb8f
Update README.md
...
Add a compatibility matrix
3 years ago
0c8e8d296d
7.0.0 RTM
3 years ago
d668fe7f16
Update tests
3 years ago
a9c2f36da5
Jet conversion functions like Cdbl/Csng/CLng don't accept or propogate null values. Normally we can just use an IIF to check if the expression is null or not. That does work fine but here we also check if the base expression is nullable. If the base expression will never return null we can simplify and just use the base expression rather than test for null
3 years ago
6963a165e5
The result of the Round function is never null
3 years ago
c8e109fb94
Jet can't candle a left join straight after a cross join. We have to push the cross join specifically down into its own subquery and then do a left join on that
3 years ago
6230db2803
Merge branch 'master' of https://github.com/bubibubi/EntityFrameworkCore.Jet
3 years ago
61b277d11c
Update dependencies and some test fixes
3 years ago
256163dcf7
Merge pull request #138 from 0xced/JetConnectionStringBuilder
...
Introduce a new typed JetConnectionStringBuilder
3 years ago
83c29e4c43
Introduce a new typed JetConnectionStringBuilder
...
This makes it easier to use than the extensions (EntityFrameworkCore.Jet.Data.DbConnectionStringBuilderExtensions) with Get/Set methods.
With the new `JetConnectionStringBuilder` class:
```csharp
var csb = new JetConnectionStringBuilder(DataAccessProviderType.OleDb)
{
Provider = "Microsoft.ACE.OLEDB.12.0",
DataSource = @"C:\myFolder\myAccessFile.accdb",
DatabasePassword = "hunter2",
};
var connectionString = csb.ConnectionString;
```
Without the new `JetConnectionStringBuilder` class:
```csharp
var csb = new OleDbConnectionStringBuilder();
csb.SetProvider("Microsoft.ACE.OLEDB.12.0");
csb.SetDataSource(@"C:\myFolder\myAccessFile.accdb");
csb.SetDatabasePassword("hunter2");
var connectionString = csb.ConnectionString;
```
3 years ago
0dff2ea1ca
Merge pull request #137 from 0xced/SupportedOSPlatform
...
Make EntityFrameworkCore.Jet available on `net6.0`
3 years ago
c795ce6228
Make EntityFrameworkCore.Jet available on `net6.0`
...
By using `[SupportedOSPlatform("windows")]` at assembly level instead of targeting `net6.0-windows`.
This will enable taking a dependency on the EntityFrameworkCore.Jet* NuGet packages on Linux and macOS. The consumer of EntityFrameworkCore.Jet can then decide how to handle [CA1416][1] either by adding `[SupportedOSPlatform("windows")]`, by targeting `net6.0-windows` or by testing `OperatingSystem.IsWindows()` at runtime.
[1]: https://learn.microsoft.com/en-us/dotnet/fundamentals/code-analysis/quality-rules/ca1416
3 years ago
1e73673f05
Set RC 1
3 years ago
Christopher Jolly
Cédric Luthi