ADO.NET provider 7.1.0.0 for Firebird is ready

2 Sep 2019 1 mins .NET, C#, Databases in general, Entity Framework, Entity Framework Core, Entity SQL, Firebird, LINQ, SQL, Visual Studio

New version 7.1.0.0 of ADO.NET provider for Firebird is ready for download. The main focus of this release is performance.

There are two main changes around performance – one visible, the other is not. The not visible is, as you’d expect, internals refactoring that saves copying of data hence making all operations faster and requiring less memory (sometimes orders of magnitude less). The other, visible, is replacement of old TraceSource type logging, which was very slow (and inconvenient in .NET Core), with custom one using FbLogManager, which can be easily plugged into NLog, log4net, etc. For convenience sake implementation using Console is provided out of the box. Eventually I’d like to switch to Microsoft.Extensions.Logging.Abstractions, but the wlrd is not there yet.

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

Also huge thanks to companies supporting the development, namely SMS-Timing.

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.