DotNetFirebird: Using Firebird SQL in .NET: What's New in Firebird ADO.NET Provider 1.7

The ADO.NET provider 1.7 is currently in RC2. This is the list of main new features (compared to 1.6.3):

New FbConnectionStringBuilder class that allows to build and change the connection string programmatically.
Design-time support for FbDataAdapter (DataSet generator, configuration wizard).
Initial support for Guid data type (Mapped to a CHAR(16) CHARACTER OCTETS field in firebird).
The documentation package now contains preliminary documentation about how the Firebird wire protocol is implemented in the ADO.NET provider.
Internal rework of GDS's implementations.
Added the ability of create and drop databases using connection strings.
The Firebird Services implementation now works using connection strings.
Reimplementation of the Firebird Events System.
Database schema support improvements.
Added new "Isolation Level" parameter for the connection string that allows to set the default IsolationLevel for implicit transactions.
A new FetchSize parameter in the connection string and a new FetchSize property in the FbCommand class.
A better connection pooling implementation.
Support for the OCTETS character set
Array data type support has been improved.
The FbDataAdapter class now executes insert, update and delete commands using always ExecuteNonQuery calls (by override the Update(DataRow[], DataTableMapping) method, this allows to use sp that didn't return values with the FbDataAdapter)

I will come back soon with practical examples of new features.

Posted by Dan : 5:00 AM

Comments:

Hello:

Some other new things on 1.7 are:

* A new FetchSize parameter in the connection string and a new FetchSize property in the FbCommand class.

* A better Connection pooling implementation.

* Support for the OCTETS character set ( it's untested right now but i hope to add some nunit tests before the 1.7 final release :) )

* Array data type support has been improved.

* The FbDataAdapter class now executes insert, update and delete commands using always ExecuteNonWuery calls (by override the Update(DataRow[], DataTableMapping) method, this allows to use sp that didn't return values with the FbDataAdapter)

And a minor correction, there are two things that should be in 1.6.3 as well:

* "The assembly should now be available in the Visual Studio Add Reference dialog box after the installation (when using the installationpackage)."

* "New SQL/DDL batch execution support." (if you mean the classes under the FirebirdSql.Data.Firebird.Isql namespace, the batch command execution on FbCommand and FbDataReader classes has been removed in 1.7 as it was not working correctly for all type of statements)

Keep up the great work in this blog, it's really great !!

--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

# posted by Anonymous : 05 March, 2005 05:12

Thanks for the update, Carlos ;-)

I am updating the overview.

# posted by Dan : 05 March, 2005 13:44

Dan,
Thanks for the good work.
Do you know if the .NET provider 1.7 will work with .NET 2.0?
How do you fill a dataset muliple output parameters when calling a Stored Procedure? TIA!!

# posted by Anonymous : 16 April, 2005 02:54

The v1.7 will work with .NET 2.0. It should also be compilable for Compact Framework .NET.

# posted by Dan : 10 May, 2005 09:33

Dan,
I am trying to use the .net provider in VB. How do I get notification for events? I have not had much luck - an sample "cut and paste" code example would be great - thanks

# posted by Anonymous : 16 July, 2005 00:02

Blog comments are closed.

What's New in Firebird ADO.NET Provider 1.7

Comments:

Previous

Archives