Devart Forums

Dear users!

Devart is glad to announce the release of dotConnect for SQLite 6.0.

The release includes the official support for Visual Studio 2022, .NET 6 compatibility, Entity Framework support improvement, and Entity Developer application toolkit expansion. Please see the list of dotConnect for SQLite 6.0 changes below:

• .NET 6 compatibility
• macOS 11 Arm64 (or "Apple Silicon" or "Apple M1") support.
• Windows 11 is supported.
• Visual Studio 2022 version 17.2 is supported.
• Visual Studio 2022 version 17.3 Preview is supported.

Entity Framework:

• Entity Framework Core 6.0.5 is supported.
• Entity Framework Core 5.0.17 is supported.
• Entity Framework Core 3.1.25 is supported.

Entity Developer:

• 64-bit version of standalone Entity Developer application is added.
• 64-bit version of console Entity Developer application is added.

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

Dear users!

Devart is glad to announce the release of dotConnect for PostgreSQL 8.0.

The release includes the official support for Visual Studio 2022, .NET 6 compatibility, Entity Framework support improvement, and Entity Developer application toolkit expansion. Multiple bugs fixed. Please see the list of dotConnect for PostgreSQL 8.0 changes below:

• .NET 6 compatibility
• macOS 11 Arm64 (or "Apple Silicon" or "Apple M1") support.
• Windows 11 is supported.
• Visual Studio 2022 version 17.2 is supported.
• Visual Studio 2022 version 17.3 Preview is supported.
• The incorrect dump of sequence value is fixed.
• The bug with IPv6 host in the connection string is fixed.The bug when mapping PostgreSQL inet and macaddr types in Entity Framework Core Model is fixed.

Entity Framework:

• Entity Framework Core 6.0.5 is supported.
• Entity Framework Core 5.0.17 is supported.
• Entity Framework Core 3.1.25 is supported.

Entity Developer:

• 64-bit version of standalone Entity Developer application is added.
• 64-bit version of console Entity Developer application is added.

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

Dear users!

Devart is glad to announce the release of dotConnect for MySQL 9.0.

The release includes the official support for Visual Studio 2022, .NET 6 compatibility, Entity Framework support improvement, and Entity Developer application toolkit expansion. Please see the list of dotConnect for MySQL 9.0 changes below:

• .NET 6 compatibility
• macOS 11 Arm64 (or "Apple Silicon" or "Apple M1") support.
• Windows 11 is supported.
• Visual Studio 2022 version 17.2 is supported.
• Visual Studio 2022 version 17.3 Preview is supported.

Entity Framework:

• Entity Framework Core 6.0.5 is supported.
• Entity Framework Core 5.0.17 is supported.
• Entity Framework Core 3.1.25 is supported.

Entity Developer:

• 64-bit version of standalone Entity Developer application is added.
• 64-bit version of console Entity Developer application is added.

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

Dear users!

Devart is glad to announce the release of dotConnect for Oracle 10.0.

The release includes the official support for Visual Studio 2022, .NET 6 compatibility, Entity Framework support improvement, and Entity Developer application toolkit expansion. Please see the list of dotConnect for Oracle 10.0 changes below:

• .NET 6 compatibility
• macOS 11 Arm64 (or "Apple Silicon" or "Apple M1") support.
• Windows 11 is supported.
• Visual Studio 2022 version 17.2 is supported.
• Visual Studio 2022 version 17.3 Preview is supported.
• The bug with the wrong SQL generation in LINQ to Entities when querying nullable boolean in EF Core 3, EF Core 5, and EF Core 6 is fixed.

Entity Framework:

• Entity Framework Core 6.0.5 is supported.
• Entity Framework Core 5.0.17 is supported.
• Entity Framework Core 3.1.25 is supported.

Entity Developer:

• 64-bit version of standalone Entity Developer application is added.
• 64-bit version of console Entity Developer application is added.

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

Dear users,

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

This update includes support for SSMS 19 and a few fixed issues. To learn more about it, please refer to our blog post.

Availability

