将带有子级的Entity Framework对象序列化为XML文件
|
我正在使用Entity Framework查询带有父/子结果集的数据，并且希望将此数据导出到XML文档。
var agreement = storeops.Agreements.SingleOrDefault(a => a.AgreementNumber == AgreementTextBox.Text);
XmlSerializer serializer = new XmlSerializer(agreement.GetType());
XmlWriter writer = XmlWriter.Create(\"Agreement.xml\");
serializer.Serialize(writer, agreement);
没有找到相关结果
已邀请:
2 个回复
凸晴
：var agreement = storeops.Agreements.SingleOrDefault(a => a.AgreementNumber == AgreementTextBox.Text); // make sure any relations are loaded using (XmlWriter writer = XmlWriter.Create(\"Agreement.xml\")) { DataContractSerializer serializer = new DataContractSerializer(agreement.GetType()); serializer.WriteObject(writer, agreement); }或在查询中使用显式加载相关实体（其中是相关实体集合的名称）。傻零凰死授
var agreement = storeops.Agreements.Include(\"AgreementItems\").SingleOrDefault(a => a.AgreementNumber == AgreementTextBox.Text); var typeList = new List<Type>(); if(agreement.AgreementItems.Count > 0) typeList.Add(agreement.AgreementItems.FirstOrDefault().GetType()); if (agreement.AgreementItemLogs.Count > 0) typeList.Add(agreement.AgreementItemLogs.FirstOrDefault().GetType()); if (agreement.AgreementPricings.Count > 0) typeList.Add(agreement.AgreementPricings.FirstOrDefault().GetType()); if (agreement.AgreementSnapshots.Count > 0) typeList.Add(agreement.AgreementSnapshots.FirstOrDefault().GetType()); if (agreement.AgreementTransactions.Count > 0) typeList.Add(agreement.AgreementTransactions.FirstOrDefault().GetType()); if (agreement.AgreementTransactionLogs.Count > 0) typeList.Add(agreement.AgreementTransactionLogs.FirstOrDefault().GetType()); XmlSerializer serializer = new XmlSerializer(agreement.GetType(), typeList.ToArray()); XmlWriter writer = XmlWriter.Create(\"Agreement.xml\"); serializer.Serialize(writer, agreement);