You are developing an ASP.NET web application.
The application includes the following Entity Data Model (EDM):

You instantiate an ObjectContextfor the EDM named context.
You need to find the total number of addresses thatare associated with customers that have a non-nullmiddle
name.
Which LINQ to Entities query should you use?

A.
var query = context.Customers
.Where(c => c.MiddleName != null)
.Select(c => c.CustomerAddresses.Count();

B.
var query = context.Customers
.Where(c => c.MiddleName != null)
.SelectMany(c => c.CustomerAddresses.Count();

C.
var query = context.Addresses
.SelectMany(a => a.CustomerAddresses.OfType<Customer>()
.Where(c => c.MiddleName != null)).Count();

D.
var query = context.Addresses
.GroupBy(a => a.CustomerAddresses
.Where(ca => ca.Customer.MiddleName != null)).Count();