Hello:
> > Could some one post here sample of using TransactionScope with
> Firebird database, as I heard support for TransactionScope should be
> implemented in FireBird .net provider 2.1.0.0 Beta 2.
Could you check if something like this works for you ??
FbConnectionStringBuilder csb = new
FbConnectionStringBuilder();
csb.Database = @"C:EMPLOYEE.FDB";
csb.DataSource = "localhost";
csb.UserID = "sysdba";
csb.Password = "masterkey";
csb.Pooling = false;
csb.Enlist = true;
using (TransactionScope scope = new TransactionScope())
{
using (FbConnection c = new FbConnection(csb.ToString()))
{
c.Open();
using (FbCommand command = new FbCommand("insert
into table_name values(@valor)", c))
{
command.Parameters.AddWithValue("valor", 1);
}
}
// scope.Complete();
}
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
