firebird-net-provider

[Firebird-net-provider] Getbytes don't return blob data

[bcteh_98 <bct...@ya...>]

 Hi, 
I am using Firebird .Net 1.4 beta4 net framework version 1.1.
The  getbytes would not return a data for blob columns. 
It look like have a bug in Getbytes procedure. 
Below is the source.

Pls Help ..
Regards
Teh

Dim sql As String
        sql = "SELECT Picture FROM Categories WHERE categoryid=11"
          Dim cmd As New FbCommand(sql)
        Dim conn As New FbConnection(ConnectionStr)
        conn.Open()
        Dim tx As FbTransaction
        tx = conn.BeginTransaction
        cmd.Connection = conn
        cmd.Transaction = tx
        Dim PictureCol As Integer = 0
        Dim dr As FbDataReader = cmd.ExecuteReader()
        Dim id As Integer
        dr.Read()
        ' id = dr.GetInt32(0)
        Dim b(dr.GetBytes(PictureCol, 0, Nothing, 0, 
Integer.MaxValue) - 1) As Byte
        '  Dim b(dr.GetValue(PictureCol))
        dr.GetBytes(PictureCol, 0, b, 0, b.Length)

        dr.Close()
        conn.Close()
          Dim destfilepath As String = "d:\test15beta.jpg"
        Dim fs As New System.IO.FileStream(DestFilePath, 
IO.FileMode.Create, IO.FileAccess.Write)
        fs.Write(b, 0, b.Length)
        fs.Close()

Re: [Firebird-net-provider] Getbytes don't return blob data

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

Hello:

>  Hi, 
> I am using Firebird .Net 1.4 beta4 net framework version 1.1.
> The  getbytes would not return a data for blob columns. 
> It look like have a bug in Getbytes procedure. 
> Below is the source.

I will try to review this later today, you can get blob value using 
GetValue too.






--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Getbytes don't return blob data

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

Hello:

>  Hi, 
> I am using Firebird .Net 1.4 beta4 net framework version 1.1.
> The  getbytes would not return a data for blob columns. 
> It look like have a bug in Getbytes procedure. 

Seems to be working for me, here is the source:

[Test]
public void ReaderGetBytes()
{
	int id_value = System.DateTime.Now.Millisecond + 20000;
	
	string selectText = "SELECT blob_field FROM TEST WHERE int_field = " + 
id_value.ToString();
	string insertText = "INSERT INTO TEST (int_field, blob_field) 
values(@int_field, @blob_field)";
	
	Console.WriteLine("\r\n\r\nFbDataReader.GetBytes with Binary Blob Test");
	
	Console.WriteLine("Generating an array of temp data");
	// Generate an array of temp data
	byte[] insert_values = new byte[100000*4];
	RNGCryptoServiceProvider rng = new RNGCryptoServiceProvider();
	rng.GetBytes(insert_values);
	
	Console.WriteLine("Executing insert command");

	// Execute insert command
	FbTransaction transaction = Connection.BeginTransaction();

	FbCommand insert = new FbCommand(insertText, Connection, transaction);
	insert.Parameters.Add("@int_field", FbDbType.Integer).Value = id_value;
	insert.Parameters.Add("@blob_field", FbDbType.Binary).Value = 
insert_values;
	insert.ExecuteNonQuery();

	transaction.Commit();

	Console.WriteLine("Checking inserted values");

	// Check that inserted values are correct
	FbCommand select = new FbCommand(selectText, Connection);

	FbDataReader reader = select.ExecuteReader();

	int		index		= 0;
	int		segmentSize	= 1000;
	byte[]	select_values = new byte[100000*4];
	while (reader.Read())
	{
		while (index < 400000)
		{
			reader.GetBytes(0, index, select_values, index, segmentSize);

			index += segmentSize;
		}
	}

	for (int i = 0; i < insert_values.Length; i++)
	{
		if (insert_values[i] != select_values[i])
		{
			throw new Exception("differences at index " + i.ToString());
		}
	}
}





--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain