public virtual SqlBatchBuilder EndBatch() { var sql = _stringBuilder.ToString(); var sqlBatch = new SqlBatch(sql); sqlBatch.SuppressTransaction = _transactionSuppressed; if (!string.IsNullOrEmpty(sql)) { _batches.Add(sqlBatch); } _stringBuilder = new IndentedStringBuilder(); return this; }
public virtual SqlBatchBuilder EndBatch() { var sql = _stringBuilder.ToString(); var sqlBatch = new SqlBatch(sql); sqlBatch.SuppressTransaction = _transactionSuppressed; if (!string.IsNullOrEmpty(sql)) { _batches.Add(sqlBatch); } _stringBuilder = new IndentedStringBuilder(); return(this); }
public virtual object ExecuteScalar( IRelationalConnection connection, DbTransaction transaction, string sql) { Check.NotNull(connection, nameof(connection)); Check.NotNull(sql, nameof(sql)); return(Execute( connection, () => { var command = new SqlBatch(sql).CreateCommand(connection, transaction); Logger.LogCommand(command); return command.ExecuteScalar(); })); }
public virtual Task <object> ExecuteScalarAsync( IRelationalConnection connection, DbTransaction transaction, string sql, CancellationToken cancellationToken = default(CancellationToken)) { Check.NotNull(connection, nameof(connection)); Check.NotNull(sql, nameof(sql)); return(ExecuteAsync( connection, () => { var command = new SqlBatch(sql).CreateCommand(connection, transaction); Logger.LogCommand(command); return command.ExecuteScalarAsync(cancellationToken); }, cancellationToken)); }
public virtual Task<object> ExecuteScalarAsync( IRelationalConnection connection, DbTransaction transaction, string sql, CancellationToken cancellationToken = default(CancellationToken)) { Check.NotNull(connection, nameof(connection)); Check.NotNull(sql, nameof(sql)); return ExecuteAsync( connection, () => { var command = new SqlBatch(sql).CreateCommand(connection, transaction); Logger.LogCommand(command); return command.ExecuteScalarAsync(cancellationToken); }, cancellationToken); }
public virtual object ExecuteScalar( IRelationalConnection connection, DbTransaction transaction, string sql) { Check.NotNull(connection, nameof(connection)); Check.NotNull(sql, nameof(sql)); return Execute( connection, () => { var command = new SqlBatch(sql).CreateCommand(connection, transaction); Logger.LogCommand(command); return command.ExecuteScalar(); }); }