You are developing an ASP.NET MVC application. The application is an order processing
system that uses the ADO.NET Entity Framework against a SQL Server database. It has a
controller that loads a page that displays all orders along with customer information. Lazy
loading has been disabled. The Order class is shown below.
You need to return the orders and customer information in a single round trip to the
database. Which code segment should you use?
A.
B.
C.
D.
For some reason, I don’t see an answer to this problem. I looked it up on another site and the answer is ‘c’.
http://www.microsoft4shared.com/new-updated-microsoft-mcsd-70-487-real-exam-questions-and-answers-download-21-30.html
impossible men sorry. ya que este maneja un metodo de entidad de relacion que permite llamar al servidor de mi base de datos trayendo la informacion de la entidad especificada y cargandola dentro de mi clase a su propiedad de navegacion. obteniendo la informacion de mi Order mas la informacion del cliente
Answer is A. The requirement is “You need to return the orders and customer information in a single round trip to the database.” That means you want to rise just 1 SQL query (JOIN).
C – wrong, because of explicit loading (multiple queries)
B – wrong, because of bad include path
D – wrong, because the lazy loading is disabled and related entity is not loaded
Here’s a great article that explains lazy loading, eager loading, and explicit loading in the Entity Framework.
https://msdn.microsoft.com/en-us/data/jj574232.aspx
Eager loading is the process whereby a query for one type of entity also loads related entities as part of the query. Eager loading is achieved by use of the Include method.
http://www.entityframeworktutorial.net/EntityFramework4.3/explicit-loading-with-dbcontext.aspx
https://msdn.microsoft.com/en-us/library/jj574232(v=vs.113).aspx