Re: [Firebird-net-provider] .NET Provider RC2

[Carlos G. A. <car...@te...>]

Hello:

> The users table has data, which is returned running the same query in isql.
> The same thing happens if there is no data in the table.  I am using
> Firebird 1.5 Beta 4 - is this OK?


I'm testing with this sample, and all goes OK:

FbConnection connection = new FbConnection(connectionString);

connection.Open();

FbTransaction transaction = connection.BeginTransaction();

string selectText = "SELECT * FROM users ";
					
FbCommand select = new FbCommand(selectText, connection, transaction);
						
FbDataReader reader = select.ExecuteReader();
									
while (reader.Read())
{
	Console.WriteLine("{0} {1} {2}",
	                 reader.GetValue(0),
	                 reader.GetValue(1),
	                 reader.GetValue(2));
}
			
reader.Close();
transaction.Commit();
connection.Close();


-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

"No tengo dones especiales.Sólo soy apasionadamente curioso"
Albert Einstein, científico.