Linq to SQL

Amit Joshi

I am using entity framework and Linq to fetch the data.

I have to tables Product and Order Detail. In Order detail table I have order Id and Product Id. While displaying data in gridview I am fetching data from order detail table. But I don't want to show Product Id in the grid. Instead of that I want to show related product name from product table.

I have EDMX file which has created two classes Product and Order detail. I am using LINQ to fetch data from Order details table. How can I get Product Name of related product ID. Method return type can not be Order detail. It gives me below error.

Cannot implicitly convert type 'System.Linq.IQueryable' to 'System.Collections.Generic.List

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amit Joshi11y ago
I found the solution we need to use Include("Order") in Linq query.
+1
Amit Joshi11y ago
Not MVC I am using it in regular web forms.

OrderDetail entity is created by EF. I need to take the records from that table and bind it to gridview. Instead of showing Product Id I need to show Product name.
0
Saineshwar Bageri11y ago
in Mvc you are using it or other application
0
Amit Joshi11y ago
I want generic return type. If method signature is as follows.

public List GetOrderDetail()

OrderDetail class is created by EF where I have Order Id and Product Id.
I don't have Product Name in this class.
0
Amit Joshi11y ago
But my method return type is Order class and Order class has order Id and Product Id.
0
Saineshwar Bageri11y ago
   Checkout this example will help you amit sir

OrderDBEntities objord = new OrderDBEntities();

    var states = (from slist in objord.OrderDetail
                      join Prd in objord.Product on slist.ProductID equals Prd.ProductID
                      select new { Prd.productname }).ToList();
0