8,497
社区成员
发帖
与我相关
我的任务
分享
[Table("Users")]
public class Users
{
public Users()
{
this.UserSources = new HashSet<UserScore>();
}
[Key,DatabaseGenerated(DatabaseGeneratedOption.Identity)]
public int UserId { get; set; }
public string Name { get; set; }
public string Email { get; set; }
public virtual ICollection<UserScore> UserSources { get; set; }
}
[Table("UserScore")]
public class UserScore
{
public int Id { get; set; }
public int UserId { get; set; }
public int Score { get; set; }
}
foreach (var user in context.User.ToList())
{
foreach (var item in user.UserSources)
{
Console.WriteLine(item.Score);
}
}
var query = (from u in context.User
join s in context.UserScore on u.UserId equals s.UserId
select new
{
UserId = u.UserId,
Score = s.Score
}
).ToList();
foreach (var user in query)
{
Console.WriteLine(user.Score);
}