public List <StandardBeer> GetBeers(ICollection <int> beerId, string category)
{
var berrs = new List <StandardBeer>();
using (var connection = OpenConnection())
{
string viewName = $"v_CST4714_IB_{category}";
string query = $"select * from {viewName} WHERE BEERID in ({string.Join(",",beerId)})";
var dataReader = ExecuteQueryAsReader(query, connection);
if (dataReader.HasRows)
{
while (dataReader.Read())
{
berrs.Add(StandardBeer.CreateEntity(dataReader, category));
}
}
}
return(berrs);
}
