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/
Search found 4096 matches
- Mon 04 Apr 2022 16:01
- Forum: Announcements
- Topic: Meet a new release of SQL Complete - version 6.10
- Replies: 0
- Views: 17802
- Fri 28 Jan 2022 13:00
- Forum: Announcements
- Topic: dotConnect for PostgreSQL 7.24 is released!
- Replies: 0
- Views: 23376
dotConnect for PostgreSQL 7.24 is released!
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:
http://www.devart.com/dotconnect/postgresql/
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
- 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
- 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
http://www.devart.com/dotconnect/postgresql/
- Fri 28 Jan 2022 12:59
- Forum: Announcements
- Topic: dotConnect for MySQL 8.21 is released!
- Replies: 0
- Views: 17894
dotConnect for MySQL 8.21 is released!
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
http://www.devart.com/dotconnect/mysql/
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
- 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
http://www.devart.com/dotconnect/mysql/
- Fri 28 Jan 2022 12:54
- Forum: Announcements
- Topic: dotConnect for Oracle 9.16 is released!
- Replies: 0
- Views: 17742
dotConnect for Oracle 9.16 is released!
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
http://www.devart.com/dotconnect/oracle/
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
- 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
http://www.devart.com/dotconnect/oracle/
- Thu 27 Jan 2022 17:49
- Forum: Entity Framework support
- Topic: New features in the Entity Framework support!
- Replies: 0
- Views: 22863
New features in the Entity Framework support!
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
http://www.devart.com/dotconnect/entityframework.html
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)
- 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
- 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
- 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
http://www.devart.com/dotconnect/entityframework.html
- Thu 27 Jan 2022 10:16
- Forum: LinqConnect (LINQ to SQL support)
- Topic: New build of LinqConnect 4.9.2403 is available!
- Replies: 0
- Views: 22185
New build of LinqConnect 4.9.2403 is available!
Dear users,
New build of LinqConnect 4.9.2403 is available for download now.
In this version:
http://www.devart.com/linqconnect/
New build of LinqConnect 4.9.2403 is available for download now.
In this version:
- Compatible with dotConnect providers
http://www.devart.com/linqconnect/
- Thu 27 Jan 2022 10:09
- Forum: dotConnect for SQL Server
- Topic: New build of dotConnect for SQL Server 3.0.704 is available!
- Replies: 0
- Views: 22591
New build of dotConnect for SQL Server 3.0.704 is available!
Dear users,
New build of dotConnect for SQL Server 3.0.704 is available for download now.
In this version:
http://www.devart.com/dotconnect/sqlserver/
New build of dotConnect for SQL Server 3.0.704 is available for download now.
In this version:
- Compatible with other dotConnect providers
http://www.devart.com/dotconnect/sqlserver/
- Thu 27 Jan 2022 09:59
- Forum: dotConnect for DB2
- Topic: New build of dotConnect for DB2 2.6.1434 is available!
- Replies: 0
- Views: 23042
New build of dotConnect for DB2 2.6.1434 is available!
Dear users,
New build of dotConnect for DB2 2.6.1434 is available for download now.
In this version:
Entity Developer
http://www.devart.com/dotconnect/db2/
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
- 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
http://www.devart.com/dotconnect/db2/
- Thu 27 Jan 2022 09:52
- Forum: dotConnect for SQLite
- Topic: New build of dotConnect for SQLite 5.19.2066 is available
- Replies: 0
- Views: 22248
New build of dotConnect for SQLite 5.19.2066 is available
Dear users,
New build of dotConnect for SQLite 5.19.2066 is available for download now.
In this version:
Entity Developer
http://www.devart.com/dotconnect/sqlite/
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
- 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
http://www.devart.com/dotconnect/sqlite/
- Thu 27 Jan 2022 09:37
- Forum: dotConnect for Oracle
- Topic: dotConnect for Oracle 9.16 is released!
- Replies: 0
- Views: 12977
dotConnect for Oracle 9.16 is released!
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
http://www.devart.com/dotconnect/oracle/
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
- 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
http://www.devart.com/dotconnect/oracle/
- Thu 27 Jan 2022 09:14
- Forum: dotConnect for MySQL
- Topic: dotConnect for MySQL 8.21 is released!
- Replies: 0
- Views: 20917
dotConnect for MySQL 8.21 is released!
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
http://www.devart.com/dotconnect/mysql/
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
- 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
http://www.devart.com/dotconnect/mysql/
- Thu 27 Jan 2022 09:12
- Forum: dotConnect for PostgreSQL
- Topic: dotConnect for PostgreSQL 7.24 is released!
- Replies: 0
- Views: 20152
dotConnect for PostgreSQL 7.24 is released!
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:
http://www.devart.com/dotconnect/postgresql/
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
- 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
- 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
http://www.devart.com/dotconnect/postgresql/
- Thu 27 Jan 2022 07:33
- Forum: dotConnect Universal
- Topic: New build of dotConnect Universal 3.80.2563 is available!
- Replies: 0
- Views: 25116
New build of dotConnect Universal 3.80.2563 is available!
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/
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/
- Wed 26 Jan 2022 20:11
- Forum: Entity Developer
- Topic: New build of Entity Developer 6.12.1419 is available!
- Replies: 0
- Views: 22160
New build of Entity Developer 6.12.1419 is available!
Dear users,
New build of Entity Developer 6.12.1419 is available for download now.
This version includes:
Entity Framework support
http://www.devart.com/entitydeveloper/
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
http://www.devart.com/entitydeveloper/
- Wed 26 Jan 2022 20:00
- Forum: dotConnect for Cloud Applications
- Topic: New builds of ADO.NET Providers for Cloud Applications are available!
- Replies: 0
- Views: 23116
New builds of ADO.NET Providers for Cloud Applications are available!
Dear users,
New builds of ADO.NET Providers for Cloud Applications are available for download now.
The build includes the following change:
Entity Developer
https://www.devart.com/dotconnect/#cloud
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
https://www.devart.com/dotconnect/#cloud