Devart Forums

Dear users,

We are glad to inform you that a new release of dbForge SQL Complete 6.10 - a superb code completion add-in for SSMS and Visual Studio - has been rolled out.

The release includes some new functions. To learn more about the functionality of the newly released version of SQL Complete, please refer to our blog.

Availability

Download dbForge SQL Complete 6.10 from our website and check the newly introduced features on your own. We will be glad to hear your feedback regarding the product.

Devart Development Team
https://www.devart.com/dbforge/

Dear users,

Devart is glad to announce the release of dotConnect for PostgreSQL 7.24 — a powerful ADO.NET provider for PostgreSQL with advanced support for Entity Framework, Entity Framework Core, LinqConnect (LINQ to PostgreSQL), and NHibernate. The new release offers support for load balancing that allows specifying multiple hosts with their ports in the Host parameter of the connection string. The servers should be separated by commas.

dotConnect for PostgreSQL now also includes new assemblies for Entity Framework 5, compiled with .NET Framework 4.7.

Here is the complete list of dotConnect for PostgreSQL 7.24.2066 changes:

• The KeepConnected connection string parameter is implemented to determine the number of seconds of connection inactivity before the client sends a ping request
• The Load Balancing support is implemented: now several hosts with their ports can be specified in the Host parameter of the connection string
• The Target Session connection string parameter is added for managing Load Balancing functionality, possible values are SuppressLoadBalancing, Any, PreferStandby, PreferPrimary, Primary, Standby
• The TargetSession property is added to the PgSqlCommand class to provide the possibility to overwrite the behavior of the same option set in the connection object

Entity Developer

• The bug when mapping PostgreSQL inet and macaddr types in Entity Framework Core Model is fixed
• The behavior is changed: turning off the "Save connection to" option in Model Settings of EF Core Model wipes out connection string literal from the generated code
• The behavior is changed: Devart.Data.PostgreSql.Entity.EF5.dll compiled with .NET Framework 4.7 is used now in EF5 models

Entity Framework support

• The new \Entity\EF5\net47\Devart.Data.PostgreSql.Entity.EF5.dll assembly compiled with .NET Framework 4.7 is added
• The new \Entity\EF5\net47\Devart.Data.PostgreSql.Entity.Migrations.EF5.dll assembly compiled with .NET Framework 4.7 is added
• The new \Entity\EF5\net47\Devart.Data.PostgreSql.Entity.Spatials.EF5.dll assembly compiled with .NET Framework 4.7 is added
• The bug with generating the "Value cannot be null" error when dropping indexes via Code-First Migrations in EF Core is fixed
• The bug with a materialization used within the Let operator of LINQ query in EF6 is fixed
• The bug with using .Contains with a collection within .Select of LINQ query in EF Core 2 is fixed
• The bug with throwing the "schema does not exist" error by Database.EnsureDeleted() in EF Core is fixed
• The bug with saving and reading string value NULL to/from HSTORE data type in PostgreSQL mapped to Dictionary<string, string> or ImmutableDictionary<string, string> or SortedDictionary<string, string> or ImmutableSortedDictionary<string, string> in EF Core 3, EF Core 5, EF Core 6 is fixed

Devart development team
http://www.devart.com/dotconnect/postgresql/

Dear users,

Devart is glad to announce the release of dotConnect for MySQL 8.21 with significant improvements in Entity Framework Core support. We supported new data types Uri, IPAddress, PhysicalAddress and expanded the capabilities for translating LINQ queries into SQL. Besides, we have improved support for working with JSON in LINQ queries for EF6.

New data types Uri, IPAddress, PhysicalAddress are supported and the capabilities for translating LINQ queries into SQL are expanded. We have also improved support for working with JSON in LINQ queries for EF6.

Here is the complete list of dotConnect for MySQL 8.21.2066 changes:

Entity Developer

• The behavior is changed: turning off the "Save connection to" option in Model Settings of EF Core Model wipes out connection string literal from the generated code
• The behavior is changed: Devart.Data.MySql.Entity.EF5.dll compiled with .NET Framework 4.7 is used now in EF5 models

Entity Framework support

