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
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
