Linq 中ExecuteQuery 的调用
代码:
PaymentDataContext payDateBase = new PaymentDataContext();
StringBuilder sql = new StringBuilder();
sql.Append("select top ");
sql.Append(pageSize);
sql.Append(" torder.[orderid] as [orderId],(select sg.[name] from [syn_games_informations] as sg where sg.[id]=torder.[gameid]) as [gameName],");
sql.Append("(select tph.[name] from [t_payment_channels] as tph where tph.[id]=torder.[channelid]) as [channeName],");
sql.Append("torder.[rmb] as [payMoney],torder.[status] as [statu],torder.[createon] ");
sql.Append(" from dbo.[t_payment_orders] as torder ");
sql.Append(" where torder.[payer]=");
sql.Append(currUserId);
if (currentPage > 1)
{
sql.Append(" and ");
sql.Append(" torder.[id]>(select Max(id) from (select top ");
sql.Append(pageSize * (currentPage - 1));
sql.Append(" t.[id] from [t_payment_orders] as t order by t.[id],t.[createon]) as b )");
}
sql.Append(" order by torder.[id],torder.[createon]");
return payDateBase.ExecuteQuery<OrderMsg>(sql.ToString()).ToList();
问题:
1:payDateBase.ExecuteQuery<OrderMsg>(sql.ToString()).ToList() 指定的转换无效
2:如果不转换 在 页面中绑定的时候也是指定的转换无效
(IEnumerable<OrderMsg> orderMsgList = new Passport.Tongcn.Net.Bll.PaymentChannelLogic().GetPageOrderMsgList(2, 1, 72);
GridView1.DataSource = orderMsgList;
GridView1.DataBind();)
该怎么解决。。。