static void Main(string[] args)
{
DoMultiple();
var options = new DbContextOptionsBuilder <DBContext1>()
.UseSqlServer(new Microsoft.Data.SqlClient.SqlConnection("Data Source=.;Initial Catalog=db1;Integrated Security=True; "))
.Options;
var options2 = new DbContextOptionsBuilder <DBContext2>()
.UseSqlServer(new Microsoft.Data.SqlClient.SqlConnection("Data Source=.;Initial Catalog=db2;Integrated Security=True; "))
.Options;
using (var context1 = new DBContext1(options))
{
using (var transaction = context1.Database.BeginTransaction())
{
try
{
context1.Blogs.Add(new Blog {
Url = "http://blogs.msdn.com/dotnet"
});
context1.SaveChanges();
using (var context2 = new DBContext2(options2))
{
context2.Database.UseTransaction(transaction.GetDbTransaction());
context2.Add(new Persons()
{
Name = "m1"
});
}
// Commit transaction if all commands succeed, transaction will auto-rollback
// when disposed if either commands fails
transaction.Commit();
}
catch (Exception)
{
// TODO: Handle failure
}
}
//// ///////////////////////////////////////////////
}
var optionsBuilder = new DbContextOptionsBuilder <DBContext1>();
optionsBuilder.UseSqlServer("Data Source=.;Initial Catalog=db1;Integrated Security=True; ");
using (DBContext1 context1 = new DBContext1(optionsBuilder.Options))
{
using (var transaction = context1.Database.BeginTransaction())
{
context1.Add(new Blog {
Url = "url tran"
});
context1.SaveChanges();
using (DBContext1 context2 = new DBContext1(optionsBuilder.Options))
{
DbTransaction tran = transaction.GetDbTransaction();
context2.Database.UseTransaction(tran);
context1.Add(new Blog {
Url = "url tran"
});
//context2.Add(new Persons() { Name = "m1" });
}
transaction.Commit();
}
}
}
