Left and right outer join using linq to sql query in asp.net?

Hi guys ,

 This blog we will explain how to write left and right outer join query using linq to sql.

// left outer join code --------------

var leftselect = from stu in dt.students

                         join cou in dt.Courses

                         on stu.SId equals cou.CId into jid

                         from cou in jid.DefaultIfEmpty()

                         select new

                         {

                             studentid = stu.SId,

                             sname = stu.SName,

                             Cname = cou.CName

                         };

        GridView1.DataSource = leftselect;

        GridView1.DataBind();

// right outer join code --------------

       // ........................................

        var rightselect = from cou in dt.Courses

                          join stu in dt.students

                           on cou.CId equals stu.SId into sturight

                          from stu in sturight.DefaultIfEmpty()

                          select new

                          {

                              cou.CId,

                              cou.CName,

                              cou.Duration,

                              

                              stu.SCity

                          };