EFSample.cs

// Copyright 2021-present MongoDB Inc.
//
// Licensed under the Apache License, Version 2.0 (the "License")
// you may not use this file except in compliance with the License.
// You may obtain a copy of the License at
//
// http://www.apache.org/licenses/LICENSE-2.0
//
// Unless required by applicable law or agreed to in writing, software
// distributed under the License is distributed on an "AS IS" BASIS,
// WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
// See the License for the specific language governing permissions and
// limitations under the License.

using System.Collections.Generic;
using System.Linq;
using Microsoft.EntityFrameworkCore;
using MongoDB.Driver;
using MongoDB.Driver.Linq;

namespace BasicSample
{
    public class EFSample
    {
        public List<Movie> GetMovies(double minScore, Genre genre, string titleSearchTerm)
        {
            var dbSet = new MoviesDbContext();

            // EF query (analyzer provides mql as information message)
            var movies = dbSet.Movies
                .Where(m =>
                    m.Genre == genre &&
                    m.Score >= minScore &&
                    m.Title.Contains(titleSearchTerm))
                .ToList();

            return movies;
        }

        public class MoviesDbContext : DbContext
        {
            public DbSet<Movie> Movies { get; set; }

            protected override void OnModelCreating(ModelBuilder modelBuilder)
            {
                base.OnModelCreating(modelBuilder);
            }
        }
    }
}