score:1

Accepted answer

i think it will be easier using method based query:

var result = context.block.select(b => b.events.select(e => new
                                                {
                                                    e.eventid,
                                                    e.date,
                                                    e.deviceid,
                                                    e.blockid,
                                                    e.accelleration,
                                                    e.intensity
                                                }).tolist()).tolist();

score:1

you need to use a groupjoin

here is an example

var teamsandriders = teams.groupjoin(riders, team => team.name, rider => rider.teamname, (team, teamriders) => new {team = team.name, riders = teamriders.select(rider => rider.name)});


Related Query