public void DeleteAll()
{
string sql = SqlServerCommandHelper.GetSimpleDeleteStatement(GetTableName());
SqlCommand command = new SqlCommand(sql);
SqlServerCommandHelper.ExecuteSqlCommand(command);
}
public virtual void Add(T item)
{
var fieldNamesAndValues = GetFieldNamesAndValuesForInsertOrUpdate(item);
SqlCommand command = SqlServerCommandHelper.GetInsertCommand(GetTableName(), fieldNamesAndValues, ID);
item.SetId(SqlServerCommandHelper.ExecuteSqlCommand(command, outputIdValue: true));
}
public virtual void Delete(int id)
{
string sql = SqlServerCommandHelper.GetSimpleDeleteStatement(GetTableName()) + WhereIdEquals();
SqlCommand command = new SqlCommand(sql);
AddIdParameterToCommand(command, id);
SqlServerCommandHelper.ExecuteSqlCommand(command);
}
public virtual void Update(T item)
{
int id = item.Id;
var fieldNamesAndValues = GetFieldNamesAndValuesForInsertOrUpdate(item);
var whereClause = WhereIdEquals();
var whereClauseParameterNamesAndValues = new Dictionary <string, object>();
whereClauseParameterNamesAndValues.Add(ID, id);
SqlCommand command = SqlServerCommandHelper.GetUpdateCommand(GetTableName(), fieldNamesAndValues, whereClause, whereClauseParameterNamesAndValues);
SqlServerCommandHelper.ExecuteSqlCommand(command);
}
