c# - LINQ to Entities does not recognize the method 'System.String IfNullOrWhiteSpace' -

-

so, have search query giving me error now. (it didn't used too, fyi...) anyway, it's throwing "linq entities not recognize method 'system.string ifnullorwhitespace"...

is there beter way of doing this?

 var stringresults = _propertyrepository             .getproperties()             .where(                 // standard fields                 x => x.address.ifnullorwhitespace("").contains(searchstring)                      || x.city.ifnullorwhitespace("").contains(searchstring)                      || x.websiteurl.ifnullorwhitespace("").contains(searchstring)                      || x.zip.ifnullorwhitespace("").contains(searchstring)                     // overrides possible                      || (x.descriptionoverride ? x.descriptionoverridevalue.contains(searchstring) : x.description.ifnullorwhitespace("").contains(searchstring))                      || (x.nameoverride ? x.nameoverridevalue.contains(searchstring) : x.name.contains(searchstring))                      || (x.squarefootageoverride ? x.squarefootageoverridevalue.tostring().contains(searchstring) : x.squarefootage.tostring().contains(searchstring))                     // tags                      || (x.tagsoverride ? x.tagsoverridevalue.any(f => f.tagname.contains(searchstring)) : x.tags.any(f => f.tagname.contains(searchstring)))                     // bayoptions                      || x.bayoptions.any(g => g.baysizeoverride ? g.baysizeoverridevalue.tostring().contains(searchstring) : g.baysize.tostring().contains(searchstring))                      || x.bayoptions.any(g => g.descriptionoverride ? g.descriptionoverridevalue.ifnullorwhitespace("").contains(searchstring) : g.description.ifnullorwhitespace("").contains(searchstring))                      || x.bayoptions.any(g => g.excerptoverride ? g.excerptoverridevalue.ifnullorwhitespace("").contains(searchstring) : g.excerpt.ifnullorwhitespace("").tostring().contains(searchstring))                     // freeform fields                      || x.freeformfields.any(g => g.numbervalue.tostring().contains(searchstring))                      || x.freeformfields.any(g => g.stringvalue != null && g.stringvalue.tostring().contains(searchstring))             ).tolist();

ifnullorwhitespace custom extension method, l2e provider not know it.

you don't need null checks when doing contains in l2e, can remove ifnullorwhitespace part.


Comments

Post a Comment

Popular posts from this blog

mysql - FireDac error 314 - but DLLs are in program directory -

-
i getting when trying access mysql database : [firedac][phys][mysql]-314. cannot load vendor library [libmysql.dll or libmysqlld.dll] this did not happen (unchanged) code, however, have upgraded windows 10 , had reinstall delphi xe8, system configuration matter. in order try solve problem, copied both of files c:\windows\sysytem32. when did not seem work, copied them \win32\debug, generated .exe resides. i imagine doing rather stupid, can't see what. the proper solution place driver file (eg., libmysql.dll ) in application's folder, or place installation location in fddrivers.ini file: [mysql] vendor=<folder>\libmysql.dll (recent versions of documentation seem use vendorlib instead of vendor in ini file.) see rad studio documentation topics configuring drivers (firedac) , connect mysql server (firedac) more information.
Read more

Log not being recorded for quickfix c++ Session -

-
i running fix initiator , succesfully connecting acceptor. problem is, no log being recorded. .cfg application written below. [default] connectiontype=initiator reconnectinterval=2 resetonlogon=y filestorepath=store filelogpath=logging starttime=00:00:00 endtime=00:00:00 usedatadictionary=y # standard config elements [session] # inherit connectiontype, reconnectinterval , sendercompid default beginstring=fix.4.4 sendercompid=init targetcompid=accept socketconnecthost=xxx socketconnectport=xxx heartbtint=30 datadictionary=fix44md.xml [session] beginstring=fix.4.4 sendercompid=init targetcompid=accept1 socketconnecthost=xxx socketconnectport=xxx heartbtint=30 datadictionary=fix44oms.xml the excerpt code initiates connection written below: std::string file = argv[ 1 ]; fix::sessionsettings settings( file ); application application; fix::filestorefactory storefactory( settings ); fix::screenlogfactory logfactory( settings ); fix::socketinitiator initi...
Read more

ios - NSFetchedResultsController not calling delegate methods on changes using NSPredicate with subquery -

-
i have nsfetchedresultscontroller created follows: let fetchrequest = nsfetchrequest(entityname: "friendship") fetchrequest.sortdescriptors = [ nssortdescriptor(key: "friendtocurrentuser.displayname", ascending: true) ] fetchrequest.predicate = nspredicate(format: "subquery(friendtocurrentuser.trackingsessions, $x, $x.dataisstale == false , $x.enddate == nil).@count != 0") let fetchedresultscontroller = nsfetchedresultscontroller(fetchrequest: fetchrequest, managedobjectcontext: coredatamanager.instance.mainmanagedobjectcontext, sectionnamekeypath: nil, cachename: nil) fetchedresultscontroller.delegate = self var error: nserror? if !fetchedresultscontroller.performfetch(&error) { println(error) } when initial fetch completes controller:didchangeobject:atindexpath:forchangetype: called, when object should added/removed due subquery method not called. if simple delegate methods aren't called when predicate contains subquery tha...
Read more