• Mapping of internet/intranet data type System.Uri to MySQL string data types is supported in EF Core 3, EF Core 5, EF Core 6
• Mapping of network data types System.Net.IPAddress and System.Net.NetworkInformation.PhysicalAddress to MySQL string data types is supported in EF Core 5 and EF Core 6
• The SQL translation of the following class members used in LINQ query is supported in EF Core 3, EF Core 5, EF Core 6:
  • static method IsNullOrWhiteSpace() of the String class
  • static property Today and instance property DayOfWeek of the DateTime class
  • static methods Sqrt(), Max(), Min(), Log(), Log10(), Sin(), Cos(), Tan(), Asin(), Acos(), Atan(), Atan2() of the Math class
• The SQL translation of the following class members used in the LINQ query is supported in EF Core 5 and EF Core 6:
  • static methods Abs(), Round(), Truncate(), Floor(), Ceiling(), Pow(), Sqrt(), Max(), Min(), Log(), Log10(), Sin(), Cos(), Tan(), Asin(), Acos(), Atan(), Atan2() of the MathF class
• The SQL translation of the following class members used in the LINQ query is supported in EF Core 6:
  • static method Log2() of the Math and MathF classes
• The new \Entity\EF5\net47\Devart.Data.MySql.Entity.EF5.dll assembly compiled with .NET Framework 4.7 is added
• The new \Entity\EF5\net47\Devart.Data.MySql.Entity.Migrations.EF5.dll assembly compiled with .NET Framework 4.7 is added
• The new \Entity\EF5\net47\Devart.Data.MySql.Entity.Spatials.EF5.dll assembly compiled with .NET Framework 4.7 is added
• The new methods ExtractAsByte(), ExtractAsSByte(), ExtractAsInt16(), ExtractAsInt32(), ExtractAsInt64(), ExtractAsSingle(), ExtractAsDouble(), ExtractAsDecimal(), ExtractAsDateTime() are added to the MySqlJsonFunctions class for working with the JSON data type in LINQ to Entities queries
• The bug with generating the "Value cannot be null" error when dropping indexes via Code-First Migrations in EF Core is fixed
• The bug with a materialization used within the Let operator of LINQ query in EF6 is fixed
• The bug with using .Contains with a collection within .Select of LINQ query in EF Core 2 is fixed

Devart development team
http://www.devart.com/dotconnect/mysql/

Dear users,

Devart is glad to announce the release of dotConnect for Oracle 9.16 with the improvement of Entity Framework Core. New data types Uri, IPAddress, PhysicalAddress are supported and еру ability to translate LINQ queries into SQL is expanded. We have also expanded the support for Entity Framework Core Spatial Data functionality used to work with Oracle Spatial and Graph.

Here is the complete list of dotConnect for Oracle 9.16.1434 changes:

Entity Developer

• The behavior is changed: turning off the "Save connection to" option in Model Settings of EF Core Model wipes out connection string literal from the generated code

Entity Framework support

• The SQL translation of the following class members used in the LINQ query is supported in EF Core 3, EF Core 5, EF Core 6:
  • static method IsNullOrWhiteSpace() of the String class
  • static property Today and instance property DayOfWeek of the DateTime class
  • static methods Sqrt(), Max(), Min(), Log(), Log10(), Sin(), Cos(), Tan(), Asin(), Acos(), Atan(), Atan2(), Sinh(), Cosh(), Tanh() of the Math class
• The SQL translation of the following class members used in LINQ query is supported in EF Core 5 and EF Core 6:
  • static methods Abs(), Round(), Truncate(), Floor(), Ceiling(), Pow(), Sqrt(), Max(), Min(), Log(), Log10(), Sin(), Cos(), Tan(), Asin(), Acos(), Atan(), Atan2(), Sinh(), Cosh(), Tanh() of the MathF class
• The SQL translation of the following class members used in LINQ query is supported in EF Core 6:
  • static method Log2() of the Math and MathF classes
