/// <summary>
/// Executes the command.
/// </summary>
/// <param name="connection">The connection to execute on.</param>
/// <returns>A boolean indicating success.</returns>
public override bool Execute(DbConnection connection)
{
var command = connection.CreateCommand();
command.CommandText = _sqlStatement.GetQuery();
AddParameterToCommand(command, "Code", _codeToRemove, DbType.String);
var affectedRows = command.ExecuteNonQuery();
return(affectedRows > 0);
}
/// <summary>
/// Executes the command.
/// </summary>
/// <param name="connection">The connection to execute on.</param>
/// <returns>A boolean indicating success.</returns>
public override bool Execute(DbConnection connection)
{
var command = connection.CreateCommand();
command.CommandText = string.Format(_sqlStatement.GetQuery(),
GenerateCsvParameterNameString(_idsToRemove.Count, "Id"));
AddIdParameterValues(command, _idsToRemove);
var affectedRows = command.ExecuteNonQuery();
return(affectedRows > 0);
}
/// <summary>
/// Executes the command.
/// </summary>
/// <param name="connection">The connection to execute on.</param>
/// <returns>A boolean indicating success.</returns>
public override bool Execute(DbConnection connection)
{
var command = connection.CreateCommand();
command.CommandText = _sqlStatement.GetQuery();
AddParameterToCommand(command, "Name", _lookup.Name, DbType.String);
AddParameterToCommand(command, "Description", _lookup.Description, DbType.String);
AddParameterToCommand(command, "Code", _lookup.Code, DbType.String);
AddParameterToCommand(command, "Active", _lookup.Active, DbType.Boolean);
var affectedRows = command.ExecuteNonQuery();
return(affectedRows == 1);
}
/// <summary>
/// Executes the command.
/// </summary>
/// <param name="connection">The connection to execute on.</param>
/// <returns>A boolean indicating success.</returns>
public override bool Execute(DbConnection connection)
{
var command = connection.CreateCommand();
command.CommandText = SqlStatement.GetQuery();
var reader = command.ExecuteReader();
// Convert reader into object
if (reader.HasRows)
{
while (reader.Read())
{
Result.Add(CreateEntityFromDataReader(reader));
}
}
reader.Close();
return(true);
}
/// <summary>
/// Executes the command.
/// </summary>
/// <param name="connection">The connection to execute on.</param>
/// <returns>A boolean indicating success.</returns>
public override bool Execute(DbConnection connection)
{
var command = connection.CreateCommand();
command.CommandText = _sqlStatement.GetQuery();
AddParameterToCommand(command, "Id", _idToSelect, DbType.Int32);
var reader = command.ExecuteReader();
// Convert reader into object
if (reader.HasRows)
{
while (reader.Read())
{
Result = CreateEntityFromDataReader(reader);
}
}
reader.Close();
return(true);
}
/// <summary>
/// Executes the command.
/// </summary>
/// <param name="connection">The connection to execute on.</param>
/// <returns>A boolean indicating success.</returns>
public override bool Execute(DbConnection connection)
{
var command = connection.CreateCommand();
command.CommandText = string.Format(_sqlStatement.GetQuery(),
GenerateCsvParameterNameString(_idsToSelect.Count, "Id"));
AddIdParameterValues(command, _idsToSelect);
var reader = command.ExecuteReader();
// Convert reader into object
if (reader.HasRows)
{
while (reader.Read())
{
Result.Add(CreateEntityFromDataReader(reader));
}
}
reader.Close();
return(true);
}
