Code: Select all
var owner = (from view in ctx.WRD_METHOD_OWNERS_VW
where view.WRKEY == wrKey
select view).ToList();
Code: Select all
SELECT
"Extent1".BOCA_CD AS BOCA_CD,
"Extent1".BOCA_DESCR AS BOCA_DESCR,
"Extent1".ENF_PRTY_DT AS ENF_PRTY_DT,
"Extent1".FST_NM AS FST_NM,
"Extent1".LST_NM_OR_BUSN_NM AS LST_NM_OR_BUSN_NM,
"Extent1".MID_INT AS MID_INT,
"Extent1".SUFX AS SUFX,
"Extent1".WRKEY AS WRKEY
FROM (SELECT
WRD_METHOD_OWNERS_VW.BOCA_CD AS BOCA_CD,
WRD_METHOD_OWNERS_VW.BOCA_DESCR AS BOCA_DESCR,
WRD_METHOD_OWNERS_VW.ENF_PRTY_DT AS ENF_PRTY_DT,
WRD_METHOD_OWNERS_VW.FST_NM AS FST_NM,
WRD_METHOD_OWNERS_VW.LST_NM_OR_BUSN_NM AS LST_NM_OR_BUSN_NM,
WRD_METHOD_OWNERS_VW.MID_INT AS MID_INT,
WRD_METHOD_OWNERS_VW.SUFX AS SUFX,
WRD_METHOD_OWNERS_VW.WRKEY AS WRKEY
FROM WRD.WRD_METHOD_OWNERS_VW WRD_METHOD_OWNERS_VW) "Extent1"
WHERE "Extent1".WRKEY = :p__linq__3
Now, if I use the following linq statement:
Code: Select all
var list = (from view in ctx.WRD_METHOD_OWNERS_VW
where view.LST_NM_OR_BUSN_NM == last && view.BOCA_CD == basinCode
select new { view.WRKEY, view.LST_NM_OR_BUSN_NM, view.FST_NM }).ToList();
Why doesn't a "select *" work correctly?