public void Run() { Console.WriteLine(); Console.WriteLine("Welcome to the Movie database terminal!"); Console.WriteLine("Write EXIT to quit"); Console.WriteLine(); Console.WriteLine("Example query: NOT Seen AND Score > 60"); Console.WriteLine(); while (true) { try { // Get input from the user. string query = GetInput(); if (query.Equals("exit", StringComparison.OrdinalIgnoreCase)) { break; } // Query the EF context for movies. var movies = _provider.Query <Movie>(_context, query).ToList(); // Output the result. OutputMovies(movies); } catch (Exception ex) { Console.ForegroundColor = ConsoleColor.Red; Console.WriteLine("ERROR: {0}", ex.Message); Console.WriteLine(); Console.ResetColor(); } } }
public async Task <IActionResult> Queried([FromQuery] string q) { var candidates = await QueryProvider.Query <Position>(Db, q) .ToListAsync(); return(Ok(candidates)); }
public List <TEntity> Query <TEntity>(string query) where TEntity : class { if (_provider == null) { throw new InvalidOperationException("Query provider fixture has not been initialized."); } using (var context = new DataContext(_builder.Options)) { return(_provider.Query <TEntity>(context, query).ToList()); } }
public IActionResult Index(string query = null) { var movies = _provider.Query <Movie>(_context, query) .Include(m => m.Genres).ThenInclude(g => g.Genre) .OrderByDescending(movie => movie.Rating) .ToList(); return(View(new SearchResultModel <Movie> { Movies = movies, Query = query })); }
public IQueryable <TEntity> Query <TEntity>(string query) where TEntity : class { return(_provider.Query <TEntity>(_context, query)); }