Re: [Firebird-net-provider] Transactions...

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

Hello:

> Can I change this behaviour and have the transaction not block ? Is
> this something on the ADO.NET side or on the IBExpert side ?

Review which Transaction Isolation are you using in the .NET Data 
provider ( and in IBExpert ) and see how it's configured.

In the .NET Data provider :

tpb.Append(GdsCodes.isc_tpb_version3);
tpb.Append(GdsCodes.isc_tpb_write);
tpb.Append(GdsCodes.isc_tpb_wait);

/* Isolation level */
switch(this.isolationLevel)
{
	case IsolationLevel.Serializable:
		tpb.Append(GdsCodes.isc_tpb_consistency);
		break;

	case IsolationLevel.RepeatableRead:			
		tpb.Append(GdsCodes.isc_tpb_concurrency);
		break;

	case IsolationLevel.ReadUncommitted:
		tpb.Append(GdsCodes.isc_tpb_read_committed);
		tpb.Append(GdsCodes.isc_tpb_rec_version);
		break;

	case IsolationLevel.ReadCommitted:
	default:					
		tpb.Append(GdsCodes.isc_tpb_read_committed);
		tpb.Append(GdsCodes.isc_tpb_no_rec_version);
		break;
}





--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain