Devart Forums

Dear users,

We are glad to announce the release of the updated dbForge tools for Oracle, including dbForge Schema Compare, dbForge Data Compare, dbForge Data Generator, and dbForge Documenter.

The major enhancements and features include:

• Connectivity support

• Update of a comparison report in Data/Schema Compare

• Support for search index for JSON in Documenter

• Support for a CLUSTERING attribute in Documenter

• Support for command-line ignore options in Schema Compare

• Updated integration with version control systems in Schema Compare

For more info about dbForge Tools for Oracle and its features, visit our blog.

Tell Us What You Think

We invite you to try the new versions of the dbForge Oracle tools and share your thoughts about the tools with us. This will help us make dbForge tools for Oracle better for you.

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

Dear users,

We are happy to announce the release of dbForge Studio for Oracle 4.4 — an all-in-one IDE that helps Oracle developers and administrators easily handle an extensive number of database-related tasks.

The release brings a number of new features and major improvements. To learn more about them, please refer to our blog.

Availability

Download dbForge Studio for Oracle from our website and feel free to check the newly introduced features yourself. We would be glad to hear your feedback regarding the product.

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

Dear users,

We are glad to announce the release of the updated dbForge tools for Oracle, including dbForge Schema Compare, dbForge Data Compare, dbForge Data Generator, and dbForge Documenter.

The major enhancements and features include:

• Connectivity support

• Update of a comparison report in Data/Schema Compare

• Support for search index for JSON in Documenter

• Support for a CLUSTERING attribute in Documenter

• Support for command-line ignore options in Schema Compare

• Updated integration with version control systems in Schema Compare

For more info about dbForge Tools for Oracle and its features, visit our blog.

Tell Us What You Think

We invite you to try the new versions of the dbForge Oracle tools and share your thoughts about the tools with us. This will help us make dbForge tools for Oracle better for you.

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

Dear users,

We are happy to announce the release of dbForge Studio for Oracle 4.4 — an all-in-one IDE that helps Oracle developers and administrators easily handle an extensive number of database-related tasks.

The release brings a number of new features and major improvements. To learn more about them, please refer to our blog.

Availability

Download dbForge Studio for Oracle from our website and feel free to check the newly introduced features yourself. We would be glad to hear your feedback regarding the product.

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

The Devart team is glad to announce the new release of all ODBC drivers.

What's new in this release:

• Windows 11 is supported
• PostgreSQL 14 is supported
• MariaDB 10.6 is supported

Other significant updates in this release:

• Added support for Windows 11
• Improved compatibility with FICO Mosel
• Improved compatibility with FileMaker
• Improved compatibility with Linked Server in MSSMS
• Improved compatibility with JMP on macOS
• Improved support for an ODBC installer on Windows 2000
• Significantly improved the speed of reading data from NexusDB
• Fixed an issue with updating date and time fields in MS Access

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

Devart is glad to announce the release of the new versions of dotConnect ADO.NET data providers for Oracle, MySQL, PostgreSQL, and SQLite. New versions of Devart products support Entity Framework Core 6.0 and its new features.

New assembly versions for Entity Framework Core 6 are added to the Devart.Data.***.EFCore and Devart.Data.***.EFCore.NetTopologySuite NuGet packages. They are compiled for target framework .NET 6. We have also supported the latest NetTopologySuite version 2.4.0.

List of Products with Entity Framework Core 6 Support


dotConnect for Oracle 9.15 [ Download ] [ New Features ]
dotConnect for MySQL 8.20 [ Download ] [ New Features ]
dotConnect for PostgreSQL 7.23 [ Download ] [ New Features ]
dotConnect for SQLite 5.19 [ Download ] [ New Features ]

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

Dear users,

Devart is glad to announce the release of dotConnect for SQLite 5.19 — a powerful ADO.NET provider for SQLite with advanced support for Entity Framework, Entity Framework Core, LinqConnect (LINQ to SQLite) and NHibernate. The new version of Devart dotConnect for SQLite offers support for Entity Framework Core 6.

New assembly versions for Entity Framework Core 6 are added to the Devart.Data.SQLite.EFCore and Devart.Data.SQLite.EFCore.NetTopologySuite NuGet packages. They are compiled for target framework .NET 6. We have also supported the latest NetTopologySuite version 2.4.0.

Here is the complete list of dotConnect for SQLite 19.2042 features:

Entity Developer

• The model validation is improved: the errors are generated for all entities with QueryType=True in EF Core Model when EF Core version=EF Core 1 in Model Settings
• The bug with wrong automatic assigning QueryType=True for views added to EF Core Model, when EF Core version=EF Core 1 in Model Settings, is fixed
• The bug with throwing System.NullReferenceException when saving the changed value of the "Save connection to" option in Model Settings of EF Core Model is fixed

Entity Framework support

