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();
}
}
