e2c668bd10
6.0 beta 1
3 years ago
78363e4715
Fix Gears of War tests and update its SQL baselines
3 years ago
2fa40aee55
MID doesn't allow a null value for the length parameter. Add a IIF wrapper around it if that argument is marked as nullable.
...
Added here instead of stringmethodtranslator as we need the nullability optimizations on the sqlfunctionexpression. When wrapped in a caseexpression we get some different optimizations. Produces the correct result on the test case but is different to SQL Server. This way we keep it closer to SQL Server
3 years ago
1cc215b665
LEN propogates nullability
3 years ago
3ef19b1240
Fix the object to string. We don't want to unwrap an enum type. The enum's tostring needs to be handled on the client.
...
Also special case for boolean to string
3 years ago
c010e412a7
Fix conversion translator: only need to translate Convert.To... functions. Was trying to convert other tostring methods and was picking the methods that required an argument which was typically the tostring functions with arguments of the format string or the format provider
3 years ago
448386a934
More test fixes
3 years ago
85b81fbb07
Fix problems when cherry picking from net7 code
3 years ago
737a32a6f5
Add Math functions to translate Floor and Ceiling
3 years ago
d16195bc73
Pass the current dataaccessproviderfactory type to CreateDatabase. Preference will take place using this type before going to the default in case it can't find the type via the connection string.
...
Fixes #135 and #122
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
79a3b7afae
Don't call SearchConditionConvertingExpressionVisitor. Some nullability optimizations through ParameterBasedSqlProcessor and SqlNullabilityProcessor need to be called first and they call SearchConditionConvertingExpressionVisitor
3 years ago
951c389b5a
Reverse the order of the indices. We need to work backwards on the string to keep the indices correct
3 years ago
9597fbc23e
Merge pull request #133 from ChrisJollyAU/net6
...
Merge updates from working branch
3 years ago
dd223df6fe
update to alpha 2
3 years ago
a9789216d2
Dual table: Auto detect the dual table name on model load. Use that table for any queries.
...
Also allow a custom override name to be set
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
fbd8398d95
Timespan needs to map to a DbType of DateTime not Time
3 years ago
9573229ba6
Merge pull request #131 from ChrisJollyAU/net6
...
Update to .Net6
3 years ago
4219015cc0
raw string literals not supported in net6
3 years ago
e14b48db47
Update tests
3 years ago
59bc0d813a
Change option from 0 to 1 for InStr. Make it use vbTextCompare which is case insensitive
3 years ago
ca1b158a72
Update tests
3 years ago
75e381b52c
Update tests
3 years ago
e446bce94c
Upgrade to latest dependencies
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
05b10ea856
Type MApping: a long gets mapped to integer in Jet
3 years ago
b72b0aeb61
Support casting to Int64
3 years ago
fc6b407b36
Update version info for message for required OleDb and Odbc dependencies
3 years ago
ab7a424ef4
Fix up Design time services to work properly. Add-Migration command in VS will work now
3 years ago
9843c0c8de
Update DesignTimeService for Net 6
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
ef5c33cb74
[Fix]: No need for fancy conversion if there is a conversion expression on a Clr type which is an enum
3 years ago
ae21d832f1
Fix getting the schema for relations. Need both adox and DAO to get all fields
3 years ago
adbad89184
Fix check for unique
3 years ago
b78bbecf43
Do not generate SavePoint SQL. No-op
3 years ago
58f0918d27
[Fix]: Use TryGetDefaultValue.. For an int property, GetDefaultValue will always return as a default 0 (a non null value), if TryGetDefaultValue fails. Thus the wrong ValueGenerationStrategy is returned
3 years ago
093890fa66
[Fix]: Don't update the command to the trim'd version. If using an interceptor, it has already gotten the original commandText. Any comparisons between the actual result and the interceptor would fail
3 years ago
ee87572b2e
Fix schema query: the ondelete and onupdate were added in the wrong order
3 years ago
d51935d04a
[Fix][Test]: Exception can be either OleDb or Odbc
3 years ago
5341e45e80
Add translator for Jet Random
3 years ago
2f2de12dd5
enable and fix tests
3 years ago
ed726d7478
[Fix]: Explicitly find DateTime in an IN expression and use the Jet formatting
3 years ago
b0624051b3
Fix check for correct type that this handles. Previous way of checking was overriding the Nullable Translator
3 years ago
410ccb01c7
Add in support for .Parse methods on the simple types that support it (bool, int,double,datetime,byte,decimal,single)
3 years ago
Christopher Jolly