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());
}
}