• Entity Framework Core 6.0.1 is supported
• Entity Framework Core 5.0.13 is supported
• Entity Framework Core 3.1.22 is supported
• NetTopologySuite 2.4.0 is supported in EF Core 3, EF Core 5, and EF Core 6
• The bug with throwing the "Expression in SQL tree does not have type mapping assigned" error with NetTopologySuite in EF Core is fixed
• The bug with generating the "Value cannot be null" error when adding or dropping FK via Code-First Migrations in EF Core is fixed
• The bug with filtering on the DateTime column without using a parameter via LINQ query in EF Core 3 and EF Core 5 is fixed

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

Dear users,

Devart is glad to announce the release of dotConnect for PostgreSQL 7.23 — 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 Entity Framework Core 6.

New assembly versions for Entity Framework Core 6 are added to the Devart.Data.PostgreSql.EFCore and Devart.Data.PostgreSql.EFCore.NetTopologySuite NuGet packages. They are compiled for target framework .NET 6. We have also supported the latest NetTopologySuite version 2.4.0.


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

• The bug with reading SSL certificates from MemCryptStorage is fixed

Entity Developer

• The model validation is improved: the errors are generated for all entities with QueryType=True in EF Core Model when EF Core version=EF Core 1 in Model Settings
• The bug with wrong automatic assigning QueryType=True for views added to EF Core Model, when EF Core version=EF Core 1 in Model Settings, is fixed
• The bug with throwing System.NullReferenceException when saving the changed value of the "Save connection to" option in Model Settings of EF Core Model is fixed

Entity Framework support

• Entity Framework Core 6.0.1 is supported
• Entity Framework Core 5.0.13 is supported
• Entity Framework Core 3.1.22 is supported
• NetTopologySuite 2.4.0 is supported in EF Core 3, EF Core 5, and EF Core 6
• The config.SpatialOptions settings are supported in EF Core
• The bug with throwing the "Expression in SQL tree does not have type mapping assigned" error with NetTopologySuite in EF Core is fixed
• The bug with generating the "Value cannot be null" error when adding or dropping FK via Code-First Migrations in EF Core 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.20 — a powerful ADO.NET provider for MySQL with advanced support for Entity Framework, Entity Framework Core, LinqConnect (LINQ to MySQL) and NHibernate. The new release offers support for Entity Framework Core 6.

New assembly versions for Entity Framework Core 6 are added to the Devart.Data.MySql.EFCore and Devart.Data.MySql.EFCore.NetTopologySuite NuGet packages. They are compiled for target framework .NET 6. We have also supported the latest NetTopologySuite version 2.4.0.

Here is the complete list of dotConnect for MySQL 8.20.1782 features:

• The bug with reading SSL certificates from MemCryptStorage is fixed

Entity Developer

• The model validation is improved: the errors are generated for all entities with QueryType=True in EF Core Model when EF Core version=EF Core 1 in Model Settings
• The bug with wrong automatic assigning QueryType=True for views added to EF Core Model, when EF Core version=EF Core 1 in Model Settings, is fixed
• The bug with throwing System.NullReferenceException when saving the changed value of the "Save connection to" option in Model Settings of EF Core Model is fixed

Entity Framework support

• Entity Framework Core 6.0.1 is supported
• Entity Framework Core 5.0.13 is supported
• Entity Framework Core 3.1.22 is supported
• NetTopologySuite 2.4.0 is supported in EF Core 3, EF Core 5, and EF Core 6
• The bug with throwing the "Expression in SQL tree does not have type mapping assigned" error with NetTopologySuite in EF Core is fixed
• The bug with generating the "Value cannot be null" error when adding or dropping FK via Code-First Migrations in EF Core 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.15, Devart ADO.NET data provider for Oracle with support for Entity Framework, Entity Framework Core, LinqConnect (LINQ to Oracle), and NHibernate. The new release offers support for Entity Framework Core 6.

New assembly versions for Entity Framework Core 6 are added to the Devart.Data.Oracle.EFCore and Devart.Data.Oracle.EFCore.NetTopologySuite NuGet packages. They are compiled for target framework .NET 6. We have also supported the latest NetTopologySuite version 2.4.0.

Here is the complete list of dotConnect for Oracle 9.15.1410 features:

• The type converter of the OracleTimeStamp structure is improved for converting to/from DateTime and DateTimeOffset
• The bug with declaring several functions or procedures in the WITH clause executed via the OracleScript class is fixed
• The bug with AUDIT and NOAUDIT statements in the Direct mode is fixed

Entity Developer

• The model validation is improved: the errors are generated for all entities with QueryType=True in EF Core Model when EF Core version=EF Core 1 in Model Settings
• The bug with wrong automatic assigning QueryType=True for views added to EF Core Model, when EF Core version=EF Core 1 in Model Settings, is fixed
• The bug with throwing System.NullReferenceException when saving the changed value of the "Save connection to" option in Model Settings of EF Core Model is fixed

Entity Framework support

