entity framework里不同的model使用相同的connection string并且有事务处理

实现目的:

1, 不同的model使用相同的连接字符串

2, 而在不同的model之间的实体操作使用事务

 

代码如下:

 

using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using Snowdream.StoredProcedure; using System.Data.EntityClient; using System.Transactions; namespace Snowdream.StoredProcedure.Web { public partial class WebForm1 : System.Web.UI.Page { //Entities db = new Entities(); MVPEntities db2;// = new MVPEntities(); MVPEntities1 db3;// = new MVPEntities1(); //string econString = @"metadata=res://*/Model2.csdl|res://*/Model2.ssdl|res://*/Model2.msl;provider=System.Data.SqlClient;provider connection string=""Data Source=10.199.130.213;Initial Catalog=MVP;Integrated Security=True;MultipleActiveResultSets=True;"""; //string econString2 = @"metadata=res://*/Model3.csdl|res://*/Model3.ssdl|res://*/Model3.msl;provider=System.Data.SqlClient;provider connection string=""Data Source=10.199.130.213;Initial Catalog=MVP;Integrated Security=True;MultipleActiveResultSets=True;"""; string econString3 = @"metadata=res://*/;provider=System.Data.SqlClient;provider connection string=""Data Source=10.199.130.213;Initial Catalog=MVP;Integrated Security=True;MultipleActiveResultSets=True;"""; protected void Page_Load(object sender, EventArgs e) { //成功试出不同model用同一个connection string, 主要是connection string 要简化 EntityConnection con = new EntityConnection(econString3); db2 = new MVPEntities(con); TextBox8.Text = db2.GetRolesForUser("huangyao"); //using (MVPEntities ctx = new MVPEntities(System.Web.Configuration.WebConfigurationManager.ConnectionStrings["MVPEntities"].ToString())) db3 = new MVPEntities1(econString3); TextBox8.Text = TextBox8.Text + "-------" + db3.tbl_ComLib_Resource.First().ResourceValue; } protected void Button1_Click(object sender, EventArgs e) { //在一个事务了,分别往model2的culture和model3的resource中各插入一条记录, 最后手工抛错,看回不回退 //测试过,可回退 using (TransactionScope ts = new TransactionScope(TransactionScopeOption.RequiresNew)) { tbl_ComLib_Culture culture = new tbl_ComLib_Culture(); culture.CultureCode = ("ZH-" + (new Random().Next()).ToString()).Substring(0, 5); culture.CultureDescription = "ZH-CH" + (new Random().Next()).ToString(); db2.AddTotbl_ComLib_Culture(culture); db2.SaveChanges(); tbl_ComLib_Resource resource = new tbl_ComLib_Resource(); resource.ResourceType = "ResType" + (new Random().Next()).ToString(); resource.CultureCode = "ZH-CN"; resource.ResourceKey = "ResKey" + (new Random().Next()).ToString(); resource.ResourceValue = "ResourceValue" + (new Random().Next()).ToString(); db3.AddTotbl_ComLib_Resource(resource); db3.SaveChanges(); int i = int.Parse("s"); //throw new Exception("抛错了,事务应该不成功"); ts.Complete(); } } } }

 

最后试一下,不同的model,也是不同的connection string时,事务可不可成功处理(提交或回退), 试了,还真可以, 代码如下

protected void Button2_Click(object sender, EventArgs e) { MVPEntities db4 = new MVPEntities(econString); MVPEntities1 db5 = new MVPEntities1(econString2); //在一个事务了,分别往model2的culture和model3的resource中各插入一条记录, 最后手工抛错,看回不回退 //两个DB context分别用不同的connection string //测试过,可回退 using (TransactionScope ts = new TransactionScope(TransactionScopeOption.RequiresNew)) { tbl_ComLib_Culture culture = new tbl_ComLib_Culture(); culture.CultureCode = ("ZH-" + (new Random().Next()).ToString()).Substring(0, 5); culture.CultureDescription = "ZH-CH" + (new Random().Next()).ToString(); db4.AddTotbl_ComLib_Culture(culture); db4.SaveChanges(); tbl_ComLib_Resource resource = new tbl_ComLib_Resource(); resource.ResourceType = "ResType" + (new Random().Next()).ToString(); resource.CultureCode = "ZH-CN"; resource.ResourceKey = "ResKey" + (new Random().Next()).ToString(); resource.ResourceValue = "ResourceValue" + (new Random().Next()).ToString(); db5.AddTotbl_ComLib_Resource(resource); db5.SaveChanges(); //再用存储过程update刚才的记录 db4.TestTransaction(resource.ResourceType, culture.CultureCode); int i = int.Parse("s"); //throw new Exception("抛错了,事务应该不成功"); ts.Complete(); } }