public IEnumerable <Book> GetBooksWithoutAuthor() { using (var db = new BooksDBInitializer().CreateDbContext(null)) { return(db.Books.Where(b => b.Authors_Books.Count == 0).Select(b => b).ToList()); } }
public IEnumerable <Publisher> GetPublichsersBooks() { using (var db = new BooksDBInitializer().CreateDbContext(null)) { return(db.Publishers.Include(p => p.Books).ThenInclude(b => b.Genres_Books).ToList()); } }
public IEnumerable <Book> GetBooksWithFewGenres() { using (var db = new BooksDBInitializer().CreateDbContext(null)) { return(db.Books.Where(b => b.Genres_Books.Count > 1).Select(b => b).ToList()); } }