gs gs116 Data Connectivity - LINQ - Quiz No.2

Enumerable<Product> beverages = from p in db.Products where p.Category.CategoryName == "Beverages" orderby p.ProductName select p; 

IEnumerable<Product> beverages = from p in db.Products where p.Category.CategoryName = "Beverages" orderby p.ProductName select p; 

public User GetUser(string userName) { DBNameDataContext myDB = new DBNameDataContext(); User user = myDB.Users.One(u, u.UserName=>userName); return user; } ? 

public User GetUser(string userName) { DBNameDataContext myDB = new DBNameDataContext(); User user = myDB.Users.findOne(u, u.UserName=>userName); return user; } ? 

var categoryProducts = from c in db.Categories select new {c.CategoryName, productCount = products.Count()}; foreach (var cp in categoryProducts) { Console.WriteLine("There are {0} products in category {1}", cp.CategoryName, cp.productCount); } 

var categoryProducts = from c in db.Categories join p in db.Products on c.CategoryID equals p.CategoryID into products foreach (var cp in categoryProducts) { Console.WriteLine("There are {0} products in category {1}", cp.CategoryName, cp.productCount); }