linq 行转列

表结构如下：

 

[sql]  view plain   copy

 

1. id          NAME                 result   
2. ----------- -------------------- ------   
3. 1           jim                  胜   
4. 2           jim                  胜   
5. 3           jim                  负   
6. 4           Tom                  胜   
7. 5           Tom                  负   
8. 6           Sam                  负   
9. 7           Sam                  负  

 

想得到的结果是：

 

[sql]  view plain   copy

 

1. NAME                 胜           负   
2. -------------------- ----------- -----------   
3. jim                  2           1   
4. Sam                  0           2   
5. Tom                  1           1  

 

SQL可以这样来实现：

 

[sql]  view plain   copy

 

1. SELECT t1.name,  
2.    
3.   (SELECTCOUNT(1)FROM temp t2 WHERE t2.