[Firebird-net-provider] Developement status report

[<car...@te...>]

Hello:

* I have committed yesterday some changes (important in my opinion)
to the FbCommand.Connection and FbCommand.Transaction properties,
the SqlCommand.Connection .NET documentation says:

"If you set *Connection* while a transaction is in progress and the 
Transaction <frlrfsystemdatasqlclientsqlcommandclasstransactiontopic.htm>
property is not null, an InvalidOperationException 
<frlrfsysteminvalidoperationexceptionclasstopic.htm> is generated."

This is in both .NET Framework 1.0 and 1.1. documentation, but after 
some tests
with SqlClient against MSDE 2000 Release A that seems to be untrue, i 
have removed
that check and the exception than was raised.

* Today i have committed some changes for try to improve the DataReader 
implementation:

    - Make it more readable and easy to maintain.

    - Changed open field by isClosed.
   
    - Changed constructor parameters.

    - Improved exception handling, now it's more close to SqlClient,
    the sample used for test it, in SqlClient, was:


            string sql = "SELECT * FROM Customers";

            SqlConnection connection = new SqlConnection(connectionString);
            connection.Open();

            SqlCommand command = new SqlCommand(sql, connection);

            SqlDataReader reader = command.ExecuteReader();
            while(reader.Read())
            {
            }

            // Add calls to reader methods ere
                       
            reader.Close();

            // Add calls to reader methods ere

            connection.Close();

* I have started to work in the Borland Data Provider too, now than i have
installed the Delphi .NET trial and i can do some tests with it, but there
are no so much code done yet.

This was going to be implemented in a first time by Abel Eduardo Pereira 
but
he seems to be busy (Abel Eduardo if you read this, please, contact me,
i have sent to you an email to your sourceforge account, because i have lost
my Address book and doesn't have your real email now :P)




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain