public Entities.Game Execute(Entities.Filters.Game.Select filter)
{
Entities.Game game = new Entities.Game();
using (DbCommand cmd = _db.GetStoredProcCommand("Game_Select"))
{
_db.AddInParameter(cmd, "@GameID", DbType.Int32, filter.GameID);
using (IDataReader idr = _db.ExecuteReader(cmd))
{
while (idr.Read())
{
game = new Entities.Game(idr);
}
}
}
return game;
}