public TdsCommand (string commandText, TdsConnection connection, TdsTransaction transaction) { this.commandText = commandText; this.connection = connection; this.transaction = transaction; this.commandType = CommandType.Text; this.updatedRowSource = UpdateRowSource.Both; this.designTimeVisible = false; this.commandTimeout = 30; parameters = new TdsParameterCollection (this); }
public TdsCommand(string commandText, TdsConnection connection, TdsTransaction transaction) { this.commandText = commandText; this.connection = connection; this.transaction = transaction; this.commandType = CommandType.Text; this.updatedRowSource = UpdateRowSource.Both; this.designTimeVisible = false; this.commandTimeout = 30; parameters = new TdsParameterCollection(this); }
public TdsTransaction BeginTransaction(IsolationLevel iso, string transactionName) { if (State == ConnectionState.Closed) { throw new InvalidOperationException("The connection is not open."); } if (Transaction != null) { throw new InvalidOperationException("TdsConnection does not support parallel transactions."); } string isolevel = String.Empty; switch (iso) { case IsolationLevel.Chaos: isolevel = "CHAOS"; break; case IsolationLevel.ReadCommitted: isolevel = "READ COMMITTED"; break; case IsolationLevel.ReadUncommitted: isolevel = "READ UNCOMMITTED"; break; case IsolationLevel.RepeatableRead: isolevel = "REPEATABLE READ"; break; case IsolationLevel.Serializable: isolevel = "SERIALIZABLE"; break; } tds.Execute(String.Format("SET TRANSACTION ISOLATION LEVEL {0}\nBEGIN TRANSACTION {1}", isolevel, transactionName)); transaction = new TdsTransaction(this, iso); return(transaction); }
public TdsTransaction BeginTransaction (IsolationLevel iso, string transactionName) { if (State == ConnectionState.Closed) throw new InvalidOperationException ("The connection is not open."); if (Transaction != null) throw new InvalidOperationException ("TdsConnection does not support parallel transactions."); string isolevel = String.Empty; switch (iso) { case IsolationLevel.Chaos: isolevel = "CHAOS"; break; case IsolationLevel.ReadCommitted: isolevel = "READ COMMITTED"; break; case IsolationLevel.ReadUncommitted: isolevel = "READ UNCOMMITTED"; break; case IsolationLevel.RepeatableRead: isolevel = "REPEATABLE READ"; break; case IsolationLevel.Serializable: isolevel = "SERIALIZABLE"; break; } tds.Execute (String.Format ("SET TRANSACTION ISOLATION LEVEL {0}\nBEGIN TRANSACTION {1}", isolevel, transactionName)); transaction = new TdsTransaction (this, iso); return transaction; }