i'm new linq, want rewrite of mine sql querys linq (just learn) , i'v stuck @ beginning. solution simple i'v said i'm new , didn't find solution this.
i have 1 query :
string typmoneta = textbox1.text; var moneta = x in db.grupytowarowes x.typ == typmoneta select new { x.grupa };
which works ok , when set
datagridview1.datasource = moneta;
and want use output in second query :
var query = c in dbcontext.picking c.number == 1000 && c.group == moneta select new { c.id };
problem c.group == moneta
. don't know correct syntax. me?
the moneta
ienumerable<t>
t
in case type of grupa
being said should write query below:
var query = c in dbcontext.picking c.number == 1000 && moneta.contais(c.group) select new { c.id };
or in fluent syntax below:
var query = dbcontext.picking .where(pick => pick.number == 1000 && moneta.contains(pick.group)) .select(pick => pick.id);
Comments
Post a Comment