最近看公司的遗留项目代码,调试的时候发现经常报分布式事务错误,可是整个代码里没有看见开启过事务,于是开始研究,发现了这个.Net Framework1.1时代的产物。
namespace BusinessService { [Transaction(TransactionOption.RequiresNew, Isolation = TransactionIsolationLevel.ReadCommitted)] public class Operation : ServicedComponent, IOperation //public class Operation : MarshalByRefObject, IOperation { private static List<Person> persons = new List<Person>(); private static string dbStr = "Data Source=DESKTOP-PABLR9F;Initial Catalog=MyDB;Integrated Security=True;Connect Timeout=15;Encrypt=False;TrustServerCertificate=True;ApplicationIntent=ReadWrite;MultiSubnetFailover=False"; public Operation() { Console.WriteLine("服务激活..."); } public int AddPerson(Person person) { Console.WriteLine("添加Person..."); var s = persons.FirstOrDefault(x => x.Id == person.Id); if(s==null) { persons.Add(person); return 1; } else { return 0; } } [AutoComplete(true)] public void AddPersons() { List<Person> list = new List<Person>(); for (int i = 1; i <= 5; i++) { Person p = new Person() { Name = "sasha" + i, Age = 14 + i }; list.Add(p); } using (SqlConnection conn = new SqlConnection(dbStr)) { if (conn.State != System.Data.ConnectionState.Open) conn.Open(); using (SqlCommand cmd = conn.CreateCommand()) { foreach (var item in list) { string sql = string.Format("insert into student(name,age,lasttime) values( '{0}',{1},'{2}')",item.Name,item.Age,DateTime.Now); cmd.CommandText = sql; cmd.ExecuteNonQuery(); } } } } [AutoComplete(true)] public void AddPersonRange(ArrayList list) { using (SqlConnection conn = new SqlConnection(dbStr)) { if (conn.State != System.Data.ConnectionState.Open) conn.Open(); using (SqlCommand cmd = conn.CreateCommand()) { foreach (Person item in list) { string sql = string.Format("insert into student(name,age,lasttime) values( '{0}',{1},'{2}')", item.Name, item.Age, DateTime.Now); cmd.CommandText = sql; cmd.ExecuteNonQuery(); } } } } public Person GetPerson(int id) { Console.WriteLine("获取Person..."); return persons.FirstOrDefault(x => x.Id == id); } public DateTime GetTime() { Console.WriteLine("获取时间:"+DateTime.Now); return DateTime.Now; } } }
让类继承ServicedComponent,这样调用类的方法的时候会自动开启事务
然后在方法上加上[AutoComplete(true)]属性,这样在方法结束的时候会自动结束事务
这个项目是用remoting做的,顺便把这个也看了看
整体框架:
接口层:
namespace BusinessContract { [Serializable] public class Person { public int Id { get; set; } public string Name { get; set; } public int Age { get; set; } public DateTime LastTime { get; set; } } }
服务层:
namespace BusinessService { [Transaction(TransactionOption.RequiresNew, Isolation = TransactionIsolationLevel.ReadCommitted)] public class Operation : ServicedComponent, IOperation //public class Operation : MarshalByRefObject, IOperation { private static List<Person> persons = new List<Person>(); private static string dbStr = "Data Source=DESKTOP-PABLR9F;Initial Catalog=MyDB;Integrated Security=True;Connect Timeout=15;Encrypt=False;TrustServerCertificate=True;ApplicationIntent=ReadWrite;MultiSubnetFailover=False"; public Operation() { Console.WriteLine("服务激活..."); } public int AddPerson(Person person) { Console.WriteLine("添加Person..."); var s = persons.FirstOrDefault(x => x.Id == person.Id); if(s==null) { persons.Add(person); return 1; } else { return 0; } } [AutoComplete(true)] public void AddPersons() { List<Person> list = new List<Person>(); for (int i = 1; i <= 5; i++) { Person p = new Person() { Name = "sasha" + i, Age = 14 + i }; list.Add(p); } using (SqlConnection conn = new SqlConnection(dbStr)) { if (conn.State != System.Data.ConnectionState.Open) conn.Open(); using (SqlCommand cmd = conn.CreateCommand()) { foreach (var item in list) { string sql = string.Format("insert into student(name,age,lasttime) values( '{0}',{1},'{2}')",item.Name,item.Age,DateTime.Now); cmd.CommandText = sql; cmd.ExecuteNonQuery(); } } } } [AutoComplete(true)] public void AddPersonRange(ArrayList list) { using (SqlConnection conn = new SqlConnection(dbStr)) { if (conn.State != System.Data.ConnectionState.Open) conn.Open(); using (SqlCommand cmd = conn.CreateCommand()) { foreach (Person item in list) { string sql = string.Format("insert into student(name,age,lasttime) values( '{0}',{1},'{2}')", item.Name, item.Age, DateTime.Now); cmd.CommandText = sql; cmd.ExecuteNonQuery(); } } } } public Person GetPerson(int id) { Console.WriteLine("获取Person..."); return persons.FirstOrDefault(x => x.Id == id); } public DateTime GetTime() { Console.WriteLine("获取时间:"+DateTime.Now); return DateTime.Now; } } }
服务端:
static void Main(string[] args) { //IClientChannelSinkProvider clientProvider = new BinaryClientFormatterSinkProvider(); //IServerChannelSinkProvider serverProvider = new BinaryServerFormatterSinkProvider(); //IDictionary dict = new Hashtable(); //dict["port"] = 8080; //dict["name"] = "myServer"; //HttpChannel channel = new HttpChannel(dict, clientProvider, serverProvider); //int port = Convert.ToInt32(ConfigurationManager.AppSettings["port"].ToString()); //HttpChannel channel = new HttpChannel(port); //ChannelServices.RegisterChannel(channel, false); //RemotingConfiguration.RegisterWellKnownServiceType(typeof(Operation), "ServiceOperation", WellKnownObjectMode.SingleCall); RemotingConfiguration.Configure(AppDomain.CurrentDomain.SetupInformation.ConfigurationFile, false); Console.WriteLine("服务端启动..."); Console.ReadKey(); }
服务端配置:
<system.runtime.remoting> <!--.net remoting配置的根节点--> <application> <!--包含有关远程应用程序使用及公共的对象信息--> <service> <!--服务器端,用于指定以什么方式公开什么对象--> <wellknown mode="Singleton" type="BusinessService.Operation,BusinessService" objectUri="ServiceOperation"/> <!--与wellknown相对是activated,wellknown表示服务器端激活对象,后者为客户端激活对象--> <!--mode表示如何响应客户端请求,Singleton表示单一实例--> <!--type表示要公开的类型,选择指定类型名称(含名称空间),然后指定类型所属.dll文件--> <!--objectUri表示远程对象访问路径--> </service> <channels> <!--用于指定通道信息,可心同时指定多个通道--> <channel port="8080" ref="http"> <clientProviders> <formatter ref="binary" /> </clientProviders> </channel> <!--具体的通道信息,port为端口号,ref为引用的通道类型--> <!--.net 框架提供了http与tcp通道--> </channels> </application> </system.runtime.remoting>
客户端:
static void Main(string[] args) { //HttpChannel channel = new HttpChannel(); //ChannelServices.RegisterChannel(channel, false); RemotingConfiguration.Configure(AppDomain.CurrentDomain.SetupInformation.ConfigurationFile, false); string serverUrl = ConfigurationManager.AppSettings["serverUrl"].ToString(); IOperation op = (IOperation)Activator.GetObject(typeof(IOperation), serverUrl); Console.WriteLine(op.GetTime()); //Console.ReadLine(); Person person = new Person() { Id = 1, Name = "Hello", Age = 10 }; op.AddPerson(person); Person p = op.GetPerson(1); Console.WriteLine(p.Name + ":" + p.Age); List<Person> list = new List<Person>(); ArrayList al = new ArrayList(); for (int i=1;i<=5;i++) { Person p1 = new Person() { Name = "sasha" + i, Age = 14 + i }; list.Add(p1); al.Add(p1); } op.AddPersons(); op.AddPersonRange(al); Console.WriteLine("Done"); Console.ReadKey(); }
客户端配置:
<system.runtime.remoting> <application> <client> <wellknown url="http://10.200.80.172:8080/ServiceOperation" type="BusinessContract.IOperation,BusinessContract"/> </client> <!--远程对象访问路径,域名与IP地址都可以--> <channels> <channel ref="http"/> <!--port为0表示客户端不侦听任何端口--> <clientProviders> <formatter ref="binary" /> </clientProviders> <serverProviders> <formatter ref="binary" /> </serverProviders> </channels> </application> </system.runtime.remoting>
要注意的是:需要把程序集设置为[assembly: ComVisible(true)]
还需要对程序集进行签名: