public IList<GameDefinitionName> GetAllGameDefinitionNames(int gamingGroupId, string nameQuery = null)
{
var gameDefinitionsQuery = _dataContext.GetQueryable<GameDefinition>()
.Where(gameDefinition => gameDefinition.Active
&& gameDefinition.GamingGroupId == gamingGroupId);
if (!string.IsNullOrEmpty(nameQuery))
{
gameDefinitionsQuery = gameDefinitionsQuery.Where(g => g.Name.Contains(nameQuery));
}
return gameDefinitionsQuery
.Select(gameDefiniton => new GameDefinitionName
{
BoardGameGeekGameDefinitionId = gameDefiniton.BoardGameGeekGameDefinitionId,
Id = gameDefiniton.Id,
Name = gameDefiniton.Name
}).ToList();
}