static void AddAuthor(Author author) { using (LibraryDataEntities db = new LibraryDataEntities()) { db.Author.Add(author); db.SaveChanges(); Console.WriteLine("New author added: " + author.FirstName); } }
static Author GetAuthorByName(string firstName) { using (LibraryDataEntities db = new LibraryDataEntities()) { var author = (from a in db.Author where a.FirstName == firstName select a).FirstOrDefault(); return(author); } }
static void GetAllBook() { using (LibraryDataEntities db = new LibraryDataEntities()) { 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.LastName}, Publisher: {book.Publisher.PublisherName}"); } } }
static void AddBooks(Book book) { using (LibraryDataEntities db = new LibraryDataEntities()) { Book bookCurr = db.Book.Where(b => b.Title == book.Title).FirstOrDefault(); if (bookCurr == null) { db.Book.Add(book); db.SaveChanges(); Console.WriteLine("New book added: " + book.Title); } } }
static void AddPublisher(Publisher publisher) { using (LibraryDataEntities db = new LibraryDataEntities()) { Publisher publisherCurr = db.Publisher.Where(p => p.PublisherName == publisher.PublisherName).FirstOrDefault(); if (publisherCurr == null) { db.Publisher.Add(publisher); db.SaveChanges(); Console.WriteLine("New publisher added: " + publisher.PublisherName); } } }
static void GetAllAuthors() { using (LibraryDataEntities db = new LibraryDataEntities()) { var authors = db.Author.Where(a => a.LastName.StartsWith("A")).ToList(); authors = (from author in db.Author where author.LastName.StartsWith("A") select author).ToList(); foreach (var author in authors) { Console.WriteLine(author.FirstName + " " + author.LastName); } } }