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