Which of the following code in LINQ performs functionality similar to joins in SQL ?

Question

TuteeHUB · Accepted Answer

var categoryProducts = FROM c IN db.Categories JOIN p IN db.Products ON c.CategoryID equals p.CategoryID INTO productsforeach (var cp IN cate

TuteeHUB · Answer

var categoryProducts = FROM c IN db.Categories SELECT NEW {c.CategoryName, productCount = products.Count()}

TuteeHUB · Answer

var categoryProducts = FROM c IN db.Categories JOIN p IN db.Products ON c.CategoryID equals p.CategoryID INTO products SELECT NEW

TuteeHUB · Answer

None of the mentioned

1.	Which of the following code in LINQ performs functionality similar to joins in SQL ?
A.	var categoryProducts = FROM c IN db.Categories SELECT NEW {c.CategoryName, productCount = products.Count()}</
B.	var categoryProducts = FROM c IN db.Categories JOIN p IN db.Products ON c.CategoryID equals p.CategoryID INTO products SELECT NEW
C.	var categoryProducts = FROM c IN db.Categories JOIN p IN db.Products ON c.CategoryID equals p.CategoryID INTO productsforeach (var cp IN cate
D.	None of the mentioned
Answer» C. var categoryProducts = FROM c IN db.Categories JOIN p IN db.Products ON c.CategoryID equals p.CategoryID INTO productsforeach (var cp IN cate

Discussion