本文整理汇总了C#中System.Data.Common.DbConnection.BeginTransaction方法的典型用法代码示例。如果您正苦于以下问题:C# DbConnection.BeginTransaction方法的具体用法?C# DbConnection.BeginTransaction怎么用?C# DbConnection.BeginTransaction使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类System.Data.Common.DbConnection
的用法示例。
在下文中一共展示了DbConnection.BeginTransaction方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: Open
public void Open(string aConnectionString, ServerType serverType)
{
dbCache.ConnectionString = aConnectionString;
dbCache.ServerType = serverType;
switch (serverType)
{
case ServerType.Firebird:
connection = new FbConnection {ConnectionString = aConnectionString};
break;
case ServerType.MsSql:
connection = new SqlConnection { ConnectionString = aConnectionString };
break;
}
connection.Open();
if (serverType==ServerType.Firebird)
using (var transaction = connection.BeginTransaction())
{
DbData.GetFieldValue(connection, transaction,
"select rdb$set_context('USER_SESSION','RPL_SERVICE','1') from rdb$database;");
transaction.Commit();
}
var t = new Thread(LoadData);
t.Start();
}
示例2: Profile_DeleteProfiles
public static int Profile_DeleteProfiles(DbConnection connection, string applicationName, string [] userNames)
{
int deletedUsers = 0;
string appId = DerbyApplicationsHelper.GetApplicationId (connection, applicationName);
if (appId == null)
return 0;
OleDbTransaction trans = (OleDbTransaction) connection.BeginTransaction ();
try {
foreach (string username in userNames) {
string userId = GetUserId (connection, trans, appId, username);
if (userId == null)
continue;
string queryDelete = "DELETE FROM aspnet_Profile WHERE UserId = ?";
OleDbCommand cmdDelete = new OleDbCommand (queryDelete, (OleDbConnection) connection);
cmdDelete.Transaction = trans;
AddParameter (cmdDelete, "UserId", userId);
cmdDelete.Transaction = trans;
deletedUsers += cmdDelete.ExecuteNonQuery ();
}
trans.Commit ();
return deletedUsers;
}
catch (Exception e) {
trans.Rollback ();
throw e;
}
}
示例3: BeginTransaction
public void BeginTransaction()
{
_db = new SqlDatabase(_strConnection);
_dbConn = _db.CreateConnection();
_dbConn.Open();
_dbTrans = _dbConn.BeginTransaction();
}
示例4: BeginTransaction
public DbTransaction BeginTransaction()
{
Connection = _repo.Connection();
Transaction = Connection.BeginTransaction();
return Transaction;
}
示例5: ClearData
private static void ClearData(DbConnection conn)
{
DbTransaction tx = conn.BeginTransaction();
DbCommand clearCmd = conn.CreateCommand();
clearCmd.CommandText = "DELETE FROM data";
clearCmd.ExecuteNonQuery();
tx.Commit();
}
示例6: TransactionFactory
/// <summary>
/// 对象在构造是,会产生一个打开的数据库连接并打开事务,Command对象也会同时产生
/// </summary>
public TransactionFactory()
{
this.conn = DbHelper.CreateConnection(true);
this.cmd = DbHelper.CreateCommand(conn);
this.ts = conn.BeginTransaction();
this.cmd.Connection = this.conn;
this.cmd.Transaction = ts;
}
示例7: PostgresProcessor
public PostgresProcessor(DbConnection connection, IMigrationGenerator generator, IAnnouncer announcer, IMigrationProcessorOptions options, IDbFactory factory)
: base(generator, announcer, options)
{
this.factory = factory;
Connection = connection;
connection.Open();
Transaction = connection.BeginTransaction();
}
示例8: BeginTransaction
public DbTransaction BeginTransaction()
{
_db = DatabaseFactory.CreateDatabase();
_connection = _db.CreateConnection();
_connection.Open();
_transaction = _connection.BeginTransaction();
return _transaction;
}
示例9: BeginningTransaction
public void BeginningTransaction(DbConnection connection, BeginTransactionInterceptionContext interceptionContext)
{
if (connection is FbConnection
&& interceptionContext.IsolationLevel == IsolationLevel.Serializable
&& IsInMigrations())
{
interceptionContext.Result = connection.BeginTransaction(IsolationLevel.ReadCommitted);
}
}
开发者ID:fishcodelib,项目名称:FirebirdSql.Data.FirebirdClient,代码行数:9,代码来源:FbMigrationsTransactionsInterceptor.cs
示例10: DatabaseInserter
public DatabaseInserter(DbConnection connection, string insertSql)
{
Connection = connection;
_command = Connection.CreateCommand();
_command.Connection = Connection;
_command.CommandText = insertSql;
Connection.Open();
_sqLiteTransaction = Connection.BeginTransaction();
}
示例11: BeginTransaction
/// <summary>
/// ��ʼ����
/// </summary>
/// <param name="conn">DbConnection ����</param>
/// <returns>DbTransaction�������</returns>
public DbTransaction BeginTransaction(DbConnection conn)
{
if (conn == null)
{
throw new ArgumentNullException("conn");
}
DbTransaction tran = conn.BeginTransaction();
return tran;
}
示例12: AddPO
public bool AddPO(PO po)
{
bool result = false;
try
{
Database db = DatabaseFactory.CreateDatabase(Constant.Database_Connection_Name);
connection = db.CreateConnection();
connection.Open();
transaction = connection.BeginTransaction();
DbCommand dbCommand = db.GetStoredProcCommand(Constant.SP_PO_Insert);
db.AddInParameter(dbCommand, "@sPOCode", DbType.String, po.POCode);
db.AddInParameter(dbCommand, "@mPOAmount", DbType.Currency, po.POAmount);
db.AddInParameter(dbCommand, "@mBalanceAmount", DbType.Currency, po.BalanceAmount);
db.AddInParameter(dbCommand, "@iPOCreatedUser", DbType.Int32, po.POCreatedUser);
db.AddInParameter(dbCommand, "@iSupId", DbType.Int32, po.SupId);
db.AddInParameter(dbCommand, "@dtPODate", DbType.DateTime, po.PODate);
db.AddInParameter(dbCommand, "@iRequestedBy", DbType.Int32, po.RequestedBy.Value);
db.AddInParameter(dbCommand, "@sPOComment", DbType.String, po.POComment);
db.AddOutParameter(dbCommand, "@iPOId", DbType.Int32, 4);
if (db.ExecuteNonQuery(dbCommand, transaction) > 0)
{
Int32 newPOID = (Int32)db.GetParameterValue(dbCommand, "@iPOId");
if (newPOID > 0)
{
po.POId = newPOID;
if (this.UpdatePOItems(po, db, transaction))
{
transaction.Commit();
result = true;
}
}
}
}
catch (System.Exception ex)
{
ex.Data.Add("BusinessLayerException", GetType().ToString() + Constant.Error_Seperator + "public bool AddPO(PO po)");
transaction.Rollback();
throw ex;
}
finally
{
if (connection.State == ConnectionState.Open)
{
connection.Close();
}
}
return result;
}
示例13: AddPR
public bool AddPR(PurchaseReturns pr)
{
bool result = false;
try
{
Database db = DatabaseFactory.CreateDatabase(Constant.Database_Connection_Name);
connection = db.CreateConnection();
connection.Open();
transaction = connection.BeginTransaction();
DbCommand dbCommand = db.GetStoredProcCommand(Constant.SP_PR_Insert);
db.AddInParameter(dbCommand, "@iGRNId", DbType.Int64, pr.GRNId);
db.AddInParameter(dbCommand, "@iCreatedBy", DbType.Int32, pr.CreatedBy);
db.AddInParameter(dbCommand, "@mTotalReturns", DbType.Currency, pr.TotalReturns);
db.AddInParameter(dbCommand, "@sComment", DbType.String, pr.Comment);
db.AddInParameter(dbCommand, "@dReturnDate", DbType.Date, pr.ReturnDate);
db.AddOutParameter(dbCommand, "@iPRId", DbType.Int32, 4);
db.AddOutParameter(dbCommand, "@sPRCode", DbType.String, 10);
if (db.ExecuteNonQuery(dbCommand, transaction) > 0)
{
Int32 newPRID = (Int32)db.GetParameterValue(dbCommand, "@iPRId");
string prCode = (string)db.GetParameterValue(dbCommand, "@sPRCode");
if (newPRID > 0)
{
pr.PRId = newPRID;
pr.PRCode = prCode;
if (this.UpdatePRItems(pr, db, transaction))
{
transaction.Commit();
result = true;
}
}
}
}
catch (System.Exception ex)
{
ex.Data.Add("BusinessLayerException", GetType().ToString() + Constant.Error_Seperator + "public bool AddPR(PurchaseReturns pr)");
transaction.Rollback();
throw ex;
}
finally
{
if (connection.State == ConnectionState.Open)
{
connection.Close();
}
}
return result;
}
示例14: CopyTableTransaction
void CopyTableTransaction(DbConnection connection, string tableName, string createTableQuery)
{
using (var transaction = connection.BeginTransaction())
{
CopyTable(connection, tableName, createTableQuery);
DropOldTable(connection, tableName);
transaction.Commit();
}
Vacuum(connection);
WriteLine("Upgrade succeeded.");
}
示例15: AddGetPass
public bool AddGetPass(GetPass getPass)
{
bool result = false;
try
{
Database db = DatabaseFactory.CreateDatabase(Constant.Database_Connection_Name);
connection = db.CreateConnection();
connection.Open();
transaction = connection.BeginTransaction();
DbCommand cmd = db.GetStoredProcCommand(Constant.SP_GetPass_Add);
db.AddInParameter(cmd, "@sGPCode", DbType.String, getPass.GPCode);
db.AddInParameter(cmd, "@iInvoiceId", DbType.Int32, getPass.InvoiceId);
db.AddInParameter(cmd, "@iCreatedBy", DbType.Int32, getPass.CreatedBy);
db.AddOutParameter(cmd, "@biGPId", DbType.Int64, 8);
if (db.ExecuteNonQuery(cmd, transaction) > 0)
{
Int32 newGatePassID = Convert.ToInt32(db.GetParameterValue(cmd, "@biGPId"));
if (newGatePassID > 0)
{
getPass.GPId = newGatePassID;
if (this.UpdateGetPassDetails(getPass, db, transaction))
{
transaction.Commit();
result = true;
}
}
}
}
catch (System.Exception ex)
{
transaction.Rollback();
result = false;
throw ex;
}
finally
{
if (connection.State == ConnectionState.Open)
{
connection.Close();
}
}
return result;
}