• Mapping of internet/intranet data type System.Uri to Oracle string data types is supported in EF Core 3, EF Core 5, EF Core 6
• Mapping of network data types System.Net.IPAddress and System.Net.NetworkInformation.PhysicalAddress to Oracle string data types is supported in EF Core 5 and EF Core 6
• Mapping of Oracle object types like MDSYS.SDO_GEOMETRY or Oracle user-defined object datatypes in a database to the OracleObject class in EF Core 3, EF Core 5, EF Core 6 is supported
• The config.SpatialOptions.PreferSpatialOperators configuration option is added (default value is False) to provide the possibility of using spatial operators instead of functions from the SDO_GEOM package
• The bug with auto savepoints enabled in EF Core 6 transactions is fixed
• The bug with generating the "Value cannot be null" error when dropping indexes via Code-First Migrations in EF Core is fixed
• The bug with a materialization used within the Let operator of LINQ query in EF6 is fixed
• The bug with using .Contains with a collection within .Select of LINQ query in EF Core 2 is fixed

Devart development team
http://www.devart.com/dotconnect/oracle/

Dear users,

We are glad to announce the new features that are available in the Entity Framework support in the latest version:

Common improvements for databases

• The bug with generating the "Value cannot be null" error when dropping indexes via Code-First Migrations in EF Core is fixed (Oracle, MySQL, PostgreSQL, SQLite, DB2)
• The bug with a materialization used within the Let operator of LINQ query in EF6 is fixed (Oracle, MySQL, PostgreSQL, SQLite, DB2)
• The bug with using .Contains with a collection within .Select of LINQ query in EF Core 2 is fixed (Oracle, MySQL, PostgreSQL, SQLite, DB2)

For Oracle

• Mapping of internet/intranet data type System.Uri to Oracle string data types is supported in EF Core 3, EF Core 5, EF Core 6
• Mapping of network data types System.Net.IPAddress and System.Net.NetworkInformation.PhysicalAddress to Oracle string data types is supported in EF Core 5 and EF Core 6
• The SQL translation of the following class members used in the LINQ query is supported in EF Core 3, EF Core 5, EF Core 6:
  • static method IsNullOrWhiteSpace() of the String class
  • static property Today and instance property DayOfWeek of the DateTime class
  • static methods Sqrt(), Max(), Min(), Log(), Log10(), Sin(), Cos(), Tan(), Asin(), Acos(), Atan(), Atan2(), Sinh(), Cosh(), Tanh() of the Math class
• The SQL translation of the following class members used in LINQ query is supported in EF Core 5 and EF Core 6:
  • static methods Abs(), Round(), Truncate(), Floor(), Ceiling(), Pow(), Sqrt(), Max(), Min(), Log(), Log10(), Sin(), Cos(), Tan(), Asin(), Acos(), Atan(), Atan2(), Sinh(), Cosh(), Tanh() of the MathF class
• The SQL translation of the following class members used in the LINQ query is supported in EF Core 6:
  • static method Log2() of the Math and MathF classes
• Mapping of Oracle object types like MDSYS.SDO_GEOMETRY or Oracle user-defined object datatypes in a database to the OracleObject class in EF Core 3, EF Core 5, EF Core 6 is supported
• The config.SpatialOptions.PreferSpatialOperators configuration option is added (default value is False) to provide the possibility of using spatial operators instead of functions from the SDO_GEOM package
• The bug with auto savepoints enabled in EF Core 6 transactions is fixed

For MySQL

• The SQL translation of the following class members used in the LINQ query is supported in EF Core 3, EF Core 5, EF Core 6:
  • static method IsNullOrWhiteSpace() of the String class
  • static property Today and instance property DayOfWeek of the DateTime class
  • static methods Sqrt(), Max(), Min(), Log(), Log10(), Sin(), Cos(), Tan(), Asin(), Acos(), Atan(), Atan2() of the Math class
• The SQL translation of the following class members used in the LINQ query is supported in EF Core 5 and EF Core 6:
  • static methods Abs(), Round(), Truncate(), Floor(), Ceiling(), Pow(), Sqrt(), Max(), Min(), Log(), Log10(), Sin(), Cos(), Tan(), Asin(), Acos(), Atan(), Atan2() of the MathF class
• The SQL translation of the following class members used in the LINQ query is supported in EF Core 6:
  • static method Log2() of the Math and MathF classes
