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();
});
}
