New build of dotConnect for PostgreSQL 7.10.1031 is available for download now.
In this version:
- The CancelEditRowIfUpdateFailed property, determining whether to call CancelEdit for the row after update of the row is failed when data binding is used, is added to PgSqlDataTable
- The performance of generating complex queries is improve
- The bug with exceeding a length of duplicated column aliases in the generated SQL is fixed
- The new "Detect function-based column default value" option is implemented in Model Settings of EF Core model
- The code generation for async method calls is added to the EF Core template
- The usage of long identifiers (up to 140 symbols) for naming model objects is supported
- Entity Framework 6.2 is supported
- The SQL generation for subselects, when using Distinct(), in EF1/EF4/EF5/EF6 is optimized
- The identity columns in PostgreSQL 10 are supported in Entity Data Model Wizard (classic EF) and in Scaffold-DbContext (EF Core)
- The config.DatabaseScript.Schema.EnsureSchemaBehaviour option is added for controlling behaviour of the EnsureSchema operation in EF Core
- The Code-First Migrations functionality in EF Core is improved:
- the operations InsertData / UpdateData / DeleteData (introduced in EF Core 2), EnsureSchema (creates schema if not exists), DropSchema (removes schema), CreateSequence, AlterSequence, RestartSequence are supported
- The bug with using UsePostgreSql(DbConnection) extension method of DbContextOptionsBuilder in EF Core is fixed
- The bug with using collections in a .Contains() method in EF Core 2 is fixed
- The bug with JOIN conditions in SQL generated from LINQ query in EF1/EF4/EF5/EF6 is fixed
- The bug with using multiple .Include() in EF Core 2 is fixed
- The bug with processing conditions in LINQ queries with joins in EF Core is fixed
http://www.devart.com/dotconnect/postgresql/