public List<Entities.GamePlayer> Execute(Entities.Filters.GamePlayer.Select filter)
{
List<Entities.GamePlayer> gamePlayers = new List<Entities.GamePlayer>();
using (DbCommand cmd = _db.GetStoredProcCommand("GamePlayer_Select"))
{
_db.AddInParameter(cmd, "@GameID", DbType.Int32, filter.GameID);
if (filter.PlayerType.HasValue)
{
_db.AddInParameter(cmd, "@Type", DbType.Int32, filter.PlayerType);
}
using (IDataReader idr = _db.ExecuteReader(cmd))
{
while (idr.Read())
{
gamePlayers.Add(new Entities.GamePlayer(idr));
}
}
}
return gamePlayers;
}