c# - Fetching items where nested collection contains item(s) form another collection -


i'm trying fetch item it's nested collection contains item or multiple items collection. if first enumerate collection , execute in-memory .where() filter, expected collection.

var filtertagids = new[] { 1, 2, 3 };  var works = base.dbset     .include(p => p.company)         .theninclude(p => p.companytags)     .tolist()     .where(p => p.company.companytags.any(q => filtertagids.contains(q.tagid)))     .tolist();

however if try without enumeration (i on db level), exception.

var doesnotwork = base.dbset     .include(p => p.company)         .theninclude(p => p.companytag)     .where(p => p.company.companytags.any(q => filtertagids.contains(q.tagid)))     .tolist();

this exception i'm getting:

{"variable 't0' of type 'microsoft.data.entity.query.entityquerymodelvisitor+transparentidentifier`2[microsoft.data.entity.storage.valuebuffer,microsoft.data.entity.storage.valuebuffer]' referenced scope '', not defined"}     data: {system.collections.listdictionaryinternal}     hresult: -2146233079     helplink: null     innerexception: null     message: "variable 't0' of type 'microsoft.data.entity.query.entityquerymodelvisitor+transparentidentifier`2[microsoft.data.entity.storage.valuebuffer,microsoft.data.entity.storage.valuebuffer]' referenced scope '', not defined"     source: "system.core"     stacktrace: "   @ system.linq.expressions.compiler.variablebinder.reference(parameterexpression node, variablestoragekind storage)\r\n   @ system.linq.expressions.compiler.variablebinder.visitparameter(parameterexpression node)\r\n   @ system.linq.expressions.parameterexpression.accept(expressionvisitor visitor)\r\n   @ system.linq.expressions.expressionvisitor.visit(expression node)\r\n   @ system.linq.expressions.expressionvisitor.visitmember(memberexpression node)\r\n   @ system.linq.expressions.memberexpression.accept(expressionvisitor visitor)\r\n   @ system.linq.expressions.expressionvisitor.visit(expression node)\r\n   @ system.linq.expressions.expressionvisitor.visitmethodcall(methodcallexpression node)\r\n   @ system.linq.expressions.methodcallexpression.accept(expressionvisitor visitor)\r\n   @ system.linq.expressions.expressionvisitor.visit(expression node)\r\n   @ system.linq.expressions.compiler.variablebinder.visitunary(unaryexpression node)\r\n   @ system.linq.expressions.unaryex pression.accept(expressionvisitor visitor)\r\n   @ system.linq.expressions.expressionvisitor.visit(expression node)\r\n   @ system.linq.expressions.expressionvisitor.visit(readonlycollection`1 nodes)\r\n   @ system.linq.expressions.compiler.variablebinder.visitlambda[t](expression`1 node)\r\n   @ system.linq.expressions.expression`1.accept(expressionvisitor visitor)\r\n   @ system.linq.expressions.expressionvisitor.visit(expression node)\r\n   @ system.linq.expressions.expressionvisitor.visitarguments(iargumentprovider nodes)\r\n   @ system.linq.expressions.expressionvisitor.visitmethodcall(methodcallexpression node)\r\n   @ system.linq.expressions.methodcallexpression.accept(expressionvisitor visitor)\r\n   @ system.linq.expressions.expressionvisitor.visit(expression node)\r\n   @ system.linq.expressions.expressionvisitor.visitarguments(iargumentprovider nodes)\r\n   @ system.linq.expressions.expressionvisitor.visitmethodcall(methodcallexpression node)\r\n   @ system.linq.expressions.methodcallexp ression.accept(expressionvisitor visitor)\r\n   @ system.linq.expressions.expressionvisitor.visit(expression node)\r\n   @ system.linq.expressions.expressionvisitor.visitarguments(iargumentprovider nodes)\r\n   @ system.linq.expressions.expressionvisitor.visitmethodcall(methodcallexpression node)\r\n   @ system.linq.expressions.methodcallexpression.accept(expressionvisitor visitor)\r\n   @ system.linq.expressions.expressionvisitor.visit(expression node)\r\n   @ system.linq.expressions.expressionvisitor.visitarguments(iargumentprovider nodes)\r\n   @ system.linq.expressions.expressionvisitor.visitmethodcall(methodcallexpression node)\r\n   @ system.linq.expressions.methodcallexpression.accept(expressionvisitor visitor)\r\n   @ system.linq.expressions.expressionvisitor.visit(expression node)\r\n   @ system.linq.expressions.expressionvisitor.visit(readonlycollection`1 nodes)\r\n   @ system.linq.expressions.compiler.variablebinder.visitlambda[t](expression`1 node)\r\n   @ system.linq.expressions.expres sion`1.accept(expressionvisitor visitor)\r\n   @ system.linq.expressions.expressionvisitor.visit(expression node)\r\n   @ system.linq.expressions.expressionvisitor.visitarguments(iargumentprovider nodes)\r\n   @ system.linq.expressions.expressionvisitor.visitmethodcall(methodcallexpression node)\r\n   @ system.linq.expressions.methodcallexpression.accept(expressionvisitor visitor)\r\n   @ system.linq.expressions.expressionvisitor.visit(expression node)\r\n   @ system.linq.expressions.expressionvisitor.visitarguments(iargumentprovider nodes)\r\n   @ system.linq.expressions.expressionvisitor.visitmethodcall(methodcallexpression node)\r\n   @ system.linq.expressions.methodcallexpression.accept(expressionvisitor visitor)\r\n   @ system.linq.expressions.expressionvisitor.visit(expression node)\r\n   @ system.linq.expressions.expressionvisitor.visitarguments(iargumentprovider nodes)\r\n   @ system.linq.expressions.expressionvisitor.visitmethodcall(methodcallexpression node)\r\n   @ system.linq.expression s.methodcallexpression.accept(expressionvisitor visitor)\r\n   @ system.linq.expressions.expressionvisitor.visit(expression node)\r\n   @ system.linq.expressions.expressionvisitor.visit(readonlycollection`1 nodes)\r\n   @ system.linq.expressions.compiler.variablebinder.visitlambda[t](expression`1 node)\r\n   @ system.linq.expressions.expression`1.accept(expressionvisitor visitor)\r\n   @ system.linq.expressions.expressionvisitor.visit(expression node)\r\n   @ system.linq.expressions.compiler.variablebinder.bind(lambdaexpression lambda)\r\n   @ system.linq.expressions.compiler.lambdacompiler.compile(lambdaexpression lambda, debuginfogenerator debuginfogenerator)\r\n   @ system.linq.expressions.expression`1.compile()\r\n   @ microsoft.data.entity.query.entityquerymodelvisitor.createexecutorlambda[tresults]()\r\n   @ microsoft.data.entity.query.entityquerymodelvisitor.createqueryexecutor[tresult](querymodel querymodel)\r\n   @ microsoft.data.entity.storage.database.compilequery[tresult](querymodel quer ymodel)\r\n--- end of stack trace previous location exception thrown ---\r\n   @ system.runtime.exceptionservices.exceptiondispatchinfo.throw()\r\n   @ microsoft.data.entity.query.internal.querycompiler.<>c__displayclass18_0`1.<compilequery>b__0()\r\n   @ microsoft.data.entity.query.internal.compiledquerycache.getoraddquery[tresult](object cachekey, func`1 compiler)\r\n   @ microsoft.data.entity.query.internal.querycompiler.compilequery[tresult](expression query)\r\n   @ microsoft.data.entity.query.internal.querycompiler.execute[tresult](expression query)\r\n   @ microsoft.data.entity.query.internal.entityqueryprovider.execute[tresult](expression expression)\r\n   @ remotion.linq.queryablebase`1.getenumerator()\r\n   @ system.collections.generic.list`1..ctor(ienumerable`1 collection)\r\n   @ system.linq.enumerable.tolist[tsource](ienumerable`1 source)\r\n   @ myproject.dal.repository.locationrepository.getcompanylocations(companymarkersfilter filter) in d:\\projects\\myproject\\src\\komp anio.dal\\repository\\locationrepository.cs:line 24"     targetsite: {void reference(system.linq.expressions.parameterexpression, system.linq.expressions.compiler.variablestoragekind)}