• The new \Entity\EF5\net47\Devart.Data.MySql.Entity.EF5.dll assembly compiled with .NET Framework 4.7 is added
• The new \Entity\EF5\net47\Devart.Data.MySql.Entity.Migrations.EF5.dll assembly compiled with .NET Framework 4.7 is added
• The new \Entity\EF5\net47\Devart.Data.MySql.Entity.Spatials.EF5.dll assembly compiled with .NET Framework 4.7 is added
• The new methods ExtractAsByte(), ExtractAsSByte(), ExtractAsInt16(), ExtractAsInt32(), ExtractAsInt64(), ExtractAsSingle(), ExtractAsDouble(), ExtractAsDecimal(), ExtractAsDateTime() are added to the MySqlJsonFunctions class for working with the JSON data type in LINQ to Entities queries
• Mapping of internet/intranet data type System.Uri to MySQL string data types is supported in EF Core 3, EF Core 5, EF Core 6
• Mapping of network data types System.Net.IPAddress and System.Net.NetworkInformation.PhysicalAddress to MySQL string data types is supported in EF Core 5 and EF Core 6

For PostgreSQL:

• The new \Entity\EF5\net47\Devart.Data.PostgreSql.Entity.EF5.dll assembly compiled with .NET Framework 4.7 is added
• The new \Entity\EF5\net47\Devart.Data.PostgreSql.Entity.Migrations.EF5.dll assembly compiled with .NET Framework 4.7 is added
• The new \Entity\EF5\net47\Devart.Data.PostgreSql.Entity.Spatials.EF5.dll assembly compiled with .NET Framework 4.7 is added
• The bug with throwing the "schema does not exist" error by Database.EnsureDeleted() in EF Core is fixed
• The bug with saving and reading string value NULL to/from HSTORE data type in PostgreSQL mapped to Dictionary<string, string> or ImmutableDictionary<string, string> or SortedDictionary<string, string> or ImmutableSortedDictionary<string, string> in EF Core 3, EF Core 5, EF Core 6 is fixed

Devart development team
http://www.devart.com/dotconnect/entityframework.html

Dear users,

New build of LinqConnect 4.9.2403 is available for download now.

In this version:

• Compatible with dotConnect providers

Devart development team
http://www.devart.com/linqconnect/

Dear users,

New build of dotConnect for SQL Server 3.0.704 is available for download now.

In this version:

• Compatible with other dotConnect providers

Devart development team
http://www.devart.com/dotconnect/sqlserver/

Dear users,

New build of dotConnect for DB2 2.6.1434 is available for download now.

In this version:

Entity Developer

• The behavior is changed: turning off the "Save connection to" option in Model Settings of EF Core Model wipes out connection string literal from the generated code

Entity Framework support

• The bug with generating the "Value cannot be null" error when dropping indexes via Code-First Migrations in EF Core is fixed
• The bug with a materialization used within the Let operator of LINQ query in EF6 is fixed
• The bug with using .Contains with a collection within .Select of LINQ query in EF Core 2 is fixed

Devart development team
http://www.devart.com/dotconnect/db2/

Dear users,

New build of dotConnect for SQLite 5.19.2066 is available for download now.

In this version:

Entity Developer

• The behavior is changed: turning off the "Save connection to" option in Model Settings of EF Core Model wipes out connection string literal from the generated code

Entity Framework support

• The bug with generating the "Value cannot be null" error when dropping indexes via Code-First Migrations in EF Core is fixed
• The bug with a materialization used within the Let operator of LINQ query in EF6 is fixed
• The bug with using .Contains with a collection within .Select of LINQ query in EF Core 2 is fixed

Devart development team
http://www.devart.com/dotconnect/sqlite/

Dear users,

Devart is glad to announce the release of dotConnect for Oracle 9.16 with the improvement of Entity Framework Core. New data types Uri, IPAddress, PhysicalAddress are supported and еру ability to translate LINQ queries into SQL is expanded. We have also expanded the support for Entity Framework Core Spatial Data functionality used to work with Oracle Spatial and Graph.

Here is the complete list of dotConnect for Oracle 9.16.1434 changes:

Entity Developer

• The behavior is changed: turning off the "Save connection to" option in Model Settings of EF Core Model wipes out connection string literal from the generated code

Entity Framework support

• The SQL translation of the following class members used in the LINQ query is supported in EF Core 3, EF Core 5, EF Core 6:
  • static method IsNullOrWhiteSpace() of the String class
  • static property Today and instance property DayOfWeek of the DateTime class
  • static methods Sqrt(), Max(), Min(), Log(), Log10(), Sin(), Cos(), Tan(), Asin(), Acos(), Atan(), Atan2(), Sinh(), Cosh(), Tanh() of the Math class
