static Author GetAuthorById(int id)
{
using (Library2Entities db = new Library2Entities())
{
var author = db.Author.Find(id);
return(author);
}
}
static void AddBook(Book book)
{
using (Library2Entities db = new Library2Entities())
{
db.Book.Add(book);
db.SaveChanges();
Console.WriteLine($"New book aded!");
}
}
static void AddAuthor(Author author)
{
using (Library2Entities db = new Library2Entities())
{
db.Author.Add(author);
db.SaveChanges();
Console.WriteLine($"New author success added! {author.LastName}");
}
}
//first(), firstOrDefoult
static Author GetAuthorByName(string fname)
{
using (Library2Entities db = new Library2Entities())
{
//return (from a in db.Author
// where a.FirstName == fname
// select a).FirstOrDefault();
return(db.Author.Where(au => au.FirstName == fname).FirstOrDefault());
}
}
static void GetAllAuthors()
{
using (Library2Entities db = new Library2Entities())
{
var au = db.Author.ToList();
foreach (var item in au)
{
Console.WriteLine($"{item.FirstName} {item.LastName}");
}
}
}
//Свойства навигации
static void GetBook()
{
using (Library2Entities db = new Library2Entities())
{
var books = db.Book.OrderBy(b => b.Title).ToList();
foreach (var book in books)
{
Console.WriteLine($"Book: {book.Title}, Price: {book.Price}, Author: {book.Author.FirstName}");
}
}
}
//Заполнение БД
static void AddPublisher(Publisher publisher)
{
using (Library2Entities db = new Library2Entities())
{
Publisher a = db.Publisher.Where(pub => pub.PublisherName == publisher.PublisherName).FirstOrDefault();
if (a == null)
{
db.Publisher.Add(publisher);
db.SaveChanges();
Console.WriteLine($"New publisher aded!");
}
}
}
