如何在linq查询中显示所有结果

我有一个linq查询，从两个表中获取结果。但该查询并未显示所有结果。当我在SQL Server中测试它时，我有这个:

| mcod  | pcod  | c_ogrn        | fam_v | im_v    | ot_v   | idGk
| 41004 | 10023 | 1027800518063 | Johny | Johnson | Andrew |  3   
| 41004 | 10023 | 1027800518063 | Johny | Johnson | Andrew | 11  

您可以看到上一列的数据是不同的。但是当我在linq查询中测试时，我有这个结果:

| mcod  | pcod  | c_ogrn        | fam_v | im_v    | ot_v   | idGk
| 41004 | 10023 | 1027800518063 | Johny | Johnson | Andrew |   3   
| 41004 | 10023 | 1027800518063 | Johny | Johnson | Andrew |   3  

为什么查询是相同的，但结果不同?

我的c#代码:

 var fidn  = from post in repository.users
             join meta in repository.usersLG on post.pcod equals meta.pcod
             where post.fam_v.Trim() == "Johny" && post.actual == 1
             //where post.fa post.fam_v.Trim() == fambox.Text and post.actual=1
             select new Final
                          {
                              mcod = post.mcod,
                              pcod = post.pcod,
                              c_ogrn = post.c_ogrn,
                              fam_v = post.fam_v,
                              im_v = post.im_v,
                              ot_v = post.ot_v,
                              idGK = meta.idGK
                          };

My T-SQL查询:

SELECT  
    users.[mcod], users.pcod, [c_ogrn], [fam_v], [im_v], [ot_v], idGk
FROM  
    [table].[dbo].[users]
JOIN
    [table].[dbo].[usersLG] ON users.pcod = usersLG.pcod 
WHERE 
    users.fam_v = 'Johny'
    AND users.actual = 1 

Asp.net Web page, Entity Framework, c# linq, SQL Server

UPDATE my classes and primary key:

用户:

[Key]
public string pcod { get; set; }
public string mcod { get; set; } 
public string c_ogrn  { get; set; }
public string fam_v { get; set; } 
public string im_v { get; set; }
public string ot_v { get; set; }
public int actual { get; set; }

usersLG

[Key]
public string pcod { get; set; }
public int idGK { get; set; }
public string mcod { get; set; }
public byte actual { get; set; }

最后

[Key]
public int idGK { get; set; }
public string pcod { get; set; } 
public string mcod { get; set; }
public string c_ogrn { get; set; } 
public string fam_v { get; set; }
public string im_v { get; set; } 
public string ot_v { get; set; }
public int actual { get; set; }