Murach's ADO.NET 3.5, LINQ,
and the Entity Framework with C# 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 614
How to code a Select statement 614
How to execute a Select statement using an object query 616
How to retrieve data using Entity SQL 618
How to retrieve an entity type 618
How to retrieve a primitive type 620
How to retrieve an anonymous type 622
How to use query parameters 624
How to query across relationships 626
How to load related objects 628
How to bind controls 630
A Vendor Invoices application 632
The user interface 632
The Entity Data Model 632
The code for the Vendor Invoices form 634
Additional skills for using Entity SQL 636
How to work directly with the EntityClient provider 636
How to use query builder methods 638




Murach's ADO.NET 3.5 with C# 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.