title: Distinguish EF query and LINQ query
body: <p>I am new to Entity Framework. I am bit confused with the difference in EF query and LINQ query. I have two tables and related queries listed below. Can you please tell me whether all these queries are LINQ or any of them are in EF? I need to write EF queries for selecting entire row, few columns and also joins. Your help or any relevant links would be highly appreciated.</p>
  
  <p>Product_Details table
  Product_ID, Product_Name, Price, Item_Desc, Stock_Avaialble, Created_Date</p>
  
  <p>Sales_Details Table
  Sales_ID, Product_ID, Qunatity, Total_Amont</p>
  
  <pre><code>var result = context.ProductDetails
                  where ProductID == 10
                  select new {ProductID, ProductName, Price}
  
  var result = from prod in context.ProductDetails
                      where ProductID == 10
                      select new {ProductID, ProductName, Price}
  
  var result = context.ProductDetails
                      .Where(p=&gt;p.ProductID == 10)
                      .Select(p=&gt; new Prod(p.ProductID, p.ProductName, p.Price))
  
  var result1 = from prod in context.ProductDetails
                      join sales in context.SalesDetails on prod.ProductID == sales.ProductID
                      select new {prod.ProductID, prod.ProductName, sales.Qunatity, sales.TotalAmount}
  </code></pre>
  
  <p>Thanks
  Peter</p>