实体框架加入(Entity Framework Join)

 我尝试加入实体框架，但我需要在加入我的常规方法后列出我的信息，如下所示： 
 
public DataTable LoadAllAllowing()
{
    var resultList = new DataTable();
    SqlConnection connection = new SqlConnection(@"server=. ; database=PersonnelTrackingSystem;Trusted_Connection=yes");
    connection.Open();
    SqlDataAdapter da = new SqlDataAdapter(@"SELECT PA.personelId
                                                 ,[allowedDatesId]
                                                ,[allowedStartDate]
                                                 ,[allowedEndDate]
                                                 ,[allowReason]
                                                ,PI.personnelNumber
                                                ,PI.personnelName
                                                ,PI.personnelSurname
                                                FROM [PersonnelTrackingSystem].[dbo].[personnelAllowedDates] AS PA
                                                JOIN PersonnelInformation AS PI ON PI.personelId=PA.personelId", connection);
    da.Fill(resultList);
    return resultList;
}
 
 我如何用实体框架做到这一点？ 我确实喜欢这个，但它不起作用 
 
  public List<PersonnelInfoAndAllow> LoadAllAllowing()
    {
        PersonnelTrackingSystemEntities entity = new PersonnelTrackingSystemEntities();
        //var personnel = entity.personnelAllowedDates.ToList();
        var allows = (from allow in entity.personnelAllowedDates join personnel in entity.PersonnelInformation on allow.personelId equals personnel.personelId select new { personelId = personnel.personelId, personnelNumber = personnel.personnelNumber, personnelName = personnel.personnelName, personnelSurname = personnel.personnelSurname, allowedDatesId = allow.allowedDatesId, allowedStartDate = allow.allowedStartDate, allowedEndDate = allow.allowedEndDate, allowReason = allow.allowReason }).ToList();
        List<PersonnelInfoAndAllow> personnels = allows;
        return personnels;}
 
 我写这样的课： 
 
 namespace personnelTrackingSystem { class PersonnelInfoAndAllow { public int personelId { get; set; } public System.DateTime allowedStartDate { get; set; } public System.DateTime allowedEndDate { get; set; } public string allowReason { get; set; } public int allowedDatesId { get; set; } public string personnelNumber { get; set; } public string personnelName { get; set; } public string personnelSurname { get; set; } } } 但它不起作用。 我怎么解决这个问题？ 

I try to do join with entity framework but I need to List my information after join my normal method like this:
 
public DataTable LoadAllAllowing()
{
    var resultList = new DataTable();
    SqlConnection connection = new SqlConnection(@"server=. ; database=PersonnelTrackingSystem;Trusted_Connection=yes");
    connection.Open();
    SqlDataAdapter da = new SqlDataAdapter(@"SELECT PA.personelId
                                                 ,[allowedDatesId]
                                                ,[allowedStartDate]
                                                 ,[allowedEndDate]
                                                 ,[allowReason]
                                                ,PI.personnelNumber
                                                ,PI.personnelName
                                                ,PI.personnelSurname
                                                FROM [PersonnelTrackingSystem].[dbo].[personnelAllowedDates] AS PA
                                                JOIN PersonnelInformation AS PI ON PI.personelId=PA.personelId", connection);
    da.Fill(resultList);
    return resultList;
}
 
How I can do this with entity framework? I did like this but it doesn't work
 
  public List<PersonnelInfoAndAllow> LoadAllAllowing()
    {
        PersonnelTrackingSystemEntities entity = new PersonnelTrackingSystemEntities();
        //var personnel = entity.personnelAllowedDates.ToList();
        var allows = (from allow in entity.personnelAllowedDates join personnel in entity.PersonnelInformation on allow.personelId equals personnel.personelId select new { personelId = personnel.personelId, personnelNumber = personnel.personnelNumber, personnelName = personnel.personnelName, personnelSurname = personnel.personnelSurname, allowedDatesId = allow.allowedDatesId, allowedStartDate = allow.allowedStartDate, allowedEndDate = allow.allowedEndDate, allowReason = allow.allowReason }).ToList();
        List<PersonnelInfoAndAllow> personnels = allows;
        return personnels;}
 
I write class like that :
 
namespace personnelTrackingSystem { class PersonnelInfoAndAllow { public int personelId { get; set; } public System.DateTime allowedStartDate { get; set; } public System.DateTime allowedEndDate { get; set; } public string allowReason { get; set; } public int allowedDatesId { get; set; } public string personnelNumber { get; set; } public string personnelName { get; set; } public string personnelSurname { get; set; } } } But it doesn't work. How I fix this ? 

原文：https://stackoverflow.com/questions/32907194