IBProvider v5.16 and ADO.NET Provider v1.18

IBProvider v5.16

Getting a query plan

The new OLE DB property of the command and rowset «IBP:StmtInfo.Plan» returns the query plan.

Renaming properties

• The OLE DB property «IBP_RS_INFO: Result Storage Size» is renamed to «IBP:RsInfo.Result_Storage_Size».
• The OLE DB property «IBP_RS_INFO: Using File Storage» is renamed to «IBP:RsInfo.Using_File_Storage».

In both cases, GUID and numeric identifiers remained the same.

Other changes

1. Improved compatibility with the OLE DB specification in terms of working with Read-Only properties.

2. Minor changes to the RowsAffected calculation algorithm.

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

The new property OleDbCommand::Properties returns object of OleDbCommandProperties class and provides the access to OLE DB command properties.

See a new example of using this property — «Getting statement plan».

Other

1. Added a new example demonstrating the use of VBScript in a C# program.

2. You can download the sample code for “LCPI ADO.NET Data Provider for OL DB” from GitHub.

LCPI .NET SDK for IBProvider

To improve the support of IBProvider in .NET programs, we created a new .NET assembly with the IBProvider SDK.

You can download it from nuget.org and from your personal account from our website.