Source Code Of IBProvider Client For Firebird

Hello Everyone.

Recently we published the source code of IBProvider built-in client for work with Firebird without fbclient.dll.

https://github.com/ibprovider/TechDemo-IBProvider.FirebirdClient-v01

It supports Firebird from v0.9.4 till v3.0.

It’s a stable and completely tested thing which has worked since 2017.

If you are interested in such things – you are welcome.

Source code of the test system is available, too.

License: MIT.

Regards, IBProvider team.

Release of EFCore Provider for IBProvider

Hello All!

We have a great New Year’s gift for everyone who uses IBProvider to work with Firebird.

This is the provider for Entity Framework Core v6.0 — Lcpi.EFCore.LcpiOleDb!

We tried to make it as good as possible.

And most importantly — we opened its source code!

So you can make it even better 🙂

Target platform

  • NET6 (Windows)
  • Entity Framework Core v6.0
  • Firebird v3.0.8
  • LCPI ADO.NET Provider for OLE DB
  • LCPI.IBProvider v5

Key Features

  • Supporting of databases with 1 and 3 dialects.
  • Supporting of all FB3 datatypes, except arrays.
  • Providing a local evaluation by server’s rules.
  • Supporting mapping wide set of C# functions to SQL.
  • Providing extensions for nullable value types.

Acknowledgments

Thanks to our users and special thanks to Jeff Hampton who initiated this development process.

Thanks to the EFCore developers and special thanks to Andriy Svyryd.

Thanks to the developers npgsql/efcore.pg and FirebirdSQL/NETProvider.

Links

This news on our website: https://www.ibprovider.com/eng/news/n_211220-lcpi_efcore_lcpioledb.html

KR, IBProvider Team.

IBProvider News. Visual Studio 2022 support

Hello Everyone!

64-bit Visual Studio 2022 is out today!

We couldn’t stay away from this epic release of Visual Studio and happy to provide support for this IDE from our components.

LCPI ADO.NET Provider for OLE DB v1.25.1

This release contains new DDEX providers for Visual Studio 2022.

We ported all DDEX providers, which were created for VS2019 and FW4.5.0/4.6.2/4.7.2/4.8.0, .NET Standard 2.0.

Moreover, we added DDEX provider for FW3.5.

All DDEX providers packaged into VSIX installers and automatically registering in VS2022.

Just remind, previous releases added the ADO.NET provider for NET6, which supports new system data types: DateOnly and TimeOnly.

IBProvider v5.24 and «LCPI OLE DB Services» v1.20

These releases added vc17 assemblies, compiled by a new studio C++ compiler.

Read more: https://www.ibprovider.com/eng/news/n_211108-vs2022.html

KR, IBProvider Team.

Load testing of IBProvider v5.21.1 and Firebird v3.0.7

Hello All.

We have good news for everyone who uses IBProvider in critical and complex systems.

A «large», multithreaded, load testing of the latest release of IBProvider v5.21.1 and Firebird v3.0.7 (SS, Win, x64) has been carried out.

This is more than 7 million tests that were performed on a 10-core processor.

The main point of this testing was that the global cache of the SQL query parser was used (sql_cache__scope=db).

As usual, the built-in client for Firebird (dbclient_type=fb.direct) was used.

Testing completed with no visible problems.

See additional info at our web site: https://www.ibprovider.com/eng/news/n_201225.html

Best regards, IBProvider Team.

IBProvider v5.21. SQL query parser cache implementation

In this release of IBProvider v5, we have implemented caching the results of our own SQL query parser.

The SQL query parser is needed to define the type of query and its parameter list as well as to divide the script into separate expressions.

The SQL query cache (SQL Cache) supplements the server query cache (Stmt Cache) implemented way back in the earlier versions of IBProvider v3.

Both SQL Cache and Stmt Cache use separate threads to service their own state.

The SQL query cache works for both user queries and service queries of updatable rowset.

Read more at IBProvider Site

Kind Regards, IBProvider Team.

IBProvider v5.19. Advanced load testing

Hello Everyone,

All changes in the current IBProvider release are related to the reorganization of the source code. If you are using v5.18, you can skip this update.

In addition to standard checks, IBProvider v5.19 (vc16, x64) went through advanced load testing. Within 42.5 days, ~7 million tests, applicable in FB3, were run through the debug build of the provider and our connection pool (LCPI OLE DB Services).

Full news text – https://www.ibprovider.com/eng/news/n_200723.html

Kind Regards, IBProvider team.

IBProvider News

Hello Everyone,

We are released new updates for our products.

IBProvider v5.16

LCPI ADO.NET Data Provider for OLE DB v1.18

Full news text: https://www.ibprovider.com/eng/news/n_200421.html

Kind Regards, IBProvider Team.

1 2 3 10