Joining three entities using linq

[Gcobani54]

Hi Team

I need some help in joining three entities using linq, i have one join but the problem i have i am getting a repetion of years, weekNum and day colums with data being incorrect.

  public IList<ExtractionViewModel> GetExtractionViewModels(string year, int week)
        {

            ProductionManagementEntities db = new ProductionManagementEntities();

            
            var scheduleList = (from p in db.ProductionDays
                                join w in db.Weeks
                                // join m in db.Models somewhere here to prevent duplicate records
                                on p.WeekId equals w.WeekId

                                orderby w.Year ascending
                                orderby w.WeekNum ascending


                                where (w.WeekNum == 5)

                                select new ExtractionViewModel
                                {

                                    Day = p.ProductionDate,
                                    Week = w.WeekNum,

                                    // Model = m.Name,
                                    Year = w.Year

                                }).ToList();
            return scheduleList;
        }

 public class ExtractionViewModel
    {
        public string Year { get; set; }

        public int Week { get; set; }

        
        [DataType(DataType.Date)]
        public DateTime Day { get; set; }

       // public string VW240 { get; set; }

        public string VW250 { get; set; }

        public string VW270 { get; set; }

        public string VW2502PA { get; set; }

        public string VW270PA { get; set; }
    }

 

[Skydiver]

I see one entity. Where are the other two entities? How are you doing the JOIN?

I think this is related to your other thread. You are not looking for a JOIN operation. You are looking for a grouping operation.

 

[Gcobani54]

I see one entity. Where are the other two entities? How are you doing the JOIN?

I think this is related to your other thread. You are not looking for a JOIN operation. You are looking for a grouping operation.

This where i need help in with

 

[Gcobani54]

Hi Team

I have a method that calls three 3 tables, but now i am getting an error says ' variable does not exist in current context'. How do i fix this issue?

       public IList<ExtractionViewModel> GetExtractionViewModels(string year, int week)
        {

            ProductionManagementEntities db = new ProductionManagementEntities();


            var scheduleList = (from p in db.Weeks
                                from pr in db.ProductionDays on p.WeekId = p.WeekId // Error is here does not see this in current context

                                orderby w.Year ascending
                                orderby w.WeekNum ascending


                                where (w.WeekNum == 5)

                                select new ExtractionViewModel
                                {

                                    Day = p.ProductionDate,
                                    Week = w.WeekNum,

                                    // Model = m.Name,
                                    Year = w.Year

                                }).ToList();
            return scheduleList;
        }

 

[Skydiver]

Please stop opening new threads. Instead reply back on your previous thread. By replying back on your previous thread, we can see the evolution of your code and have half a chance at trying to discern which direction you are headed. (Only open a new thread if you are trying to solve something that is completely new.)

As an example, with this thread, it's not obvious why you are trying to do a join. It's only if users read your other thread about trying to build a "dynamic" table, will it become clear as to what you are trying to achieve.

Merging threads...

 

[Skydiver]

Out of curiosity, why are you insisting on using LINQ to perform your query? I can understand the performance gains you could get, but recall the correct order of writing code:

Make It Work. Make It Right. Make It Fast.​

https://wiki.c2.com/?MakeItWorkMakeItRightMakeItFast