62,041
社区成员
发帖
与我相关
我的任务
分享
public class UserBase
{
/// <summary>
/// Id
/// </summary>
[DataMember]
[Key]
[DatabaseGenerated(DatabaseGeneratedOption.Identity)]
public int Id { get; set; }
/// <summary>
/// UserName
/// </summary>
[DataMember]
public string UserName { get; set; }
/// <summary>
/// PassWord
/// </summary>
[DataMember]
public string PassWord { get; set; }
[DataMember]
[NotMapped]
public UserInfo UserInfo { get; set; }//对应子表
}
public class UserInfo
{
/// <summary>
/// UserId 和主表的主键对应
/// </summary>
[DataMember]
[Key]
[DatabaseGenerated(DatabaseGeneratedOption.None)]
public int UserId { get; set; }
/// <summary>
/// Name
/// </summary>
[DataMember]
public string Name { get; set; }
/// <summary>
/// Sex
/// </summary>
[DataMember]
public bool Sex { get; set; }
}
public List<UserBase> UserBase_List()
{
var context = new DataContext();
var query = from a in context.Set<UserBase>()
join b in context.Set<UserInfo>()
on a.Id equals b.UserId
select a;//这样只能获取到UserBase的信息,UserBase.UserInfo无法赋值
//select new UserBase{Id = a.Id, UserInfo = b} 如果这样写,会报错“The entity or complex type 'Model.UserBase' cannot be constructed in a LINQ to Entities query”
return query.ToList();
}
select new {Id = a.Id, UserInfo = b}