Hi,
Maybe you can try such as:
var data = (from user in _TestEntities.Users
select new JoinTable
{
ID = user.ID,
UserName = user.UserName,
Letter = new Letter()
{
Text = user.Letters.FirstOrDefault().Text
}
});
foreach(var row in data
{
}
This is referred to as Linq projection, see link
Query Expression Syntax Examples: Projection (LINQ to DataSet)[
^]