static void AddAuthor(Author author) { using (LibraryDataEntities db = new LibraryDataEntities()) { db.Author.Add(author); db.SaveChanges(); Console.WriteLine("New author added: " + author.FirstName); } }
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); } } }