tabs ↹ over ␣ ␣ ␣ spaces

by Jiří {x2} Činčura

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 Comitted 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).

Profile Picture Jiří Činčura is an independent developer, .NET, C# and Firebird expert, focusing on data and business layers, language constructs, parallelism, databases and performance. He's Microsoft Most Valuable Professional and frequent speaker. You can read his articles, guides and tips and tricks at www.tabsoverspaces.com.