你可以用Com+的事务支持
using System.EnterpriseServices;[ Transaction( TransactionOption.Required ) ]
public class D : ServicedComponent
{
public D(){} [AutoComplete]
public void Add()
{
try{
string strSQL = "...";
...
a.Add( strSQL );
b.Add( strSQL );
}catch{
ContextUtil.SetAbort();
}
}
}另请参见:
ms-help://MS.VSCC/MS.MSDNVS.2052/cpguide/html/cpconprocessingtransactions.htm
ms-help://MS.VSCC/MS.MSDNVS.2052/cpguide/html/cpconautomatictransactionprocessing.htm
ms-help://MS.VSCC/MS.MSDNVS.2052/cpguide/html/cpconservicedcomponentexample.htm
using System.EnterpriseServices;[ Transaction( TransactionOption.Required ) ]
public class D : ServicedComponent
{
public D(){} [AutoComplete]
public void Add()
{
try{
string strSQL = "...";
...
a.Add( strSQL );
b.Add( strSQL );
}catch{
ContextUtil.SetAbort();
}
}
}另请参见:
ms-help://MS.VSCC/MS.MSDNVS.2052/cpguide/html/cpconprocessingtransactions.htm
ms-help://MS.VSCC/MS.MSDNVS.2052/cpguide/html/cpconautomatictransactionprocessing.htm
ms-help://MS.VSCC/MS.MSDNVS.2052/cpguide/html/cpconservicedcomponentexample.htm
那靠约束,触发器什么的。