本文整理汇总了C#中System.Data.Common.DbTransaction.Dispose方法的典型用法代码示例。如果您正苦于以下问题:C# DbTransaction.Dispose方法的具体用法?C# DbTransaction.Dispose怎么用?C# DbTransaction.Dispose使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类System.Data.Common.DbTransaction
的用法示例。
在下文中一共展示了DbTransaction.Dispose方法的6个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: CloseTransaction
/// <summary>
/// 关闭事务
/// </summary>
/// <param name="tran">需要关闭的事务对象</param>
public static void CloseTransaction(DbTransaction tran)
{
if (tran == null)
{
return;
}
CloseConnection(tran.Connection);
tran.Dispose();
tran = null;
}
示例2: CloseConnection
/// <summary>
/// Closes the connection.
/// </summary>
/// <param name="tran">The tran.</param>
public void CloseConnection(DbTransaction tran)
{
if (tran.Connection != null)
{
CloseConnection(tran.Connection);
tran.Dispose();
}
}
示例3: Commit
/// <summary>
/// 执行并加入事务
/// </summary>
///
public void Commit()
{
if (_multiSqls.Count > 0)
{
using (DbConnection currentConnet = DbHelper.CreateConnection())
{
DbHelper.OpenCon(currentConnet);
DbCommand command = DbHelper.CreateCommand(currentConnet);
_currentTransaction = command.Connection.BeginTransaction(IsolationLevel.Serializable);
command.Transaction = _currentTransaction;
foreach (string item in _multiSqls)
{
command.Parameters.Clear();
command.CommandText = item ;
command.CommandType = CommandType.Text;
command.ExecuteNonQuery();
}
if (_currentTransaction != null)
{
_currentTransaction.Commit();
_currentTransaction.Dispose();
_currentTransaction = null;
}
DbHelper.CloseCon(currentConnet);
}
}
else
{
using (DbConnection currentConnet = DbHelper.CreateConnection())
{
DbHelper.OpenCon(currentConnet);
DbCommand command = DbHelper.CreateCommand(currentConnet);
_currentTransaction = command.Connection.BeginTransaction();
command.Transaction = _currentTransaction;
foreach (DataBaseAction item in _multiActions)
{
command.Parameters.Clear();
item.DbHelper.MyDbCommand = command;
command.CommandText = item.CreateSql(item.CurrentOperate);
foreach (DataParameter itemparmeters in item.Parameters)
{
DbParameter newParameter = command.CreateParameter();
newParameter.ParameterName = itemparmeters.ParameterName;
newParameter.Value = itemparmeters.Value;
newParameter.DbType = itemparmeters.DbType;
if (itemparmeters.Size > -1)
{
newParameter.Size = itemparmeters.Size;
}
newParameter.Direction = itemparmeters.Direction;
command.Parameters.Add(newParameter);
}
command.ExecuteNonQuery();
}
if (_currentTransaction != null)
{
_currentTransaction.Commit();
_currentTransaction.Dispose();
_currentTransaction = null;
}
DbHelper.CloseCon(currentConnet);
}
}
}
示例4: CloseConnection
public void CloseConnection(DbTransaction tran)
{
if (tran != null &
tran.Connection != null &&
tran.Connection.State != ConnectionState.Closed)
{
CloseConnection(tran.Connection);
tran.Dispose();
}
}
示例5: ExecuteScripts
public bool ExecuteScripts(string connectionString, string providerType, string filePath, ref string expmsg,ref string experror, bool isCommit)
{
bool result = true;
DbProviderFactory provider = GetProviderFactory(providerType);
var connection = provider.CreateConnection();
string statusMsg = "";
try
{
olderBatch = ScriptUtility.GetBatchNumber(connectionString, out olderBatchExecutedOn, false, 0,
providerType);
connection.ConnectionString = connectionString;
connection.Open();
transaction = connection.BeginTransaction(IsolationLevel.ReadCommitted);
result = ExecuteScript(filePath, ref statusMsg);
DateTime now = DateTime.MinValue;
fromBatch = ScriptUtility.GetBatchNumber(connectionString, out now, true, olderBatch, providerType);
lastBatch = ScriptUtility.GetBatchNumber(connectionString, out now, false, olderBatch, providerType);
}
catch (Exception ex)
{
msg = ex.Message;
errormsg=ex.InnerException.Message;
result = false;
}
finally
{
if (transaction != null)
{
if (isCommit)
{
transaction.Commit();
}
else
transaction.Rollback();
}
connection.Close();
transaction.Dispose();
}
expmsg = msg;
experror = string.Format("{0}{1}", errormsg, statusMsg);
return result;
}
示例6: DisposeTransaction
protected void DisposeTransaction(DbTransaction transaction)
{
if (transaction != null)
transaction.Dispose();
}