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

java - Toggle JDialog visibility on button press or lose focus -

-
java gurus, looking toggle jdialog's visibility when jbutton pressed or when jdialog loses focus i.e. when area of screen outside jdialog becomes active. lose focus working fine, it's handed windowfocuslistener can't functionality jbutton i.e. 1st click => jdialog visible, 2nd click => jdialog invisible, 3rd click => jdialog visible. i don't want go down route of making jdialog modal or counting clicks on button. any ideas of achieving above functionality in simple, clean way? import java.awt.color; import java.awt.dimension; import java.awt.flowlayout; import java.awt.point; import java.awt.event.actionevent; import java.awt.event.actionlistener; import java.awt.event.windowevent; import java.awt.event.windowfocuslistener; import javax.swing.*; public class testframeexample { public static void main(string s[]) { final jdialog dialog = new jdialog(); final jbutton button = new jbutton(); jframe frame = new jframe(...
Read more

wpf - C# NAudio - Changing audio playback position still plays a small buffer of old position -

-
i trying make basic mp3 player in c# , wpf, along naudio. added slider tracks current position in song allows drag different position , upon thumb.dragcompleted set song's position dragged it. this works fine , all, except when make jump new position, still plays old position 1/5th or of second before changing. noticeable e.g. while singer in middle of singing "aaa", pause, drag point sings "ooo", play again, hear "aa-ooo". results in sounding pretty horrible. so suppose audio playback has small 'buffer' remaining insists on playing before moving on. there way clear buffer? or setting position wrong? i using waveout waveoutdevice , audiofilereader audiofilereader . slider called sldrplaybackprogress . tried change position in song in 2 different ways already: first method: audiofilereader.currenttime = new timespan(0, (int)(math.floor(sldrplaybackprogress.value / 60)), (int)(math.floor(sldrplaybackprogress.value % 60))); sec...
Read more