public T GetById(int id)
{
using (var connector = new SqlDbConnector())
{
var command = new SqlCommand($"SELECT TOP 1 * FROM {_tableName} WHERE Id=@Id;");
command.Parameters.AddWithValue("@Id", id);
var reader = connector.ExecuteQueryCommand(command);
return(!reader.Read() ? null : _entityMapper.Map(reader));
}
}
public IEnumerable <T> GetAll()
{
using (var connector = new SqlDbConnector())
{
var command = new SqlCommand($"SELECT * FROM {_tableName};");
var reader = connector.ExecuteQueryCommand(command);
var list = new List <T>();
while (reader.Read())
{
list.Add(_entityMapper.Map(reader));
}
return(list);
}
}
