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!"); } } }