Re: [Firebird-net-provider] FBCommand.ExecuteReader and Transactions

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

Hello:

> i want to say, that adding autostart transaction support is not hard to
> implement... Simple add there new constructor for FbCommand or other
> components without transaction and in that start default transaction... in
> close method rollback or commit...

Well, my first idea was to start a new transaction in 
FbStatement.Prepare method if the command don't have a transaction yet 
and it's a select ( probably by check if CommandText start with SELECT ) 
and rollback it in Close method, but this can have problems, for example 
lots of open transactions if you left the connection to close the 
commands .....

> but this is against carlos philosophy... he dont want bind things together
> and want as few relations as possible between connection, trancation and
> command...
> And i like his aproach, im doing high performance apps, so i wand direct
> control about this...
> This is my opinion and my be im wrong, but i was speaking with carlos about
> some time ago and i observed his code a lot... Hi knows that its not hard to
> do that, but i think hi dont want do that :)

Huummm you are right, at this moment if you want to make an application 
that can work with, for example, Firebird and MS Sql Server ( or any 
other ) as database server, you can make a data access layer having in 
mind that you need to start a transaction always before executing a 
command, with this you can solve the problem, this is the reason why i 
think this is not a great problem ( i will try to make a test with MSDE 
or an evaluation version of Sql Server 2000 for being sure about it ).

> carlos if im wrong sorry...

No problem :) , i want to hear opinions about this :)



-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain