How to create dynamic LINQ sample with several samples at
**The problem occurred when a sample grouping of data, you need to create a model
number of custom properties**


    var query = dc.UsersData
                            .GroupJoin(dc.TechMapValues, u => u.UserId, t => t.UserId, (u, t) => new
                        {
                            u.Id,
                            u.UserId,
                            u.FirstName,
                            Tech10 = t.Where(z => z.TechMapId == 10).Select(z => z.Level).FirstOrDefault(),
                            Tech11 = t.Where(z => z.TechMapId == 11).Select(z => z.Level).FirstOrDefault()
                        });

**I tried to use the dynamic model and System.Linq.Dynamic but nothing came of it, can someone solved this problem, please help!**


How to create dynamic LINQ sample with several samples at
===

**The problem occurred when a sample grouping of data, you need to create a model
number of custom properties**


    var query = dc.UsersData
                            .GroupJoin(dc.TechMapValues, u => u.UserId, t => t.UserId, (u, t) => new
                        {
                            u.Id,
                            u.UserId,
                            u.FirstName,
                            Tech10 = t.Where(z => z.TechMapId == 10).Select(z => z.Level).FirstOrDefault(),
                            Tech11 = t.Where(z => z.TechMapId == 11).Select(z => z.Level).FirstOrDefault()
                        });

**I tried to use the dynamic model and System.Linq.Dynamic but nothing came of it, can someone solved this problem, please help!**

