Re: [Firebird-net-provider] Re: Inserting a Byte Array

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

Hello:

>> Which version of Firebird and .NET Provider are you using ??
> 
> I'm using Firebird 1.0.2 & .NET Provider 1.1 Alpha 2

I can suggest you to get the 1.5 Alpha 1 :)

> Any ideas?  Let me know if more code is needed to pinpoint my problem.

Thanks, i have a test case like this ( tell to me if it's correct ), 
seems to be working ok for a single execution, i'm going to make test 
using a loop ( the test case uses 1.5 alpha 1 ):

byte[] bytes = new byte[100000*4];
RNGCryptoServiceProvider rng = new RNGCryptoServiceProvider();
rng.GetBytes(bytes);

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

FbTransaction transaction = connection.BeginTransaction();

FbCommand command = new FbCommand("new_procedure", connection, transaction);
command.CommandType = CommandType.StoredProcedure;

command.Parameters.Add("@INT_PARAM", FbDbType.Integer).Value = 
System.DateTime.Now.Millisecond;
command.Parameters.Add("@BLOB_PARAM", FbDbType.Binary).Value = bytes;

command.ExecuteNonQuery();

transaction.Commit();
command.Dispose();	
connection.Close();


And the stored proc:

CREATE PROCEDURE NEW_PROCEDURE (
     INT_PARAM INTEGER,
     BLOB_PARAM BLOB SUB_TYPE 0 SEGMENT SIZE 80)
AS
begin
     INSERT INTO TEST_TABLE_01 (INT_FIELD, BLOB_FIELD) VALUES 
(:INT_PARAM, :BLOB_PARAM);
end










-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain