public Form1()
{
InitializeComponent();
Author author = new Author {
FirstName = "Иванов", LastName = "Иван"
};
AddAuthor(author);
author = new Author {
FirstName = "Ивнов", LastName = "Антон"
};
AddAuthor(author);
Book book = new Book {
Name = "Book1", Page = 20, Price = 200, AuthorId = 1
};
AddBook(book);
book = new Book {
Name = "Book11", Page = 20, Price = 200, AuthorId = 1
};
AddBook(book);
book = new Book {
Name = "Book2", Page = 20, Price = 200, AuthorId = 2
};
AddBook(book);
using (LibContext db = new LibContext())
{
var text = (from b in db.Books
select
new { Name = b.Name, Page = b.Page, Price = b.Price }
).ToList();
dataGridFind.DataSource = null;
dataGridFind.DataSource = text;
}
}
private void AddAuthor(Author author)
{
using (LibContext db = new LibContext())
{
db.Authors.Add(author);
db.SaveChanges();
}
}
private void AddBook(Book book)
{
using (LibContext db = new LibContext())
{
db.Books.Add(book);
db.SaveChanges();
}
}
private void tbFind_TextChanged(object sender, EventArgs e)
{
using (LibContext db = new LibContext())
{
var list = (from a in db.Authors
from b in db.Books
where b.AuthorId == a.Id && a.FirstName.Contains(tbFind.Text) == true
select(new { Name = b.Name, Page = b.Page, Price = b.Price }
)).ToList();
dataGridFind.DataSource = null;
dataGridFind.DataSource = list;
}
}
