8,497
社区成员
发帖
与我相关
我的任务
分享
using (YDS6000Entities ent = new YDS6000Entities(AppModel.Connecting))
{
var resTest = from a in ent.vp_Pe_Building_Room
select new { a.Ledger,a.Room_id};
}
生成sql语句:
SELECT
`Extent1`.`Room_id`,
`Extent1`.`Ledger`
FROM (SELECT
`vp_Pe_Building_Room`.`Ledger`,
`vp_Pe_Building_Room`.`Bd_id`,
`vp_Pe_Building_Room`.`BdNo`,
`vp_Pe_Building_Room`.`BdName`,
`vp_Pe_Building_Room`.`BdYear`,
`vp_Pe_Building_Room`.`BdEncoding`,
`vp_Pe_Building_Room`.`BdArea`,
`vp_Pe_Building_Room`.`RatedPower`,
`vp_Pe_Building_Room`.`FloorCount`,
`vp_Pe_Building_Room`.`AirArea`,
`vp_Pe_Building_Room`.`Remark`,
`vp_Pe_Building_Room`.`BdExtInfoJson`,
`vp_Pe_Building_Room`.`Parent_id`,
`vp_Pe_Building_Room`.`Room_id`,
`vp_Pe_Building_Room`.`RoomNo`,
`vp_Pe_Building_Room`.`RoomName`,
`vp_Pe_Building_Room`.`RoomPhone`,
`vp_Pe_Building_Room`.`RoomFunction`,
`vp_Pe_Building_Room`.`RoomRmk`,
`vp_Pe_Building_Room`.`FullBdName`,
`vp_Pe_Building_Room`.`FullRoomName`
FROM `vp_Pe_Building_Room` AS `vp_Pe_Building_Room`) AS `Extent1`
using (YDS6000Entities ent = new YDS6000Entities(AppModel.Connecting))
{
var resTest = from a in ent.pe_Building_Room
select new { a.Ledger,a.Room_id };
}
生成正常的sql语句
SELECT
`Extent1`.`Room_id`,
`Extent1`.`Ledger`
FROM `pe_Building_Room` AS `Extent1`