static void Main(string[] args)
{
using (BooksLibraryContext db = new BooksLibraryContext())
{
var coll = db.Database.SqlQuery <AuthorInfo>("select * from Authors").ToList();
int countBooks = db.Books.Count();
WriteLine($"countBooks:{countBooks}");
var books = db.Books;
foreach (var book in books)
{
WriteLine($"Title: {book.Title}, PublishName: {book.PublisherInfo.Name}");
foreach (var author in book.Authors)
{
WriteLine($"Name: {author.LastName}, Login: {author.AuthorIndentity.Login}");
}
}
}
ReadKey();
}
public BooksLibraryContext Init()
{
return(_dbContext ?? (_dbContext = new BooksLibraryContext()));
}
