78363e4715
Fix Gears of War tests and update its SQL baselines
3 years ago
448386a934
More test fixes
3 years ago
49e195e6e7
In a raw sql string the base delimiters and normalized to " and not `.
3 years ago
0e581b586d
Declaration is the same for both Odbc and OleDb
3 years ago
51037ec385
Use GenGUID function for DefaultValueSql instead of the undefined newid
3 years ago
ae722d9033
Ignore DateOnly and TimeOnly field in Gears Of War. No support yet
3 years ago
4219015cc0
raw string literals not supported in net6
3 years ago
e14b48db47
Update tests
3 years ago
ca1b158a72
Update tests
3 years ago
75e381b52c
Update tests
3 years ago
cf4bbf213f
Update tests
3 years ago
8135a01750
Update Northwind SQL: Use a better format for the dates. When using it with the / separator, whether it is day then month or month then day is interpreted based on your locale. Using the #yyyy-mm-dd# format is interpreted the same way more consistently
3 years ago
4554aad38e
Update the translator for the string methods to add a couple more: Substring, IndexOf,FirstOrDefault,LastOrDefault
3 years ago
ab7a424ef4
Fix up Design time services to work properly. Add-Migration command in VS will work now
3 years ago
81f6cbb254
revert to use our stringtypemapping to generate the sql literal. Some regex depends on using this format to pick the filename from the connection string
3 years ago
d100231ce9
[Tests]: Update tests
3 years ago
d51935d04a
[Fix][Test]: Exception can be either OleDb or Odbc
3 years ago
2f2de12dd5
enable and fix tests
3 years ago
d42cf1e346
Fix tests: Use helper method to create connection - will use database named for the test - gives each test a unique name so doesnt interfere with others at the same time. The rest of the tests already use it, these couple were just missed
3 years ago
ed8f109855
update tests to build
3 years ago
1f35ab88fd
merge fixes from upstream
3 years ago
de09de2b5f
update dependencies
3 years ago
6a8ccd27de
Fix transactions issues ( #129 )
...
* Fix active transaction support and disposed handling.
* Add transaction baseline tests.
* Fix transaction tests.
4 years ago
7214d3ca9f
Improve test infrastructure.
4 years ago
120a47746a
[PORT] Improve `counter` type handling and add missing `counter` usage cases ( #121 )
...
* Improve counter type handling. (#112 )
* Add missing counter usage cases.
* Adjust tests.
4 years ago
1eb7ec7793
Fix EXIST handling in regards to line breaks. ( #117 ) ( #118 )
4 years ago
e9d4aef876
[PORT] Do not create Index-Operations with the same name as ForeignKey constraints ( #115 )
...
* In contrast to SQL Standard, MS Access will create an index together with a the FK constrains (#114 )
According to https://docs.microsoft.com/en-us/office/client-developer/access/desktop-database-reference/constraint-clause-microsoft-access-sql
this can be deactivated, however creating an index with the same name as an FK still results in an runtime error, therefor the index creation operation is skipped
Co-authored-by: Michael Steinecke <m.p.steinecke@gmail.com>
* Update to 5.0 and cleanup code and comments.
Co-authored-by: Michael Steinecke <6099045+MichaelSteinecke@users.noreply.github.com>
Co-authored-by: Michael Steinecke <m.p.steinecke@gmail.com>
4 years ago
b1fa143d4d
Update to .Net 5 ( #99 )
...
* update to net 5
* Add DecimalTypeKey to the logger
* fix build
* fix sdk version for script
* Update dependencies.
* Fix version and dependencies.
* Readd necessary code paths, fix smaller upgrade issues, cleanup code.
* Fix project files.
* Fix tests.
* Readd removed JetQueryTranslationPostprocessorFactory injection.
Fix date/time related millisecond (double) support.
* Fix value generation.
Co-authored-by: Laurents Meyer <laucomm@gmail.com>
4 years ago
12614cd7a1
Ensure columns of relationships (FK -> PK/AK) are applied in the original order, when scaffolding. ( #104 )
5 years ago
3595734d47
Fix remaining EFCore.Jet.Data tests ( #92 )
...
* Refactor dual table handling.
* Fix remaining EFCore.Jet.Data tests.
5 years ago
b749447fd0
Add support for PASSWORD clause in EFCore.Jet specific CREATE DATABASE statement ( #91 )
...
* Add support for PASSWORD clause in EFCore.Jet specific CREATE DATABASE statement.
* Add negative test.
5 years ago
45dcfbe0dd
When creating databases, automatically use the latest database version that is supported by the current file extension. ( #90 )
5 years ago
56bf71b17f
Fix schema and rename related issues and tests ( #89 )
...
* Fix schema and rename related issues and tests.
* Adjust rename syntax for better standard conformity.
5 years ago
45e7d8a365
Fix CREATE/DROP DATABASE related issues. ( #88 )
5 years ago
00178eb0cd
Fix DateTime fractions logic and make milliseconds support opt-in ( #86 )
...
* Ensure deterministic test ordering.
* Fix DateTime factions logic.
* Make milliseconds support opt-in.
* Fix logic and add tests.
* Fix DateTime related OLE DB parameter configuration.
5 years ago
54b4af5759
Fix DateTime expressions for HasDefaultValue() and add support for fractions of a second ( #85 )
...
* Fix and improve test runs.
* Fix DateTime expressions for HasDefaultValue() and add support for fractions of a second.
Refactor test infrastructure.
5 years ago
b0d53d30ce
Fix DEFAULT clause for HasDefaultValueSql() ( #81 )
...
* Removed parenthesis from column default values (addresses issue #18 )
* Fixed issue where the file handles were not being released after the database connection was closed.
* reverted accidentally changed file to upstream version
* Fixed issue where the file handles were not being released after the database connection was closed.
* reverted accidentally changed file to upstream version
* Add accompanying tests for PR #81 .
Co-authored-by: Collin Kostichuk <collin.kostichuk@genivar.com>
Co-authored-by: Collin Kostichuk <collin.kostichuk@wsp.com>
Co-authored-by: Tobias Arens <arens@jam-software.de>
Co-authored-by: Laurents Meyer <laucomm@gmail.com>
5 years ago
f094f3658c
Fix data and test infrastructure and scaffolding ( #82 )
...
* Fix local references.
* Optimize, fix and simplify JetDataReader.
* Only scaffold objects if tables are available.
* Fix test infrastructure.
* Ignore Development.props in root folder.
5 years ago
23b8257fc8
Trim called without arguments throws index out of range ( #77 )
...
* Check arguments before accessing in jet string method translator
* Change expected result on to lower and to upper query tests
* Change expected result on trim query tests
* Remove original fix and fix condition chaining in trim clause generation
Co-authored-by: Floris Verhoeven <florisverhoeven@outlook.com>
5 years ago
2b44bac7ba
Cleanup solution.
5 years ago
64ebb61c0a
Rename System.Data.Jet to EntityFrameworkCore.Jet.Data ( #75 )
...
* Rename System.Data.Jet and System.Data.Jet.Test projects.
* Rename System.Data.Jet and System.Data.Jet.Test namespaces.
5 years ago
c661926684
Improve project and CI ( #68 )
...
* Update .NET SDK.
Improve CI.
* Simplify dependency management.
* Add new versioning mechanism.
* Implement CI package publishing.
* Add matrix for multiple ACE architectures.
* Fix xUnit warnings.
* Cleanup and enable SourceLink.
* Manually install .NET SDK to specify architecture.
Extend matrix to test for x64/x86 and ODBC/OLE DB.
5 years ago
864be46354
Reimplement schema retrieval and scaffolding ( #59 )
...
* Reimplement schema retrieval.
* Reimplement scaffolder. Some Jet specific options have not been implemented yet.
5 years ago
9f0b60baee
Fix tests (especially from `SimpleQueryJetTest`).
6 years ago
db47437539
Provide `TOP` and `SKIP` support for ODBC commands and improve algorithm and use cases.
6 years ago
521362b213
Update dependency versions.
6 years ago
1f42ec1f0a
Implement automatic driver (ODBC) and provider (OLE DB) inference and detection.
6 years ago
3f19b269b4
Rename DataAccessType to DataAccessProviderType.
6 years ago
2a6a3b67ba
Update baseline assertions to support ODBC parameter placeholders.
6 years ago
41579e74c9
Cleanup all remaining ODBC and OLE DB references.
6 years ago
Christopher Jolly
Laurents Meyer
xoniuqe
Floris Verhoeven