linq2db

Linq to database provider.

MIT License

Stars
2.9K
Committers
142

Bot releases are hidden (Show)

linq2db - Release.1.9.0

Published by ili about 7 years ago

Documentation

Significant

  • [MySql] access to a table using fully-qualified name using schema/owner is not supported anymore. You should update your code to use database name for it (#681)

Features

  • async support (#758)
  • SQL MERGE support with new Merge API (#686)
  • LINQ query cache management (#645)
  • associations could be defined using extension methods (#786)
  • overrides, typed by resulting type, added for InsertWithIdentity (#774)
  • added possibility to provide predicate expression for associations (#753)
  • custom aggregate functions support (#73, #353, #679, #699, #775)

Improvements

  • performance improvements for multi-threaded environments (#278)
  • [PostgreSQL] DateTimeOffset type mapped to TimeStampTZ by default (#794)
  • [PostgreSQL] Guid type mapped to uuid by default (#804)
  • tables support in extensions (#773, #777)

Fixies

  • regression in queries generation in 1.8.3 (#825)
  • Take/Skip/Distinct promoted to main query from joined subquery (#829)
  • wrong SQL generated for Contains subqueries with Take/Skip (#329)
  • fixed various issues with BinaryAggregateExpression option enabled (#812)
  • better support for Nullable parameters in LINQ queries (#820)
  • use of function with IQueryable result type in LINQ query could fail (#822)
  • use of retry policy fails for SAP HANA and DB for iSeries, if connection string contains credentials (#772)
  • call to Count after GroupBy executed on client (#781)
  • better support for SQL literals (#200, #668, #686)
  • [Informix] support for cultures with non-dot decimal separator (#145)
  • DbConnection.ExecuteReader ignores commandBehavior parameter (#801)
  • [Firebird, Oracle, MySql, Informix, SAP HANA, DB2] fully-qualified table name generation fixes for various providers (#778)
  • [SQLite] schema generation fails when foreign key targets table (#784)
  • [SQL Server] Set SkipOnInsert and SkipOnUpdate flags for computed columns in schema provider (#793)

Links

linq2db - Release 1.8.3

Published by ili about 7 years ago

  • [!] Fixed problems with Configuration.Linq.UseBinaryAggregateExpression (#708, #716)

  • [!] Experimental support for query retry (#736, https://github.com/linq2db/linq2db/blob/master/Tests/Linq/Data/RetryPolicyTest.cs)

  • Better support for NpgSql 3.2.3 (#714, #715)

  • Fixed issue with wrong convert optimization (#722)

  • Fixed join optimization (#728)

  • Fixed nullable enum mapping edge cases (#726)

  • Fixed issue with cached query (#737, #738)

  • Update with OrderBy support (#205, #729)

  • Changed string trimming for fixed size string columns (trim only spaces) (#727)

  • Better support for creating tables with Oracle (#731, #750, #723, #724)

  • Fixed InsertOrUpdate to work as InsertIfNotExists when update fields not specified (all providers) (#100, #732, #746)

linq2db - Release 1.8.2

Published by ili over 7 years ago

  • Configuration.Linq.UseBinaryAggregateExpression is set to false by default as supposed to be unstable (#708)
linq2db - Release 1.8.1

Published by ili over 7 years ago

  • Fixed issue with !IEnumerable.Contains (#228)
  • Fixed GROUP BY DateTime.Year (#264, #652)
  • Fixed query optimization (#269)
  • Fixed BinaryAggregateExpression (#667)
  • Fixed nullable enums support (#693)
  • Improved Npgsql 3.2 support (#665)
  • Improved JOIN build (#676)
  • Improved SqlCe support (#695 )
  • Minor changes (#664 #696)
linq2db - Release 1.8.0

Published by ili over 7 years ago

LINQ to DB 1.8.0 Release Notes

linq2db - Release 1.7.6

Published by ili over 7 years ago

Release 1.7.6

linq2db -

Published by ili almost 8 years ago