Join multiple Tables using Entity Framework in Linq query using C# in ASP.Net

Hi mukesh1,

Check this example. Now please take its reference and correct your code.

Database

For this sample I have used of NorthWind database that you can download using the link given below.

Download Northwind Database

HTML

<asp:GridView runat="server" ID="gvProducts" AutoGenerateColumns="false">
    <Columns>
        <asp:BoundField DataField="ProductID" HeaderText="Product ID" />
        <asp:BoundField DataField="ProductName" HeaderText="Product Name" />
        <asp:BoundField DataField="UnitPrice" HeaderText="Price" DataFormatString="{0:N2}" />
        <asp:BoundField DataField="CategoryName" HeaderText="Category Name" />
        <asp:BoundField DataField="Description" HeaderText="Description" />
    </Columns>
</asp:GridView>

C#

protected void Page_Load(object sender, EventArgs e)
{
    if (!this.IsPostBack)
    {
        NorthwindModel.NorthwindEntities entities = new NorthwindModel.NorthwindEntities();
        var details = (from p in entities.Products
                        join c in entities.Categories
                        on p.CategoryID equals c.CategoryID
                        orderby p.ProductID
                        select new
                        {
                            ProductID = p.ProductID,
                            ProductName = p.ProductName,
                            UnitPrice = p.UnitPrice,
                            CategoryName = c.CategoryName,
                            Description = c.Description
                        }).Take(10).ToList();
        gvProducts.DataSource = details;
        gvProducts.DataBind();
    }
}

Screenshot