how can i use left outer join in LINQ

The best way would be to create a procedure in SQL and use that as the datasource

Hai.. Inayat Basha

i follow this for leftouterjoin.. But i am not sure this is better way.

regards
sanal p.s
9846385010
cochin

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.IO;

namespace varklinq
{
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_UNIQUEID1
{
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 == null ? "" : p == null ? "" : p.BOB_UNIQUEID,
RTA == null ? 0 : RTA == null ? 0 : RTA.BOB_LOCATIONID,
r == null ? 0 : r == null ? 0 : r.NBRANCH_SL,
p == null ? 0 : p == null ? 0 : p.NREGION_SL,
RTA.BOB_DESCRIPTION,
r == null ? 0 : r == null ? 0 : r.NCM_SL,
r.CNAME

);
return de;
}
public IEnumerable<cJAB_MT_SHOP_REGN_LQ> getALLRegion(long xNREGION)
{
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 p.NREGION_SL ==xNREGION
orderby RTA.BOB_DESCRIPTION
select new cJAB_MT_SHOP_REGN_LQ
(
p == null ? "" : p == null ? "" : p.BOB_UNIQUEID,
RTA == null ? 0 : RTA == null ? 0 : RTA.BOB_LOCATIONID,
r == null ? 0 : r == null ? 0 : r.NBRANCH_SL,
p == null ? 0 : p == null ? 0 : p.NREGION_SL,
RTA.BOB_DESCRIPTION,
r == null ? 0 : r == null ? 0 : r.NCM_SL,
r.CNAME

);

return de;
}



}
}