private static void CreateDb() { using (var context = new LibraryContext()) { var book1 = new Book { Title = "Martin Eden" }; var book2 = new Book { Title = "Sea Wolf" }; var book3 = new Book { Title = "Some book" }; var book4 = new Book { Title = "Another book" }; var book5 = new Book { Title = "Вымышленная книга от вымышленного автора" }; var author1 = new Author { FullName = "Jack London" }; var author2 = new Author { FullName = "Creig Drake" }; var booksAuthors1 = new BooksAuthors { Author = author1, Book = book1 }; var booksAuthors2 = new BooksAuthors { Author = author1, Book = book2 }; var booksAuthors3 = new BooksAuthors { Author = author2, Book = book3 }; var booksAuthors4 = new BooksAuthors { Author = author2, Book = book4 }; var booksAuthors5 = new BooksAuthors { Author = author2, Book = book5 }; var visitor1 = new Visitor { FullName = "Alex Frad", Debtor = false }; var visitor2 = new Visitor { FullName = "Jack Leonardo", Debtor = true, Books = new List <Book> { book4 } }; var visitor3 = new Visitor { FullName = "Marco Polo", Debtor = true, Books = new List <Book> { book1, book2 } }; context.Add(book1); context.Add(book2); context.Add(book3); context.Add(book4); context.Add(book5); context.Add(author1); context.Add(author2); context.Add(booksAuthors1); context.Add(booksAuthors2); context.Add(booksAuthors3); context.Add(booksAuthors4); context.Add(booksAuthors5); context.Add(visitor1); context.Add(visitor2); context.Add(visitor3); context.SaveChanges(); } }
private void FillTables() { var firstClient = new Client { FullName = "Наруто Удзумаки", IsDebtor = false }; var secondClient = new Client { FullName = "Саске Учиха", IsDebtor = true }; var thirdClient = new Client { FullName = "Олег Сергеевич", IsDebtor = true }; var firstAuthor = new Author { FullName = "Джирайя" }; var secondAuthor = new Author { FullName = "Джоан Роулинг" }; var thirdAuthor = new Author { FullName = "Масаши Кишимото" }; var firstBook = new Book { TitleName = "Наруто: Ураганные Хроники" }; var secondBook = new Book { TitleName = "Гарри Поттер" }; var thirdBook = new Book { TitleName = "Наруто Поттер, тактика" }; var fourthBook = new Book { TitleName = "Приди, приди, тактика" }; var firstBooksAuthors = new BooksAuthors { Book = firstBook, Author = thirdAuthor }; var secondBooksAuthors = new BooksAuthors { Book = secondBook, Author = secondAuthor }; var thirdBooksAuthors = new BooksAuthors { Book = thirdBook, Author = firstAuthor }; var fourthBooksAuthors = new BooksAuthors { Book = fourthBook, Author = firstAuthor }; var firstEntry = new LibraryEntry { Book = firstBook, Client = firstClient, ReturnDate = DateTime.Now }; var secondEntry = new LibraryEntry { Book = secondBook, Client = firstClient, ReturnDate = DateTime.Now }; var thirdEntry = new LibraryEntry { Book = thirdBook, Client = secondClient, ReturnDate = DateTime.Now }; context.BooksAuthors.AddRange( new BooksAuthors { Book = thirdBook, Author = secondAuthor }, thirdBooksAuthors, new BooksAuthors { Book = thirdBook, Author = thirdAuthor }); context.Clients.AddRange(firstClient, secondClient, thirdClient); context.Authors.AddRange(firstAuthor, secondAuthor, thirdAuthor); context.Books.AddRange(firstBook, secondBook, thirdBook, fourthBook); context.BooksAuthors.AddRange(firstBooksAuthors, secondBooksAuthors, fourthBooksAuthors); context.LibraryEntries.AddRange(firstEntry, secondEntry, thirdEntry); context.SaveChanges(); }
private static void CreateDb() { using (var context = new LibraryContext()) { var book1 = new Book { Title = "Martin Eden" }; var book2 = new Book { Title = "Sea Wolf" }; var book3 = new Book { Title = "Some book" }; var book4 = new Book { Title = "Another book" }; var author1 = new Author { FullName = "Jack London" }; var author2 = new Author { FullName = "Creig Drake" }; var booksAuthors1 = new BooksAuthors { Author = author1, Book = book1 }; var booksAuthors2 = new BooksAuthors { Author = author1, Book = book2 }; var booksAuthors3 = new BooksAuthors { Author = author2, Book = book3 }; var booksAuthors4 = new BooksAuthors { Author = author2, Book = book4 }; var visitor = new Visitor { FullName = "Alex Frad", Debtor = false }; context.Add(book1); context.Add(book2); context.Add(book3); context.Add(book4); context.Add(author1); context.Add(author2); context.Add(booksAuthors1); context.Add(booksAuthors2); context.Add(booksAuthors3); context.Add(booksAuthors4); context.Add(visitor); context.SaveChanges(); } }