Exemple #1
0
        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();
        }