dc5f216c1b
Add missing counter usage cases. ( #120 )
4 years ago
7de5da5755
Fix EXIST handling in regards to line breaks. ( #117 )
4 years ago
7413f28759
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>
4 years ago
a9c7a11f0d
Improve counter type handling. ( #112 )
4 years ago
c09660785d
Fix ArgumentNullException when creating a database. ( #107 )
4 years ago
12614cd7a1
Ensure columns of relationships (FK -> PK/AK) are applied in the original order, when scaffolding. ( #104 )
5 years ago
db2c056b9f
Return default value for JetDateTimeTypeMapping derived classes as well. ( #102 )
5 years ago
ad5799ffa6
Return correct type mapping for DateTimeOffset with an explicit DATETIME store type set. ( #101 )
5 years ago
fedc4cc226
Fix create database operations and multi statement splitting with parameters ( #97 )
...
* Fix automatically assigned file extensions when creating databases.
* Fix parser to correctly return state indices of sub commands. This is a fix for commands containing more than one actual SQL command in its command text, when those multiple actual SQL commands are using parameters.
5 years ago
3235e3ce41
Resolve IJetOptions for design time services. ( #94 )
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
1df41e8b43
Fix JetCommand regarding CREATE PROCEDURE statements and command splitting. ( #87 )
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
c473442c8d
Fix runtime checks for appropriate data access library version. ( #84 )
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
c5905a77ed
Fix assembly name.
5 years ago
56c347348f
Fix packaging.
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
568feee419
Adjust description of System.Data.Jet.
5 years ago
72f445248e
Add ODBC and OLE DB specific packages ( #74 )
...
* Rename solution.
* Add ODBC and OLE DB specific projects/packages.
* Adjust package tags.
5 years ago
0bdbc93032
Fix connection string conversion from ODBC to OLE DB. ( #72 )
...
Introduce new database password (in contrast to workgroup user password) extension methods (open issue).
Fix missing connection disposal in AdoxSchema.
5 years ago
80ee311ef4
Add setting to use default value if column has an unexpected null value ( #67 )
...
* Add setting to use default value if column hasunexpected null value
* Add setting to use default value if column hasunexpected null value
* fix typo: UseDefaultValueOnDBNullConversionError
5 years ago
6a7b28658d
Use new information schema syntax for HistoryRepository checks ( #70 )
...
* Use new information schema syntax.
* Block conditions are unsupported.
5 years ago
e1216f4915
Fix versioning and projects.
...
Reactivate tests, but ignored failed tests for now.
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
a14d665d5a
Fix translation of parameterless Trim(), TrimStart() and TrimEnd() methods. ( #64 )
...
These methods are only available in .NET Core 2.0+ (or .NET Standard 2.1+).
5 years ago
49d798f6c3
Change default data access library to ODBC. ( #63 )
...
Improve file extension handling.
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
226220dac6
Fix join statement generation.
6 years ago
1f35fca138
Reintroduce legacy support to emulate row skipping in the most outer SELECT statement, by letting JetDataReader ignore returned rows.
6 years ago
933caa3130
Add missing fixup.
6 years ago
244649330a
Remove NEWGUID() and @@GUID support. They should not be necessary in EF Core and are currently used nowhere in the code base.
6 years ago
7aa5892184
Fix global variable placeholder handling.
...
Reactivate @@ROWCOUNT in INSERT/UPDATE generation.
6 years ago
e0db14ee1f
Make @@ROWCOUNT connection global.
6 years ago
1066d34e5b
Support multi-statement commands again and correctly handle parameters.
6 years ago
1781ce29df
Generalize and fix command parsing.
6 years ago
293286a767
Fix minor bugs.
6 years ago
43d5d39c69
Remove workarounds for Skip(), which is unsupported by Jet/ACE.
...
Implement better parameter support (including named parameters for ODBC).
Remove support for multiple statements in a single command, to support named parameters.
6 years ago
d80b53e9b2
Fix join statement generation.
6 years ago
48bc49d3a4
Fix bool value mapping.
6 years ago
db47437539
Provide `TOP` and `SKIP` support for ODBC commands and improve algorithm and use cases.
6 years ago
6141f1e581
Update still present square bracket identifiers to backticks.
6 years ago
Laurents Meyer
Michael Steinecke
xoniuqe
Floris Verhoeven
Christopher Jolly