c# - Safe query in linq-sql? -



c# - Safe query in linq-sql? -

i have next query:

dat = s in dat orderby s.schedule.employee.employename ascending select s;

the problem schedule or employee might null, in cases, should either show first or last, dont care.

is there way this? crashes when null.

used sort grid view:

[nullreferenceexception: object reference not set instance of object.] kezberprojectmanager.cases.<gvcases_sorting>b__8(case s) in c:\users\jlarouche\documents\visual studio 2010\projects\kezberprojectmanager\kezberprojectmanager\cases.aspx.cs:103 system.linq.enumerablesorter`2.computekeys(telement[] elements, int32 count) +88 system.linq.enumerablesorter`1.sort(telement[] elements, int32 count) +21 system.linq.<getenumerator>d__0.movenext() +178 system.web.ui.webcontrols.gridview.createchildcontrols(ienumerable datasource, boolean databinding) +1698 system.web.ui.webcontrols.compositedataboundcontrol.performdatabinding(ienumerable data) +67 system.web.ui.webcontrols.gridview.performdatabinding(ienumerable data) +14 system.web.ui.webcontrols.databoundcontrol.ondatasourceviewselectcallback(ienumerable data) +123 system.web.ui.datasourceview.select(datasourceselectarguments arguments, datasourceviewselectcallback callback) +33 system.web.ui.webcontrols.databoundcontrol.performselect() +138 system.web.ui.webcontrols.basedataboundcontrol.databind() +30 system.web.ui.webcontrols.gridview.databind() +4 kezberprojectmanager.cases.gvcases_sorting(object sender, gridviewsorteventargs e) in c:\users\jlarouche\documents\visual studio 2010\projects\kezberprojectmanager\kezberprojectmanager\cases.aspx.cs:138 system.web.ui.webcontrols.gridview.onsorting(gridviewsorteventargs e) +122 system.web.ui.webcontrols.gridview.handlesort(string sortexpression, sortdirection sortdirection) +65 system.web.ui.webcontrols.gridview.handlesort(string sortexpression) +78 system.web.ui.webcontrols.gridview.handleevent(eventargs e, boolean causesvalidation, string validationgroup) +497 system.web.ui.webcontrols.gridview.raisepostbackevent(string eventargument) +205 system.web.ui.webcontrols.gridview.system.web.ui.ipostbackeventhandler.raisepostbackevent(string eventargument) +13 system.web.ui.page.raisepostbackevent(ipostbackeventhandler sourcecontrol, string eventargument) +13 system.web.ui.page.raisepostbackevent(namevaluecollection postdata) +9642898 system.web.ui.page.processrequestmain(boolean includestagesbeforeasyncpoint, boolean includestagesafterasyncpoint) +1724

you need check null before accessing properties:

var x = s in dat allow s = s.schedule allow e = s == null ? null : s.employee orderby e == null ? null : e.employeename ascending select s;

c# asp.net linq

Comments

Post a Comment

Popular posts from this blog

web services - java.lang.NoClassDefFoundError: Could not initialize class net.sf.cglib.proxy.Enhancer -

web services - java.lang.NoClassDefFoundError: Could not initialize class net.sf.cglib.proxy.Enhancer - when trying request rest service @ time of response getting exception.. feb 21, 2013 2:34:49 pm com.sun.jersey.spi.container.containerresponse mapmappablecontainerexception severe: exception contained within mappablecontainerexception not mapped response, re-throwing http container java.lang.noclassdeffounderror: not initialize class net.sf.cglib.proxy.enhancer @ org.hibernate.proxy.pojo.cglib.cgliblazyinitializer.getproxyfactory(cgliblazyinitializer.java:117) @ org.hibernate.proxy.pojo.cglib.cglibproxyfactory.postinstantiate(cglibproxyfactory.java:43) @ org.hibernate.tuple.entity.pojoentitytuplizer.buildproxyfactory(pojoentitytuplizer.java:162) @ org.hibernate.tuple.entity.abstractentitytuplizer.<init>(abstractentitytuplizer.java:135) @ org.hibernate.tuple.entity.pojoentitytuplizer.<init>(pojoentitytuplizer.java:55) @ org.hibernate.tuple.e...
Read more

Accessing MATLAB's unicode strings from C -

Accessing MATLAB's unicode strings from C - how can access underlying unicode info of matlab strings through matlab engine or mex c interfaces? here's example. let's set unicode characters in utf-8 encoded file test.txt, read as fid=fopen('test.txt','r','l','utf-8'); s=fscanf(fid, '%s') in matlab. now if first feature('defaultcharacterset', 'utf-8') , c engevalstring(ep, "s") , output text file utf-8. proves matlab stores unicode internally. if mxarraytostring(enggetvariable(ep, "s")) , unicode2native(s, 'latin-1') give me in matlab: non-latin-1 characters replaced character code 26. need getting access underlying unicode info c string in unicode format (utf-8, utf-16, etc.), , preserving non-latin-1 characters. is possible? my platform os x, matlab r2012b. addendum: documentation explicitly states "[mxarraytostring()] supports multibyte encoded characters...
Read more

javascript - mongodb won't find my schema method in nested container -

javascript - mongodb won't find my schema method in nested container - i trying access method of schema stored within mixed container. here situation : have cases model can many different things, have schema each of these things stored in "casecontent" mixed property. var caseschema = mongoose.schema({ casecontent : {}, object : {type:string, default : "null"}, collision : {type : boolean, default : false} }); the casecontent property filled model of 1 of schemas, 1 exemple : var treeschema = new mongoose.schema({ applecount : {type : number, default : 3} }); treeschema.methods.dostuff = function (data) { console.log('hey, listen'); homecoming true; }; then, want utilize method of schema original container : caseschema.methods.dostuff = function (data) { if (this.casecontent.dostuff !== undefined) { this.casecontent.dostuff(); console.log('it worked'); } else { ...
Read more