• The SQL translation of the following class members used in LINQ query is supported in EF Core 5 and EF Core 6:
  • static methods Abs(), Round(), Truncate(), Floor(), Ceiling(), Pow(), Sqrt(), Max(), Min(), Log(), Log10(), Sin(), Cos(), Tan(), Asin(), Acos(), Atan(), Atan2(), Sinh(), Cosh(), Tanh() of the MathF class
• The SQL translation of the following class members used in LINQ query is supported in EF Core 6:
  • static method Log2() of the Math and MathF classes
• Mapping of internet/intranet data type System.Uri to Oracle string data types is supported in EF Core 3, EF Core 5, EF Core 6
• Mapping of network data types System.Net.IPAddress and System.Net.NetworkInformation.PhysicalAddress to Oracle string data types is supported in EF Core 5 and EF Core 6
• Mapping of Oracle object types like MDSYS.SDO_GEOMETRY or Oracle user-defined object datatypes in a database to the OracleObject class in EF Core 3, EF Core 5, EF Core 6 is supported
• The config.SpatialOptions.PreferSpatialOperators configuration option is added (default value is False) to provide the possibility of using spatial operators instead of functions from the SDO_GEOM package
• The bug with auto savepoints enabled in EF Core 6 transactions is fixed
• The bug with generating the "Value cannot be null" error when dropping indexes via Code-First Migrations in EF Core is fixed
• The bug with a materialization used within the Let operator of LINQ query in EF6 is fixed
• The bug with using .Contains with a collection within .Select of LINQ query in EF Core 2 is fixed

Devart development team
http://www.devart.com/dotconnect/oracle/

Dear users,

Devart is glad to announce the release of dotConnect for MySQL 8.21 with significant improvements in Entity Framework Core support. We supported new data types Uri, IPAddress, PhysicalAddress and expanded the capabilities for translating LINQ queries into SQL. Besides, we have improved support for working with JSON in LINQ queries for EF6.

New data types Uri, IPAddress, PhysicalAddress are supported and the capabilities for translating LINQ queries into SQL are expanded. We have also improved support for working with JSON in LINQ queries for EF6.

Here is the complete list of dotConnect for MySQL 8.21.2066 changes:

Entity Developer

• The behavior is changed: turning off the "Save connection to" option in Model Settings of EF Core Model wipes out connection string literal from the generated code
• The behavior is changed: Devart.Data.MySql.Entity.EF5.dll compiled with .NET Framework 4.7 is used now in EF5 models

Entity Framework support

• Mapping of internet/intranet data type System.Uri to MySQL string data types is supported in EF Core 3, EF Core 5, EF Core 6
• Mapping of network data types System.Net.IPAddress and System.Net.NetworkInformation.PhysicalAddress to MySQL string data types is supported in EF Core 5 and EF Core 6
• The SQL translation of the following class members used in LINQ query is supported in EF Core 3, EF Core 5, EF Core 6:
  • static method IsNullOrWhiteSpace() of the String class
  • static property Today and instance property DayOfWeek of the DateTime class
  • static methods Sqrt(), Max(), Min(), Log(), Log10(), Sin(), Cos(), Tan(), Asin(), Acos(), Atan(), Atan2() of the Math class
• The SQL translation of the following class members used in the LINQ query is supported in EF Core 5 and EF Core 6:
  • static methods Abs(), Round(), Truncate(), Floor(), Ceiling(), Pow(), Sqrt(), Max(), Min(), Log(), Log10(), Sin(), Cos(), Tan(), Asin(), Acos(), Atan(), Atan2() of the MathF class
• The SQL translation of the following class members used in the LINQ query is supported in EF Core 6:
  • static method Log2() of the Math and MathF classes
