c# - Error in Entity framework query (Missing cast) -
public list<projectimpacts> getprojectimpactsbyprojeactidandimpactname(string prefe , string impcname) { string xim = cecbcontext.impacts.first(i=>i.impt_name.contains(impcname)).impt_reference; iqueryable<projectimpacts> query = c in cecbcontext.projectimpacts join b in cecbcontext.impacts on c.impt_reference equals b.impt_reference c.proj_reference == prefe && c.impt_reference == xim select b.impt_name; list<projectimpacts> selectedimpacts = query.tolist(); //query.select(refe => new projectimpacts { impt_reference = }).tolist(); return selectedimpacts; }
i'm getting error in query:
cannot implicitly convert type 'system.linq.iqueryable' 'system.linq.iqueryable'. explicit conversion exists (are missing cast?)
this because query selects name @ end:
iqueryable<projectimpacts> query = c in cecbcontext.projectimpacts join b in cecbcontext.impacts on c.impt_reference equals b.impt_reference c.proj_reference == prefe && c.impt_reference == xim // select b.impt_name; // <<== replace this... select c; // <<== this.
the type parameter t
of generic iqueryable<t>
corresponds type of object selected in query. since select name
(which presumably string
), got iqueriable<string>
. once select c
, projectimpacts
, you'd iqueryable<projectimpacts>
result
Comments
Post a Comment