我有一些模型设置如下:
public class Form
{
public int FormId { get; set; }
public virtual ICollection<SubForm> SubForms{ get; set; }
}
public class SubForm
{
public int SubFormId { get; set; }
public virtual Form Form {get; set;}
}我有一个这样的列表:
List<SubForm> subForms; <-- already populated, each subform has a form parent.如何以这样的格式获得最优格式(首选lambda)
List<Form> formsWithChildren;发布于 2011-11-23 04:26:21
您可以按FormId进行分组,然后将分组的子窗体分配给每个新的Form项,如下所示:
var formsWithChildren = subForms.GroupBy(s => s.Form.FormId)
.Select(g => new Form
{
FormId = g.Key,
SubForms = g.ToList()
}).ToList();编辑:如果存在其他属性,则必须在对象初始化器中映射它们,但这可能会变得单调乏味,如果您打算在其他场景中重用这种类型的查询,则不是最佳选择。我建议创建一个新的Form对象并使用AutoMapper对其进行映射。
如果您决定使用AutoMapper,则该方法将类似于:
var formsWithChildren = new List<Form>();
foreach (var item in subForms.GroupBy(s => s.Form))
{
Form f = Mapper.Map<Form, Form>(item.Key);
f.SubForms = item.Select(s => s).ToList();
formsWithChildren.Add(f);
}要了解更多信息,请参阅AutoMapper site。
或者,您可以采用如下方法,尽管这会修改现有项,因此请注意这一点。
var formsWithChildren = new List<Form>();
foreach (var item in subForms.GroupBy(s => s.Form))
{
// re-use existing Form from grouping so it retains its assigned values
Form f = item.Key;
f.SubForms = item.Select(s => s).ToList();
formsWithChildren.Add(f);
}在上面显示的两种方法中,您都需要在Form类上实现Equals,以便GroupBy Form而不是FormId
public class Form
{
public int FormId { get; set; }
public virtual ICollection<SubForm> SubForms{ get; set; }
public override bool Equals(object obj)
{
if (obj == null)
return false;
Form f = obj as Form;
return this.Equals(f);
}
public bool Equals(Form f)
{
if (f == null)
return false;
return this.FormId == f.FormId;
}
public override int GetHashCode()
{
return this.FormId.GetHashCode();
}
}您可以扩展equality和GetHashCode方法以使用这些属性来确定唯一性。目前它只依赖于FormId。
发布于 2011-11-23 04:19:08
formsWithChildren = subForms.Select(x => x.Form).Distinct().ToList();你是这个意思吗?
发布于 2011-11-23 04:21:29
方法,而不创建新的表单对象:
//Populate subForms list of the forms
subForms.GroupBy(x => x.Form).ForEach(x => x.Key.SubForms = x.ToList());
//Select forms
var forms = subForms.Select(x => x.Form).Distinct().ToList();https://stackoverflow.com/questions/8233218
复制相似问题