• The new \Entity\EF5\net47\Devart.Data.MySql.Entity.EF5.dll assembly compiled with .NET Framework 4.7 is added
• The new \Entity\EF5\net47\Devart.Data.MySql.Entity.Migrations.EF5.dll assembly compiled with .NET Framework 4.7 is added
• The new \Entity\EF5\net47\Devart.Data.MySql.Entity.Spatials.EF5.dll assembly compiled with .NET Framework 4.7 is added
• The new methods ExtractAsByte(), ExtractAsSByte(), ExtractAsInt16(), ExtractAsInt32(), ExtractAsInt64(), ExtractAsSingle(), ExtractAsDouble(), ExtractAsDecimal(), ExtractAsDateTime() are added to the MySqlJsonFunctions class for working with the JSON data type in LINQ to Entities queries
• The bug with generating the "Value cannot be null" error when dropping indexes via Code-First Migrations in EF Core is fixed
• The bug with a materialization used within the Let operator of LINQ query in EF6 is fixed
• The bug with using .Contains with a collection within .Select of LINQ query in EF Core 2 is fixed

Devart development team
http://www.devart.com/dotconnect/mysql/

Dear users,

Devart is glad to announce the release of dotConnect for PostgreSQL 7.24 — a powerful ADO.NET provider for PostgreSQL with advanced support for Entity Framework, Entity Framework Core, LinqConnect (LINQ to PostgreSQL), and NHibernate. The new release offers support for load balancing that allows specifying multiple hosts with their ports in the Host parameter of the connection string. The servers should be separated by commas.

dotConnect for PostgreSQL now also includes new assemblies for Entity Framework 5, compiled with .NET Framework 4.7.

Here is the complete list of dotConnect for PostgreSQL 7.24.2066 changes:

• The KeepConnected connection string parameter is implemented to determine the number of seconds of connection inactivity before the client sends a ping request
• The Load Balancing support is implemented: now several hosts with their ports can be specified in the Host parameter of the connection string
• The Target Session connection string parameter is added for managing Load Balancing functionality, possible values are SuppressLoadBalancing, Any, PreferStandby, PreferPrimary, Primary, Standby
• The TargetSession property is added to the PgSqlCommand class to provide the possibility to overwrite the behavior of the same option set in the connection object

Entity Developer

• The bug when mapping PostgreSQL inet and macaddr types in Entity Framework Core Model is fixed
• The behavior is changed: turning off the "Save connection to" option in Model Settings of EF Core Model wipes out connection string literal from the generated code
• The behavior is changed: Devart.Data.PostgreSql.Entity.EF5.dll compiled with .NET Framework 4.7 is used now in EF5 models

Entity Framework support

• The new \Entity\EF5\net47\Devart.Data.PostgreSql.Entity.EF5.dll assembly compiled with .NET Framework 4.7 is added
• The new \Entity\EF5\net47\Devart.Data.PostgreSql.Entity.Migrations.EF5.dll assembly compiled with .NET Framework 4.7 is added
• The new \Entity\EF5\net47\Devart.Data.PostgreSql.Entity.Spatials.EF5.dll assembly compiled with .NET Framework 4.7 is added
• The bug with generating the "Value cannot be null" error when dropping indexes via Code-First Migrations in EF Core is fixed
• The bug with a materialization used within the Let operator of LINQ query in EF6 is fixed
• The bug with using .Contains with a collection within .Select of LINQ query in EF Core 2 is fixed
• The bug with throwing the "schema does not exist" error by Database.EnsureDeleted() in EF Core is fixed
• The bug with saving and reading string value NULL to/from HSTORE data type in PostgreSQL mapped to Dictionary<string, string> or ImmutableDictionary<string, string> or SortedDictionary<string, string> or ImmutableSortedDictionary<string, string> in EF Core 3, EF Core 5, EF Core 6 is fixed

Devart development team
http://www.devart.com/dotconnect/postgresql/

Dear users,

New build of dotConnect Universal 3.80.2563 is available for download now.

In this version:
Compatible with other dotConnect providers

Devart development team
http://www.devart.com/dotconnect/universal/

Dear users,

New build of Entity Developer 6.12.1419 is available for download now.

This version includes:

Entity Framework support

• The behavior is changed: turning off the "Save connection to" option in Model Settings of EF Core Model wipes out connection string literal from the generated code

Devart development team
http://www.devart.com/entitydeveloper/

Dear users,

New builds of ADO.NET Providers for Cloud Applications are available for download now.

The build includes the following change:

Entity Developer

• The behavior is changed: turning off the "Save connection to" option in Model Settings of EF Core Model wipes out connection string literal from the generated code

Devart development team
https://www.devart.com/dotconnect/#cloud