static void Main()
{
// Запросить все книги
BooksEntities bookContext = new BooksEntities();
var books = from book in bookContext.BookSet
select book;
foreach (var book in books)
{
// Загрузить сведения об авторе
book.AuthorReference.Load();
Console.WriteLine("{0}, {1} {2}",
book.Title, book.Author.FirstName, book.Author.LastName);
}
Console.WriteLine();
Console.WriteLine("Textbooks:");
var textBooks = from book in bookContext.BookSet
where book is Textbook
select book as Textbook;
foreach (var textBook in textBooks)
{
// Загрузить информацию об авторе
textBook.AuthorReference.Load();
Console.WriteLine("{0}, {1} {2} - {3}",
textBook.Title,
textBook.Author.FirstName,
textBook.Author.LastName,
textBook.Subject);
}
Console.WriteLine();
// Добавление сущности
Author me = new Author {
FirstName = "Ben", LastName = "Watson"
};
Book myBook = new Book {
Author = me, Title = "C# 4.0 How-To"
};
bookContext.AddToBookSet(myBook);
bookContext.SaveChanges();
Console.WriteLine("Added my book:");
foreach (var book in from b in bookContext.BookSet select b)
{
book.AuthorReference.Load();
Console.WriteLine("{0}, {1} {2}",
book.Title, book.Author.FirstName, book.Author.LastName);
}
// Удаление сущности
bookContext.DeleteObject(myBook);
bookContext.DeleteObject(me);
bookContext.SaveChanges();
Console.ReadKey();
}
static void Main(string[] args)
{
//query all books
BooksEntities bookContext = new BooksEntities();
var books = from book in bookContext.BookSet select book;
foreach (var book in books)
{
//load the author info
book.AuthorReference.Load();
Console.WriteLine("{0}, {1} {2}", book.Title, book.Author.FirstName, book.Author.LastName);
}
Console.WriteLine();
Console.WriteLine("Textbooks:");
var textBooks = from book in bookContext.BookSet where book is Textbook select book as Textbook;
foreach (var textBook in textBooks)
{
//load the author info
textBook.AuthorReference.Load();
Console.WriteLine("{0}, {1} {2} - {3}", textBook.Title, textBook.Author.FirstName, textBook.Author.LastName, textBook.Subject);
}
Console.WriteLine();
//add a book
Author me = new Author();
me.FirstName = "Ben";
me.LastName = "Watson";
Book myBook = new Book();
myBook.Author = me;
myBook.Title = "C# 4.0 How-To";
bookContext.AddToBookSet(myBook);
bookContext.SaveChanges();
Console.WriteLine("Added my book:");
foreach (var book in from b in bookContext.BookSet select b)
{
book.AuthorReference.Load();
Console.WriteLine("{0}, {1} {2}", book.Title, book.Author.FirstName, book.Author.LastName);
}
//delete the book
bookContext.DeleteObject(myBook);
bookContext.DeleteObject(me);
bookContext.SaveChanges();
Console.ReadKey();
}