我有2个数据库表。
在Calculate
表中,我有1行,通过Id
与CalculdateData
表中的多行映射。
现在我需要从Calculate
表中加载数据,并将所有相关详细信息从CalculdateData
表中获取。
如何将详细信息放入Tuple-List
中?
因此,对于每行CalculateData
,我有4列需要放入元组中。也就是说,如果我有4行,我需要在列表中创建4个元组。
IEnumerable<Storage> context = new MyEntities();
var Result = (from a in context.calculate
join b in context.CalculateData on a.Id equals b.CalcId into c
where a.SpecialID == 2023 && a.VersionId == 1
orderby a.InternalOrderNr ascending
select new Storage
{
myField1 = a.Field1;
myField2 = a.Field2;
myField3 = a.Field3;
< MISSING PART AND QUESTION >
}).ToList();
return Result;
public class Storage
{
public int myField1;
public int myField2;
public int myField3;
public List<Tuple<int, int, string, decimal>> myField4;
}