is i'm looking doable in ef? perhaps it's issue ef-core? or doing wrong? thanks.

https://github.com/aspnet/entityframework/issues/4596

known issue, set fixed release version of ef.


Comments

Post a Comment

Popular posts from this blog

routing - AngularJS State management ->load multiple states in one page -

Image
i developing site in angularjs ui-router. have situation on button click need change , load 3 state page , 3 looks image .please me how can load multiple pages. in 1 page you need configure router config this: $stateprovider .state("state1", { url: "/url1", controller: "firstcontroller", views: { view1: { templateurl: "templates/template1.html" }, view2: { templateurl: "templates/template2.html" }, view3: { templateurl: "templates/template3.html" } } }).state("state2", { url: "/url2", controller: "secondcontroller", views: { view1: { templateurl: "templates/template4.html" }, view2: { templateurl: "templates/template5.html" }, view3: { templateurl: "templates/template6.html" } }).state("state3", { ...
Read more

python - GRASS parser() error -

i'm trying use grass on python 2.7, i'm having problems @ setting script on idle, i'm getting error @ parser() function: here script: import os import sys gisbase = os.environ['gisbase'] = 'c:\program files (x86)\grass gis 7.0.1rc1' gisrc = 'c:\grassdata' gisdbase = 'c:\grassdata' location = 'newlocation' mapset = 'tc' ld_library_path = 'c:\program files (x86)\grass gis 7.0.1rc1\lib' path = 'c:\program files (x86)\grass gis 7.0.1rc1\etc';'c:\program files (x86)\grass gis 7.0.1rc1\etc\python';'c:\program files (x86)\grass gis 7.0.1rc1\lib';'c:\program files (x86)\grass gis 7.0.1rc1\bin';'c:\python27';'c:\program files (x86)\grass gis 7.0.1rc1\python27';'c:\program files (x86)\grass gis 7.0.1rc1\msys' pythonlib = 'c:\python27' pythonpath = 'c:\program files (x86)\grass gis 7.0.1rc1\etc\python' sys.path.append(os.path.join(os.environ['...
Read more

Swift game error message -

i following ios game tutorial. cannot figure out wrong here. error on these 2 lines. let newangle = percent * 180 - 180 cannon.zrotation = cgfloat(newangle) * cgfloat(m_pi); 180.0 //error "use of unresolved identifier 'percent'" the tutorial uses: cannon.zrotation = cgfloat(newangle) * cgfloat(m_pi)/ 180.0 but changed error suggested import spritekit class gamescene: skscene { var cannon: skspritenode! var touchlocation:cgpoint = cgpointzero override func didmovetoview(view: skview) { /* setup scene here */ cannon = self.childnodewithname("cannon") as! skspritenode } override func touchesbegan(touches: set<uitouch>, withevent event: uievent?) { /* called when touch begins */ touchlocation = touches.first!.locationinnode(self) } override func touchesmoved(touches: set<uitouch>, withevent event: uievent?) { touchlocation = touches.first!.locationinn...
Read more