LINQ的select new怎样使用别名？

[hcaihao]

gvOperateLog.DataSource = from o in BasePage.CoreEntity.OperateLogs
from a in BasePage.CoreEntity.Admins
from u in BasePage.CoreEntity.Users
from l in BasePage.CoreEntity.Licenses
from s in BasePage.CoreEntity.SerialNumbers
from t in BasePage.CoreEntity.Types
where a.ID == o.AdminID && u.ID == l.UserID && l.SerialNumberID == s.ID && t.ID == s.TypeID
select new
{
o.ID,
a.UserName,
u.UserName,
t.Title,
o.Operate,
o.CreateDate
};

gvOperateLog.DataBind();

a和u表都有个UserName列，LINQ会提示“An anonymous type cannot have multiple properties with the same name”

如何使用别名，把a.UserName变成AdminName

[wxg22526451]

AdminName=a.UserName

[wxg22526451]

            gvOperateLog.DataSource = from o in BasePage.CoreEntity.OperateLogs 
                                      from a in BasePage.CoreEntity.Admins 
                                      from u in BasePage.CoreEntity.Users 
                                      from l in BasePage.CoreEntity.Licenses 
                                      from s in BasePage.CoreEntity.SerialNumbers 
                                      from t in BasePage.CoreEntity.Types 
                                      where a.ID == o.AdminID && u.ID == l.UserID && l.SerialNumberID == s.ID && t.ID == s.TypeID 
                                      select new 
                                      { 
                                          o.ID, 
                                          AdminName=a.UserName, 
                                          u.UserName, 
                                          t.Title, 
                                          o.Operate, 
                                          o.CreateDate 
                                      }; 

[wangan2008]

学习

[jzywh]

select new
{
ID = o.ID,
UserName = a.UserName,
TrueName = u.UserName,
Title = t.Title,
Operate = o.Operate,
CreateDate =o.CreateDate
};

[幸运的意外]

gvOperateLog.DataSource = from o in BasePage.CoreEntity.OperateLogs
from a in BasePage.CoreEntity.Admins
from u in BasePage.CoreEntity.Users
from l in BasePage.CoreEntity.Licenses
from s in BasePage.CoreEntity.SerialNumbers
from t in BasePage.CoreEntity.Types
where a.ID == o.AdminID && u.ID == l.UserID && l.SerialNumberID == s.ID && t.ID == s.TypeID
select new
{
o.ID,
UserNameA = a.UserName,
UserNameU = u.UserName, t.Title,
o.Operate,
o.CreateDate
};

gvOperateLog.DataBind();
用红色部分替代就可以了。select生成匿名类型时是支持开发者指定属性名的，这样就可以区分了。

[silence0716]

楼上 正解

[liu326166879]

select new
{
ID = o.ID,
UName = a.UserName,
TName = u.UserName,
TTitle = t.Title,
operate = o.Operate,
CDate =o.CreateDate
}; 这里别名可以任意取甚至还可以是中文！

[E_wait]

楼上正解

[ashou706]

学习

[qqshenyunzcz]

select new
{
o.ID,
AdminName=a.UserName,
u.UserName,
t.Title,
o.Operate,
o.CreateDate
};

[yezie]

都回答了。。。。。。。。。

[Xuon]

学习了

[shinlgienls]

第一次 看新版csdn 呵呵 不错

[昕颖]

6楼正解

[Adechen]

已经說了，
和sql里的类似

[psy0324]

select new
{
o.ID,
AdminName=a.UserName,
UserName=u.UserName,
t.Title,
o.Operate,
o.CreateDate
};

只需要把需要命的别名写在前面就好了1

[百思软件工作室]

学习了

[hechenqingtian]

WCF,LINQ,Entity,MVC，Jquery,Ext,java 等技术爱好者 请加入群 88718955

如此群希望大家不要闲聊，不谈政治，不能瞧不起他人技术。

希望大叫相互交流，维护好良好的学习气氛

[古龙老子]

[Quote=引用 8 楼 liu326166879 的回复:]
select new
{
ID = o.ID,
UName = a.UserName,
TName = u.UserName,
TTitle = t.Title,
operate = o.Operate,
CDate =o.CreateDate
}; 这里别名可以任意取甚至还可以是中文！
来晚了

[醉爱]

AdminName接收你要取的值就可以了