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