c# - unable to create a constant value of type anonymous type only primitive types -

-

using entity framework version=6.0.0.0 get common id , orderid shown below.

var dt1 = p in dt.asenumerable()           select new           {               id = p.field<int>("id"),               orderid = p.field<int>("orderid")           };  var dt2 = (from order in db.orders            select new            {                order.id,                order.orderid            }).tolist(); var intersect = dt1.intersect(dt2);

based on list of values in intersect. need select values orders table.

trying used code getting error "unable create constant value of type anonymous type primitive types"

var result= (from in sync.orders               intersect.any(b => a.id == b.id && a.orderid == b.orderid)               select a).tolist();

you trying "join" ef query in-memory data set, not work because there's not way embed list , lookup in sql. 1 option pull entire table memory asenumerable:

var result= (from in sync.orders.asenumberable               intersect.any(b => a.id == b.id && a.orderid == b.orderid)               select a).tolist();

another option concatenate id , orderid 1 value , use contains since can translated in clause in sql:

var lookup = intersect.select(i => i.id + "-" + i.orderid).tolist();  var result= (from in sync.orders               lookup.contains(a.id + "-" + a.orderid)               select a).tolist();

Comments

Post a Comment

Popular posts from this blog

c# - Where does the .ToList() go in LINQ query result -

-
when getting data populate data grid, have pulled data, made list , mapped model, this: public list<person> getpeople() { var data = _db.person.tolist(); list<person> people = new list<person>(); foreach (var item in data) { person person = new person() { personid = item.personid, firstname = item.firstname, lastname = item.lastname }; people.add(person); } return people; } this works fine, in interest of writing less code discovered .select method , (what think is) anonymous type. have: public list<person> getpeople() { return _db.person.select(d => new person { personid = item.personid, firstname = item.firstname, lastname = item.lastname }).tolist(); } though not easy read, works fine too. there preference either way? ...
Read more

Listeners to visualise results of load test in JMeter -

-
i want run load test in non-gui mode , save results in .csv file. (i have not modified .properties files, standard information saved) i plan load file , visualise results jmeter’s listeners. which listeners suited purpose? should avoid @ cost, might cause me misinterpret information? (e.g. in view results tree response data empty have - - not saved this. however, there has in fact been response. if saw listener might think there hasn’t been one. since want avoid this, listeners have gain information needed .csv file.) i’d know both jmeter listeners plugins. if running test in non-ui mode ideally should disable listeners in script. use '-l' option store test results .jtl extension. can later open jtl file jmeter. aggregate report or summary report should summarize test results , response time , throughput. if want plot graphs see trends on test duration can use http://jmeter-plugins.org/#/ standard , lib set. i suggest following listeners: response ...
Read more

apple push notifications - Confusion about IOS certificates, APNS mainly -

-
i'm developing hybrid app using cordova, , i'm getting confused certificates issue (total newbie apple here). now, think manage creating .p12 file , build apps. don't understand how add apns certificate send/receive push notifications. have merge files in order have 1 .cer file includes production certificate , apns certificate? or how go? there protocol such popular build? i'll appreciate clear out confusion, i'm using windows i'm doing through openssl. help!
Read more