Download dbForge SQL Complete 6.11 from our website. We would also be glad to hear your feedback.

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

Dear users,

We are glad to inform you that a new release of dbForge Studio for SQL Server v6.2 - our comprehensive SQL Server IDE - has been rolled out.

The release includes a few new useful functions. To learn more about them, refer to our blog post.

Availability

Download dbForge Studio for SQL Server v6.2 from our website and check the newly introduced features in action. We will be glad to hear your feedback regarding the product.

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

We are glad to announce the release of the VirtualDAC version 12.1.

What's new in this release:

• RAD Studio 11.1 Alexandria is supported
• Lazarus 2.2.0 is supported
• Windows 11 is supported
• macOS Monterey is supported
• Fixed bug with executing batch operations with the VirtualQuery component

Devart Development Team

https://www.devart.com/virtualdac

We are glad to announce the release of the UniDAC 11.1 with the support for RAD Studio 11.1 Alexandria, Lazarus 2.2.0, macOS Monterey, and Windows 11.

What's new in this release:

• Fixed bug with executing batch operations with the VirtualQuery component
• Fixed bug with resetting param values when changing param values count
• Fixed bug with AV when using the TCRSSLIOHandler from the SecureBridge demo project as an IOHandler for a connection

Oracle data provider

• Fixed bug with HTTPS tunneling in the Direct mode

SQLServer data provider

• Passing the "client_interface_name" parameter to the server in the Direct mode is added
• Fixed bug with adding a condition to the WHERE clause on calling the AddWhere method
• Fixed bug with a "Cannot modify a read-only dataset" on Delete where all fields are read-only
• Fixed bug with executing batch operations when constants in parameter
• Fixed bug with getting IndexColumns metadata in the Direct mode
• Fixed bug with removing persistent fields in Android
• Fixed bug with AV when encrypting a field

MySQL data provider

• Fixed bug with a "Refresh failed" on Post when RefreshOption = roAfterInsert and SQL contains the same PK more than once
• Fixed bug with an "Unknown column" when adding record containing calculated field when RefreshOption = roAfterInsert
• Fixed bug with fkInternalCalc field after calling the Refresh method

PostgreSQL data provider

• The SCRAM-SHA-256-PLUS authentication mechanism is supported
• "ON CONFLICT" in batch operations is supported
• Open connection performance is improved
• The AddDelete specific option for the Dump component is added
• Dumping of stores procedures via the Dump component is added
• Fixed bug with FieldDesc.IsAutoIncrement = False for fields created as "GENERATED ALWAYS AS IDENTITY"
• Fixed bug with saving JSON fields

InterBase data provider

• Fixed bug with the growing memory consumption
• Fixed bug with loading BLOB columns using the Loader component
• Fixed bug with including international characters in SELECT queries when UseUnicode set to True
• Fixed bug with a "Too many Contexts of Relation/Procedures/Views" error when using update batch operations
• Fixed bug with an "Invalid class typecast" error when editing Blob in Trial Edition is fixed
• Fixed bug with an "Invalid pointer operation" error when using custom constraints

SQLite data provider

• Now the Direct mode is based on version 3.37.2 of the SQLite engine
• Fixed bug with an empty string field value when the database column stores data larger than the field size
• Fixed bug with incorrect DATETIME values handling when DateFormat and TimeFormat connection options are set to non-default values
• Fixed bug with handling DATETIME values that contains the "Z" suffix in milliseconds

MongoDB data provider

• Fixed bug with Access Violation when reading documents that contain a field of type object

ODBC data provider

• Fixed bug with the impossibility of editing a table whose name is specified in the query in a fully-qualified format

Devart Development Team

https://www.devart.com/unidac

We are glad to announce the release of the SDAC 10.1 with the support for RAD Studio 11.1 Alexandria, Lazarus 2.2.0, macOS Monterey, and Windows 11.

What's new in this release:

