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 n ew {
or der.OrderID ,
order.Description ,
or d.UnitPrice )
};

C.
from order in db.Order
join details in db.OrderDetails on
order.OrderID equals details.OrderID into grp
select n ew {
or der.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
};