Murach's ADO.NET 3.5, LINQ,
and the Entity Framework with VB 2008

How to use Entity SQL

Sometimes, you'll need to code queries that are more complex than what you can code with the LINQ to Entities feature that's covered in chapter 18. In that case, you can use Entity SQL instead, as shown in this chapter.

Chapter 19 How to use Entity SQL
An introduction to Entity SQL 622
How to code a Select statement 622
How to execute a Select statement using an object query 624
How to retrieve data using Entity SQL 626
How to retrieve an entity type 626
How to retrieve a primitive type 628
How to retrieve an anonymous type 630
How to use query parameters 632
How to query across relationships 634
How to load related objects 636
How to bind controls 638
A Vendor Invoices application 640
The user interface 640
The Entity Data Model 640
The code for the Vendor Invoices form 642
Additional skills for using Entity SQL 644
How to work directly with the EntityClient data provider 644
How to use query builder methods 646

Murach's ADO.NET 3.5 with VB 2008

Learn more about this book

View the table of contents


More about the eBook



Our 100% Guarantee

First, try our books for 90 days. Then, if you aren't completely convinced that our books are the best ones you've ever used, you can return them for a prompt refund...no questions asked.