• Entity Framework Core 6.0.1 is supported
• Entity Framework Core 5.0.13 is supported
• Entity Framework Core 3.1.22 is supported
• NetTopologySuite 2.4.0 is supported in EF Core 3, EF Core 5, and EF Core 6
• The config.SpatialOptions settings are supported in EF Core
• The bug with throwing the "Expression in SQL tree does not have type mapping assigned" error with NetTopologySuite in EF Core is fixed
• The bug with generating the "Value cannot be null" error when adding or dropping FK via Code-First Migrations in EF Core is fixed
• The bug with calling methods and properties of the Geometry class and its child classes, when the type member returns bool, with NetTopologySuite in EF Core is fixed
• The bug with incomplete SQL generation by update-database -script when config.CodeFirstOptions.DropConstraintsByColumns=true in Entity Framework 6.4.4 is fixed
• The bug with throwing ORA-00920 by the GeometryCollection.Intersects method when using NetTopologySuite spatial service in EF Core 5 is fixed
• The bug with throwing ORA-00920 by the Geometry.Disjoint method when using NetTopologySuite spatial service in EF Core 3 and EF Core 5 is fixed
• The bug with throwing the "Unexpected primitive type kind 'r'." error when using NetTopologySuite spatial service with a geometric constant in EF Core 3 and EF Core 5 is fixed

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

Dear users,

We are thrilled to announce the release of dbForge SQL Tools 6.1—a pack of essential database tools that significantly extend Microsoft SSMS and help boost developer productivity and reduce expenses when working on database-related tasks.

The release brings a number of new features and major improvements. To learn more about the functionality of the newly released version of SQL Tools, please refer to our blog.

Availability

Download dbForge SQL Tools 6.1 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,

We are thrilled to announce the release of dbForge SQL Tools 6.1—a pack of essential database tools that significantly extend Microsoft SSMS and help boost developer productivity and reduce expenses when working on database-related tasks.

The release brings a number of new features and major improvements. To learn more about the functionality of the newly released version of SQL Tools, please refer to our blog.

Availability

Download dbForge SQL Tools 6.1 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,

We are thrilled to roll out the new version of dbForge Studio for SQL Server—our multi-featured IDE for database development, management, and administration. The release brings a number of new features and improvements.

In the previous update of dbForge Studio for SQL Server, we introduced the long-awaited DevOps Automation feature. In this version, we keep perfecting the DevOps capabilities and improve the functionality further for you to be able to embrace and implement the best DevOps practices in your routine. To learn more about the features of the newly released version of the Studio, please refer to our blog.

Availability

Download dbForge Studio for SQL Server from our website and check its 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,

We are thrilled to roll out the new version of dbForge Studio for SQL Server—our multi-featured IDE for database development, management, and administration. The release brings a number of new features and improvements.

In the previous update of dbForge Studio for SQL Server, we introduced the long-awaited DevOps Automation feature. In this version, we keep perfecting the DevOps capabilities and improve the functionality further for you to be able to embrace and implement the best DevOps practices in your routine. To learn more about the features of the newly released version of the Studio, please refer to our blog.

Availability

Download dbForge Studio for SQL Server from our website and check its 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,

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

• Entity Framework Core 6.0.1 is supported (MySQL, Oracle, PostgreSQL, SQLite)
• Entity Framework Core 5.0.13 is supported (MySQL, Oracle, PostgreSQL, SQLite)
• Entity Framework Core 3.1.22 is supported
• The config.SpatialOptions settings are supported in EF Core (Oracle, PostgreSQL)
• The bug with throwing the "Expression in SQL tree does not have type mapping assigned" error with NetTopologySuite in EF Core is fixed (MySQL, Oracle, PostgreSQL, SQLite)
• The bug with generating the "Value cannot be null" error when adding or dropping FK via Code-First Migrations in EF Core is fixed (MySQL, Oracle, PostgreSQL, SQLite, DB2)
• The bug with filtering on the DateTime column without using a parameter via LINQ query in EF Core 3 and EF Core 5 is fixed (SQLite)
• The bug with calling methods and properties of the Geometry class and its child classes, when the type member returns bool, with NetTopologySuite in EF Core is fixed (Oracle)
• The bug with incomplete SQL generation by update-database -script when config.CodeFirstOptions.DropConstraintsByColumns=true in Entity Framework 6.4.4 is fixed (Oracle)
• The bug with throwing ORA-00920 by the GeometryCollection.Intersects method when using NetTopologySuite spatial service in EF Core 5 is fixed (Oracle)
• The bug with throwing ORA-00920 by the Geometry.Disjoint method when using NetTopologySuite spatial service in EF Core 3 and EF Core 5 is fixed (Oracle)
• The bug with throwing the "Unexpected primitive type kind 'r'." error when using NetTopologySuite spatial service with a geometric constant in EF Core 3 and EF Core 5 is fixed (Oracle)

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