70-564 Free Dumps Study Materials
Question 14: You are creating an ASP.NET application by using the .NET Framework 3.5.
You use LINQ to SQL to query a Microsoft SQL Server 2008 database. You need to create a LINQ query
to retrieve information on order and order details.
You need to ensure that the LINQ query executes the following SQL statement:
SELECT Order.OrderID,Order.Description,OrderDetails.UnitPrice
FROM Order JOIN OrderDetails
ON Order.OrderID = OrderDetails.OrderID
Which LINQ query should you use?
A. from order in db.Orders
join details in db.OrderDetails on
order.OrderID equals details.OrderID
select new {
order.OrderID,
order.Description,
details.UnitPrice
};
B. from order in db.Order
join details in db.OrderDetails on
order.OrderID equals details.OrderID into grp
from ord in grp.DefaultIfEmpty()
select new {
order.OrderID,
order.Description,
ord.UnitPrice)
};
C. from order in db.Order
join details in db.OrderDetails on
order.OrderID equals details.OrderID into grp
select new {
order.OrderID,
order.Description,
grp.First().UnitPrice
};
D. from order in db.Orders
join details in db.OrderDetails on
order.OrderID equals details.OrderID into grp
let price = grp.DefaultIfEmpty().First()
select new {
order.OrderID,
order.Description,
price.UnitPrice
};
Correct Answer: A