Load data from related entities using Entity Framework

Question

I have two tables product and Images. They have a one-to-many relationship. I want to display product name and all its related images in the view, I am using repository pattern. I am new to MVC and Linq please help. Thanks in advance.

Here is my code....

public partial class tbl_Product
{
        public int pro_id { get; set; }
        public string pro_name { get; set; }
        public string pro_desc { get; set; }
        public string pro_model { get; set; }
        public string pro_dimensions { get; set; }
        public Nullable<int> pro_UnitsInStock { get; set; }
        public Nullable<double> pro_price { get; set; }
        public Nullable<double> pro_oldprice { get; set; }
  
        public virtual ICollection<tbl_Images> tbl_Images { get; set; }
}

ProductRepository class:

public ProductDetail GetProductByID(int id)
{
    var product = this.storeDB.tbl_Product.Where(x => x.pro_id == id).FirstOrDefault();   
                                      
    return product;
}

marc_s · Accepted Answer · 2021-07-25 16:43:52Z

1

Just add an Include clause to load the related images:

public ProductDetail GetProductByID(int id)
{
    var product = storeDB.tbl_Product
                         .Where(x => x.pro_id == id)
                         .Include(p => p.tbl_Images)
                         .FirstOrDefault();   
                                      
    return product;
}

answered Jul 25, 2021 at 16:43

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Hani Over a year ago

thanks a lot, now i am stuck at posting these values to the contoller method. Because var product cannot return ProductDetail.....please help

marc_s Over a year ago

That's a whole new question - and if you do ask - please also post all relevant details (like definition of your ProductDetail class) so we stand a chance to actually help - thanks!

Hani Over a year ago

I have posted a new question regarding this issue. thanks

Collectives™ on Stack Overflow

Load data from related entities using Entity Framework

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related