Christopher Jolly
325ea97716
Math.Truncate rounds towards 0. Use FIX instead of INT to match that behaviour ( #282 )
5 months ago
Christopher Jolly
f72fd5fcb0
Add more tests ( #280 )
...
* Add more tests
* updates
* updates
* updates
* [GitHub Actions] Update green tests.
---------
Co-authored-by: github-actions <github-actions@github.com>
6 months ago
Christopher Jolly
1069897167
Update to sync to latest EF 9 ( #276 )
...
* Small fixes
* some smaller fixes to bring up to date to ef 9
* change version to rtm
8 months ago
Christopher Jolly
3ee8feaad6
Update dependencies to EFC 9 GA ( #273 )
...
* update to match efc 9 ga
* fix tests
* fix odbc
* fix another test
* Add some missed tests in MigrationsInfrastructure
1 year ago
Christopher Jolly
dd24f9a674
Code style cleanup ( #271 )
...
* Code cleanup and code style enhancement
* Oops
* Fix default provider type
* fix error
* Throw better error if GetMostRecentCompatibleProviders doesn't find anything
1 year ago
Christopher Jolly
1de9eb4382
Add translations for greatest/least,math.min/math.max ( #270 )
...
* Add translations for greatest/least,math.min/math.max using if statements
1 year ago
Christopher Jolly
ec6c702334
Add Std Dev and Variance using EF.Functions ( #269 )
...
* Add Std Dev and Variance using EF.Functions
1 year ago
Christopher Jolly
b651c6aa40
Don't use any conversion when the convert type mapping is a byte array ( #266 )
...
* Don't use any conversion when the convert type mapping is a byte array
* [GitHub Actions] Update green tests.
---------
Co-authored-by: github-actions <github-actions@github.com>
1 year ago
Christopher Jolly
8033475032
Sync to an RC2 build ( #265 )
...
* RC2 History Repo
* return the right ValueGenerated if it is mapped to json
* Since Jet doesn't do anything for GO we don't need to do anything like Sql server does
* Update the HistoryRepository
* Remove unused tests
* [GitHub Actions] Update green tests.
---------
Co-authored-by: github-actions <github-actions@github.com>
1 year ago
Christopher Jolly
b64c1d5e1c
Sync to EF RC1 ( #264 )
1 year ago
Christopher Jolly
5fece6dd96
Cleanup ( #261 )
...
* Use primary constructors
Remove 2 obsolete tests
* fix build
* [GitHub Actions] Update green tests.
---------
Co-authored-by: github-actions <github-actions@github.com>
1 year ago
Christopher Jolly
f199d04cba
Improve Null Semantics tests ( #260 )
...
* Add missing test overrides
Fix sql literal output from a BoolTypeMapping
* [GitHub Actions] Update green tests.
---------
Co-authored-by: github-actions <github-actions@github.com>
1 year ago
Christopher Jolly
20c42dec52
Translate TimeOnly.FromDateTime and TimeOnly.FromTimeSpan ( #259 )
...
* Translate TimeOnly.FromDateTime and TimeOnly.FromTimeSpan
1 year ago
Christopher Jolly
f30c7268cd
Fix View splitting ( #258 )
...
* Fix View splitting
1 year ago
Christopher Jolly
4b3dcf5f30
Improvements to migrations ( #256 )
...
* Improve the migrations.
- Missing index sort order in model and sql
- When altering a column to non-nullable, have an UPDATE to make any NULL values the default value
* Changes to comments produce no SQL output as we don't handle comments
1 year ago
Christopher Jolly
bf6e8a17b2
Update SearchCondition visitor with improvements from SQL Server version ( #255 )
...
* Update SearchCondition visitor with improvements from SQL Server version
1 year ago
Christopher Jolly
8a5c4d83ec
Generate guid's for primary key client side ( #257 )
...
* Generate guid's for primary key client side
1 year ago
Christopher Jolly
f97148f745
Create a new sequential guid generator based on the UUID version 7 ( #254 )
...
* Create a new sequential guid generator based on the UUID version 7
1 year ago
Christopher Jolly
48dadc2f5d
Add Migration Lock feature in
1 year ago
Christopher Jolly
08be903455
Add a SharedTableConvention to set IndexesUniqueAcrossTables = false
1 year ago
Christopher Jolly
29aea47543
- Allow a short to be mapped to the identity counter
...
- Fix some database model/migration issues
- Above includes some formatting of the precision and scale to not have a space after the comma
1 year ago
Christopher Jolly
a2a4d5c20c
For returning TimeSpan and TimeOnly we don't want to convert the Jet default datetime to the c# 0
1 year ago
Christopher Jolly
3bd4232a07
Fix the precompiled query tests
1 year ago
Christopher Jolly
74c7e3f527
Fix type mapping for Time of Day methods which needs to be TimeSpan
1 year ago
Christopher Jolly
1e091fdefd
fix tests
1 year ago
Christopher Jolly
fc09548111
Add further tests that were missing
1 year ago
Christopher Jolly
80ae790a64
Fix tests for Nullable ToString efcore #34014 and #33940
1 year ago
Christopher Jolly
05dd4b6180
More test fixes
1 year ago
Christopher Jolly
8c7a189260
Upgrade EFCore to a daily build. Currently just after preview 7
1 year ago
Christopher Jolly
fcb79337ae
Some of these cases do work
1 year ago
Christopher Jolly
14d21012c0
Don't try to bulk skip any unsupported cross join. Current test skips too many that should go through and works
1 year ago
Christopher Jolly
3d85f906f5
Trhow Jet specific errors on more unsupported SQL. Allows us to bulk mark as skipped
1 year ago
Christopher Jolly
e570dfbf0f
Set operations within an IN mustnt be simplified and must be encased within a SELECT
1 year ago
Christopher Jolly
c09c874a5d
Use lowest datetime value possible when doing a firstordefault. Default with Jet (0 value) is not the lowest
1 year ago
Christopher Jolly
8ab1767b37
More fixes
1 year ago
Christopher Jolly
bd279b6bc6
Fix IndexOf
1 year ago
Christopher Jolly
043a9905a7
make sure all tests that should be overridden are
1 year ago
Christopher Jolly
ba02f1cfbd
more test updates
1 year ago
Christopher Jolly
28b6768a4c
update tests
1 year ago
Christopher Jolly
45bae420e2
Initial ef9 update. Mostly just getting the files to compile with all the ef9 changes
1 year ago
Christopher Jolly
c51b182962
AdoX GetRelations returns all key types not just foreign keys ( #245 )
...
* GetRelations only needs to return rows for foreign keys and not unique or primary keys. This makes it match DAO
2 years ago
Christopher Jolly
d20cafa6bf
Cleanup unneeded code ( #246 )
...
* remove some unnecessary stuff
2 years ago
Christopher Jolly
2d5930abc9
Up date to latest ef core dependency ( #244 )
2 years ago
Christopher Jolly
6ad608581b
Fix DateTimeOffset Now and UtcNow ( #235 )
...
* Fix DateTimeOffset Now and UtcNow
2 years ago
Christopher Jolly
d8d47443f0
Add option to ignore msys tables when scaffolding ( #236 )
...
* Add option to ignore msys tables when scaffolding
2 years ago
Christopher Jolly
41dab6c5c5
Better support for byte arrays ( #228 )
...
* fix array index and array length for byte arrays
* [GitHub Actions] Update green tests.
* Fix Contains with byte array. and fix getting length if an odd number of bytes
* fix array index and array length for byte arrays
* Fix Contains with byte array. and fix getting length if an odd number of bytes
* Enforce an optin methodology using EF.Functions for the byte array length due to certain situations with unicode strings
* Split error message and details into 2 parts
2 years ago
Christopher Jolly
2e4782677b
change the min required version of oledb and odbc to 8.0.0 ( #232 )
2 years ago
Christopher Jolly
7f85d5f87c
Jet has 7 decimal digits precision for single/float and 15 for double. Parameter values are automatically sorted out if they have more digits but a inline constant value could use more digits. This lead to the case where a stored double used 15 but the query with the constant used more. When comparing they were thus not equal when they should be equal
2 years ago
Christopher Jolly
25e381faa2
string keys are allowed to be case insensitive. Add in the correct comparer if needed
2 years ago
Christopher Jolly
0db31fcb2e
Fix same parameter name on contains/startswith/endswith. See efcore#32432
2 years ago