public SybaseCommand(string commandText, SybaseConnection connection, SybaseTransaction 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 SybaseParameterCollection(this); }
private SybaseCommand(string commandText, SybaseConnection connection, SybaseTransaction transaction, CommandType commandType, UpdateRowSource updatedRowSource, bool designTimeVisible, int commandTimeout, SybaseParameterCollection parameters) { this.commandText = commandText; this.connection = connection; this.transaction = transaction; this.commandType = commandType; this.updatedRowSource = updatedRowSource; this.designTimeVisible = designTimeVisible; this.commandTimeout = commandTimeout; this.parameters = new SybaseParameterCollection(this); for (int i = 0; i < parameters.Count; i++) { this.parameters.Add(((ICloneable)parameters[i]).Clone()); } }
public SybaseTransaction BeginTransaction(IsolationLevel iso, string transactionName) { if (State == ConnectionState.Closed) { throw new InvalidOperationException("The connection is not open."); } if (Transaction != null) { throw new InvalidOperationException("SybaseConnection 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 SybaseTransaction(this, iso); return(transaction); }