- Option type fix for Like-search
- Option type fix for exactlyOneOrDefault. PR #491
- Initial support for cross joins. PR #489
- Option type exactlyOneOrDefault fix PR #484
- Oracle join columns fix PR #455
- Oracle column name resolution PR #480
- Procedure name overload fix PR #476
- Allow option type return in where-lambda. #478
- Previous type provider SDK returned #472 #470 #468 #466 #465
- More info to tooltips.
- Procedure result fix.
- Excluded FSharp.Core dll from package #465
- Initial support for MySqlConnector driver
- Latest type provider SDK
- Canonical operations support for aggregation operators (SUM/AVG/MIN/MAX) in single table #459
- Latest type provider SDK
- More flexibility to type casting on basic math canonical operations
- Initial version of .NET Standard 2.0 / .NET Coreapp 2.0 support
- Breaking change: The original dll path is now under net451 folder.
- SQLite: Performance improvements. Option to use Microsoft.Data.SQLite
- MySql: Support for MySQL.Data.dll v6.10-rc3 and v8.0.9dmr (but 6.9.9 stable still recommended)
- Reference component assembly loading and error messages improved.
- Firebird quotes fix PR #453
- Access to command timeout #447
- Support Postgres arrays #450
- Breaking change for MYSQL/MariaDB: Unsigned types mapping fixed #437
- Fix for MSSQL tables with no-values insert #440
- Canonical operation AddMinutes supports now other sql-columns as parameter.
- String to datetime parsing with DateTime.Parse in SQL will convert the types if ok for db.
- Fixed (sortBy desc + skip + take) combination #432
- ConnectionStringName when not running from application folder #428
- sortBy Key support to groupBy #429
- Fix for issue when Oracle a sproc returns a cursor with an actual type
- FSharp.Data.Sql.Common.QueryEvents.SqlQueryEvent has now better structure
- Async stored procedure execution support (InvokeAsync)
- PostgreSQL 3.2 support (when System.Threading.Tasks.Extensions.dll near)
- Mysql: more efficient schema queries, PR #415
- Firebird: Stored Procedures, PR #414
- Support for Mono 5 #413
- Support for Firebird SQL Server
- Sort-by casts to IComparable fix #407
- Oracle Length and Trim fix #408
- Column <> null fix
- Support canonical functions: Convert some basic .NET-functions to SQL.
- Support delete from -query to delete many items with a single clause.
- Oracle connection leak fix #397
- Oracle Delete causes ORA-00932 fix #394
- Misc minor fixes for MS-Access
- Group-by fixed over empty result groups
- Initial support for 2 column key on group-by
- Oracle comments fix
- Fixed: Support for group-by where condition outside group-by operation
- Database table and column descriptions to editor tooltips. #385
- ODBC fixes.
- Support for updating records on MySQL before 5.5 #384
- Fix for #380, where-conditions on joined tables with itm.x > itm.y
- More async operations.
- GetDataContext overload for passing in the TransactionOptions instance
- On where-clauses plain SQL-columns can be now on both sides of operations
- Added Array.executeQueryAsync and List.executeQueryAsync
- SQLite spacing fix #371
- Cast fixes #370
- Oracle update fix. #367
- Breaking change for number-columns: naming fixed. #355
- One table one key-column GROUP-BY support. #358
- HasColumn(niceName) method for entities
- UNION queries
- Support Space in MSSQL inserts
- Support Space in MySQL table names #347
- TableNames parameter for MSSQL
- Fix Access unknown error #340
Support views in Oracle table list
- Fix for SQL CRUD operations, #338
- Fix for contains search
- Fix for primary key discovery on oracle #331
- SQLite text-format date comparison fix #328
- Odbc quote characters option #327
- Where-clause optimization and fix
- Oracle performance improvements
- Postgre nullable insert fix
- SQL generation improvements
- MsAccess fix
- Support for composite (multi-key-column) table joins
- Support for let-keywords
- Configuration error info improvements
- Added SourceLink (for debugging possibility).
- CRUD support for composite key tables
- Fixed functionality with some specially named tables and columns
- Fixed exception on queries where are multiple times "take 1"
- Fixed delete on ProcessUpdatesAsync
- Async query sort order fix on ordered query
- query: where (myTable.MyBoolean) -support
- MsSql Mono DateTime fix
- Nested IN-queries
- More query operators
- Oracle large table count support
- Simple Linq contains query
- Fixed SQLite IN-queries (had problem with all the parameters being param1)
- Added ys.Contains(x) to create IN-clause as well as |=|
- Some concurrency fixes (#282)
- Fix for #279
- Byte array to Blob fixes for SQLite and MySQL
- Some performance fixes.
- Odbc fixed (on some level).
- SQLite fix for reserved keywords table names.
- MsSql IN with empty collection
- Added Linq Any support (contains)
- Concurrency fix for SubmitUpdates()
- Fixed possibility to call SubmitUpdates many times after delete.
- .PossibleError property to notify schema or database name (Owner)
- Fixed select string concat, e.g: Select (person.FirstName + " " + person.LastName)
- minBy and maxBy for DateTime fields
- Fixed operating table with no primary key
- Better error reporting
- SQLite skip fix
- sumBy, maxBy, minBy, averageBy
- More async operations: Seq.lengthAsync, Seq.headAsync, Seq.tryHeadAsync
- PostgreSQL types, Npgsql 2 and 3. (PR #261)
- Improved option type usage in join and where clauses (PR #260)
- Fixed: Insert did return object as id, not the id wanted.
- Many community bug-fixes and PRs
- Documentation improvements
- Async operations (PR #257)
- CRUD in Access (PR #211)
- Better error handling (PR #233)
- Better thread synchronisation (PR #222)
- General bug fixes
- V1 release
- Type provider generates nicer table names, relationships and sprocs
- Added static parameter to control case senstivity when generating queries (PR #143)
- Fixed relative paths for SQL lite
- Fixed differences in path between mono and .net for sql lite
- Added ability to use a connection string referenced in app or web config
- Stored procedures are now lazily generated
- Improved Postgre Type mappings (PR #127)
- Documentation improvements (PR #137, PR #148, PR #150)
- Fixes a regression that prevented UPPER on SqlServer (PR #149)
- Fixes for the LINQ expression converter (PR #131)
- Fixed a regression when building oracle relationships (PR # 126)
- Fixes Postgres Type mapping issues (PR #117)
- Fixes command already disposed exception (PR #124)
- Fixes type mapping issues in Access provider (PR #122)
- Fixes issues with optional tyepd properties (Issue #119, PR #116)
- Converted project to use paket and latest project scaffold. (PR #113)
- Added a function to retrieve the primary key for the table. (PR #105)
- Fix for SQLite not releasing DB file (Issue #99, PR #100)
- Support for stored procedures on DB's that support them (PR #83)
- Support for SQLite on Mono (PR #81)
- Fixing a bug with writing tinyints in SQL Server
- Fixes to MySQL array parameters
- You can now use any sequence with the in and not in operators, as opposed to just new array expressions
- Fix in PostgreSQL to allow the creation of entities with no set properties
- Fixes an important bug that was causing all columns to be selected
- ODBC support added
- CRUD operations added
- Tons of fixes and tweaks
- MS Access support added!
- Various fixes for SQLite and Oracle
- Added support for head / First()
- Oracle support added!
- Various minor fixes
- MySQL support added!
- SQLite would only work if all tables had at least one FK constraint - fixed
- Various option type fixes
- GraphViz script to help visualize LINQ trees when debugging
- PostgreSQL support
- Option Types for nullable columns
- Various tweaks and cleanup
- Count() support in queries
- Initial release of Sqlprovider