Hello, this code works on MS SQL (returns always 0 (table was empty)):
using (TransactionScope ts = new TransactionScope()) { InsertTestMS(); //ts.Complete(); } Console.WriteLine(SelectTestMS()); private static int SelectTestMS() { using (SqlConnection conn = new SqlConnection(@"Data Source=.\sqlexpress;Initial Catalog=test1;Integrated Security=True;Pooling=False")) { conn.Open(); using (SqlCommand cmd = conn.CreateCommand()) { cmd.CommandText = "select count(id) from ts;"; return (int)cmd.ExecuteScalar(); } } } private static void InsertTestMS() { using (SqlConnection conn = new SqlConnection(@"Data Source=.\sqlexpress;Initial Catalog=test1;Integrated Security=True;Pooling=False")) { conn.Open(); using (SqlCommand cmd = conn.CreateCommand()) { cmd.CommandText = "insert into ts values (1);"; cmd.ExecuteNonQuery(); } } } But on FB it inserts record no matter that no call of Complete method was done. Did I miss something? private static int SelectTestFB() { using (FbConnection conn = new FbConnection(@"port=3050;charset=NONE;dialect=3;servertype=0;datasource=localhost;database=test;userid=SYSDBA;password=masterkey;enlist=true")) { conn.Open(); using (FbCommand cmd = conn.CreateCommand()) { cmd.CommandText = "select count(id) from ts;"; return (int)cmd.ExecuteScalar(); } } } private static void InsertTestFB() { using (FbConnection conn = new FbConnection(@"port=3050;charset=NONE;dialect=3;servertype=0;datasource=localhost;database=test;userid=SYSDBA;password=masterkey;enlist=true")) { conn.Open(); using (FbCommand cmd = conn.CreateCommand()) { cmd.CommandText = "insert into ts values (1);"; cmd.ExecuteNonQuery(); } } } -- Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider