Click here to Skip to main content
15,890,185 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
RETURNED LINQ OUTER JOIN AS A LIST CLASS SHOWS AN ERROR OF NULL VALUE.
WHEN WE TRY TO ASSIGN THE RETURNED QUERY LIST, THE NULL VALUE ERROR COMES.
I NEED A HELP TO KNOW HOW TO CAST THE NULL VALUE IN A PROPER WAY

C#
public class cJAB_MT_SHOP_REGN_LQ
    {

       string _BOB_UNIQUEID;
       long _BOB_LOCATIONID;
       long _NBRANCH_SL;
       long _NREGION_SL;
       string _BOB_DESCRIPTION;
       long _NCM_SL;
       string _CNAME;
       
       public cJAB_MT_SHOP_REGN_LQ(string vBOB_UQ_ID,long vBOB_LOC_ID,long vNBRANCH,long vNRGION,string vBOB_DESCRTN,long vNCM_SL,string vCNAME)
       {
           this._BOB_UNIQUEID = vBOB_UQ_ID;
           this._BOB_LOCATIONID = vBOB_LOC_ID;
           this._NBRANCH_SL = vNBRANCH;
           this._NREGION_SL = vNRGION;
           this._BOB_DESCRIPTION = vBOB_DESCRTN;
           this._NCM_SL = vNCM_SL;
           this._CNAME = vCNAME;
       }
       public cJAB_MT_SHOP_REGN_LQ()
       {
       }
       public string BOB_UNIQUEID
       {
           get { return _BOB_UNIQUEID; }
           set {
               
                this._BOB_UNIQUEID = value; }
       }
       public long BOB_LOCATIONID
       {
           get { return _BOB_LOCATIONID; }
           set { this._BOB_LOCATIONID = value; }
       }
       public long NBRANCH_SL
       {
           get { return _NBRANCH_SL; }
           set { this._NBRANCH_SL = value; }
       }

       public long NREGION_SL
       {
           get { return _NREGION_SL; }
           set { this._NREGION_SL = value; }
       }
       public string BOB_DESCRIPTION
       {
           get { return _BOB_DESCRIPTION; }
           set { this._BOB_DESCRIPTION = value; }
       }
       public long NCM_SL
       {
           get { return _NCM_SL; }
           set { this._NCM_SL= value; }
       }
       public string CNAME
       {
           get { return _CNAME; }
           set { this._CNAME = value; }
       }
     
     
       public IEnumerable<cJAB_MT_SHOP_REGN_LQ>  getALL()
       {
           DC_ShopRegionDataContext db = new DC_ShopRegionDataContext();
           IEnumerable<cJAB_MT_SHOP_REGN_LQ> de = null;
           de = from RTA in db.BOB_LOCATION_MASTERs
                join RFPS in db.AB_MT_SHOP_REGIONs on   RTA.BOB_LOCATIONID equals RFPS.BOB_LOCATIONID into ps
                from p in ps.DefaultIfEmpty()
                join CMREF in db.CM_MT_REF_CODEs on p.NREGION_SL equals CMREF.NCM_SL into rf
                from r in rf.DefaultIfEmpty()
                // where RFPS.BOB_LOCATIONID==xLOCID
                orderby RTA.BOB_DESCRIPTION
                select new cJAB_MT_SHOP_REGN_LQ
                (
               p.BOB_UNIQUEID, p.BOB_LOCATIONID, r.NBRANCH_SL, p.NREGION_SL, RTA.BOB_DESCRIPTION, r.NCM_SL, r.CNAME

                );
           return de;
       }
Posted
Updated 8-Mar-10 17:24pm
v6

1 solution

here you go, I had a friend help me work it out. It turns out you have to do it in 2 steps.

C#
var x1 = from RFPS in db.AB_MT_SHOP_REGIONs
  join CMREF in db.CM_MT_REF_CODEs on RFPS.NREGION_SL equals CMREF.NCM_SL into rf
  from CMREF in rf.DefaultIfEmpty()
  select new {RFPS, CMREF}


var de = from RTA in db.BOB_LOCATION_MASTERs
  join x in x1 on RTA.RTA.BOB_LOCATIONID equals x.RFPS.BOB_LOCATIONID into ps
  from x in ps.DefaultIfEmpty()
  select new cJAB_MT_SHOP_REGN_LQ
  (
  x == null ? "" : x.RFPS == null ? "" : x.RFPS.BOB_UNIQUEID, 
  x == null ? "" : x.RFPS == null ? "" : x.RFPS.BOB_LOCATIONID, 
  x == null ? "" : x.CMREF == null ? "" : x.CMREF.NBRANCH_SL, 
  x == null ? "" : x.RFPS == null ? "" : x.RFPS.NREGION_SL, 
  RTA.BOB_DESCRIPTION, 
  x == null ? "" : x.CMREF == null ? "" : x.CMREF.NCM_SL, 
  x == null ? "" : x.CMREF == null ? "" : x.CMREF.CNAME
  );
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900