• Passing the "client_interface_name" parameter to the server in the Direct mode is added
• Fixed bug with adding a condition to the WHERE clause on calling the AddWhere method
• Fixed bug with a "Cannot modify a read-only dataset" on Delete where all fields are read-only
• Fixed bug with executing batch operations when constants in parameters
• Fixed bug with resetting param values when changing param values count
• Fixed bug with getting IndexColumns metadata in the Direct mode
• Fixed bug with removing persistent fields in Android
• Fixed bug with AV when encrypting a field
• Fixed bug with HTTPS tunneling in the Direct mode
• Fixed bug with AV when using the TCRSSLIOHandler from the SecureBridge demo project as an IOHandler for a connection

Devart Development Team

https://www.devart.com/sdac

We are glad to announce the release of the MyDAC 11.1 with the support for RAD Studio 11.1 Alexandria, Lazarus 2.2.0, macOS Monterey, and Windows 11.

What's new in this release:

• The SCRAM-SHA-256-PLUS authentication mechanism is supported
• "ON CONFLICT" in batch operations is supported
• Open connection performance is improved
• The AddDelete property for the Dump component is added
• Dumping of stores procedures via the Dump component is added
• Fixed bug with saving JSON fields
• Fixed bug with the reading of type real
• Fixed bug with TFieldDesc.IsAutoIncrement = False for fields created as "GENERATED ALWAYS AS IDENTITY"
• Fixed bug with resetting param values when changing param values count
• Fixed bug with HTTPS tunneling in the Direct mode
• Fixed bug with AV when using the TCRSSLIOHandler from the SecureBridge demo project as an IOHandler for a connection

Devart Development Team

https://www.devart.com/pgdac

We are glad to announce the release of the ODAC 12.1 with the support for RAD Studio 11.1 Alexandria, Lazarus 2.2.0, macOS Monterey, and Windows 11.

What's new in this release:

• Fixed bug with HTTPS tunneling in the Direct mode
• Fixed bug with resetting param values when changing param values count

Devart Development Team

https://www.devart.com/odac

We are glad to announce the release of the MyDAC 11.1 with the support for RAD Studio 11.1 Alexandria, Lazarus 2.2.0, macOS Monterey, and Windows 11.

What's new in this release:

• Fixed bug with fkInternalCalc field after calling the Refresh method
• Fixed bug with resetting param values when changing param values count
• Fixed bug with a "Refresh failed" on Post when RefreshOption = roAfterInsert and SQL contains the same PK more than once
• Fixed bug with an "Unknown column" when adding record containing calculated field when RefreshOption = roAfterInsert
• Fixed bug with HTTPS tunneling in the Direct mode
• Fixed bug with AV when using the TCRSSLIOHandler from the SecureBridge demo project as an IOHandler for a connection

Devart Development Team

https://www.devart.com/mydac

We are glad to announce the release of the LiteDAC 5.1 which includes the support for RAD Studio 11.1 Alexandria, Lazarus 2.2.0, macOS Monterey, and Windows 11.

What's new in this release:

• Now the Direct mode is based on version 3.37.2 of the SQLite engine
• Fixed bug with an empty value of a string field when the database column stores data larger than the field size
• Fixed bug with incorrect DATETIME values handling when DateFormat and TimeFormat connection options are set to non-default values
• Fixed bug with handling DATETIME values that contains the "Z" suffix in milliseconds
• Fixed bug with resetting param values when changing param values count

Devart Development Team

https://www.devart.com/litedac

Dear users!

We are glad to announce the release of the IBDAC 8.1 which includes the support for RAD Studio 11.1 Alexandria, Lazarus 2.2.0, macOS Monterey, and Windows 11.

What's new in this release:

• Fixed bug with the growing memory consumption
• Fixed bug with loading BLOB columns using the Loader component
• Fixed bug with including international characters in SELECT queries when UseUnicode set to True
• Fixed bug with a "Too many Contexts of Relation/Procedures/Views" error when using update batch operations
• Fixed bug with an "Invalid class typecast" error when editing Blob in Trial Edition is fixed
• Fixed bug with an "Invalid pointer operation" error when using custom constraints
• Fixed bug with resetting param values when changing param values count

Devart Development Team

https://www.devart.com/ibdac

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/