ADO.NET provider 7.10.0.0 for Firebird is ready

4 Dec 2020 1 mins .NET, C#, Databases in general, Entity Framework, Entity Framework Core, Entity SQL, Firebird, LINQ, SQL, Visual Studio

New version 7.10.0.0 of ADO.NET provider for Firebird is ready for download. This release brings support for new datatypes in Firebird 4 and various improvements across the codebase.

The support for new Firebird 4 datatypes surfaces via three new datatype. FbDecFloat handles working with DECFLOAT(16) and DECFLOAT(34). FbZonedDateTime and FbZonedTime for TIMESTAMP WITH TIME ZONE and TIME WITH TIME ZONE respectively, including support for EXTENDED representation. The INT128 uses regular .NET BigInteger. Give these types and try and provide a feedback about what type of API/operations would be helpful (i.e. casting FbDecFloat to float/double), because the API surface at the moment focuses only on the most straightforward API/operations. More information and examples can be found in docs.

Other pieces worth mentioning are DNET-970 or DNET-907, better throughput for connection pooling and support for Read Committed Read Consistency isolation level respectively.

Overview of all the changes can be found in tracker.

You can get the bits from NuGet FirebirdSql.Data.FirebirdClient, EntityFramework.Firebird and FirebirdSql.EntityFrameworkCore.Firebird (or from firebirdsql.org).

Jiří Činčura is .NET, C# and Firebird expert. He focuses on data and business layers, language constructs, parallelism, databases and performance. For almost two decades he contributes to open-source, i.e. FirebirdClient. He works as a senior software engineer for Microsoft. Frequent speaker and blogger at www.tabsoverspaces.com.