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

python - ValueError: could not convert string to float -

-
i have text file contains data. data follows join2_train = sc.textfile('join2_train.csv',4) join2_train.take(3) [u'21.9059,ta-00002,s-0066,7/7/2013,0,0,yes,1,sp-0019,6.35,0.71,137,8,19.05,n,n,n,n,ef-008,ef-008,0,0,0', u'12.3412,ta-00002,s-0066,7/7/2013,0,0,yes,2,sp-0019,6.35,0.71,137,8,19.05,n,n,n,n,ef-008,ef-008,0,0,0', u'6.60183,ta-00002,s-0066,7/7/2013,0,0,yes,5,sp-0019,6.35,0.71,137,8,19.05,n,n,n,n,ef-008,ef-008,0,0,0'] now trying parse string function splits each of lines of text , convert labeledpoint. have included line converting string elements float the function follows from pyspark.mllib.regression import labeledpoint import numpy np def parsepoint(line): """converts comma separated unicode string `labeledpoint`. args: line (unicode): comma separated unicode string first element label , remaining elements features. returns: labeledpoint: line converted `labe...
Read more

php - Laravel Get all child node count with condition -

-
i using laravel5.1 in application. in have 1 table name users , schema of user table follow. id name parane_id node 1 abc 0 2 xyz 1 l 3 dfs 1 r 4 gjk 2 l 5 dsg 3 l 6 faf 4 r 7 kes 2 r i want count of user left side on user 1 (i.e 2,4,6,7) count 4. same if want right side of 2 return 7 count 1. how can possible using laravel eloquent . any appreciated. you want count tree nodes on condition in case left children of node. define children user . create function traverse children tree , counting. class user extends model { public function children() { return $this->hasmany('app\user', 'parent_id'); } public function countchildren($node = null) { $query = $this-...
Read more