left outer join using linq query syntax

var result = from p in _context.ParentTable<br/>
 join c1 in _context.ChildTable1 <br/>on p.ID equals c1.ID into pc1Table <br/>from pc1Join in pc1Table.DefaultIfEmpty()<br/>
 join c2 in _context.ChildTable2 on p.ID equals c2.ID into pc2Table from pc2Join in pc2Table.DefaultIfEmpty()
 where (c1.columnname == "value1" ||
 c2.columnname == "value2") &amp;&amp; p.columnname == "value"
 select new
 {
 pID = p.ID,
 c1ID = c1.ID,
 c2ID = c2.ID};
 &nbsp;

Comments

Post a Comment

Popular posts from this blog

storing byte array as column value in datatable using c#

This post covers following objective 1. How to declare and define datatable 2. Add columns at runtime 3. Add column to store byte array (image/file etc) //YOUR PHOTOGRAPH HERE MemoryStream ms = new MemoryStream(); argPhotograph.Save(ms, System.Drawing.Imaging.ImageFormat.Gif); //DECLARING DATATABLE DataTable dt = new DataTable ();   dt . Columns . Add ( "ID" ); dt . Columns . Add ( "Name" ); dt . Columns . Add ( "CreatedOn" , typeof ( DateTime )); dt . Columns . Add ( "Photograph" , typeof ( byte []));   //METHOD 1: ADDING DATA DataRow row = null; row = dt.NewRow(); row[ "ID"] = 1; row[ "Name"] = "Usman"; row[ "CreatedOn"] = DateTime.Now; row[ "Photograph"] = argPhotograph.ToArray(); dt.Rows.Add(row);  //METHOD 2: ADDING DATA dt.Row.Add( 1, "Usman", DateTime.Now, argPhotograph.ToArray());
Read more

post form data and bind with model : using jquery ajax in mvc

There are multiple ways of posting data from view to controller using jquery + ajax in mvc 1. post data by assigning parameters one by one and bind it with model manually 2. post data by serializing form and automatically binding with model 3. post data by assigning parameters one by one + making custom class and assigning data to its variables which are named similarly as that of model Method 1:     $.ajax({         url: "/Controller/SubmitAction",         type: "POST",         dataType: "text",         data: { name: _name, age: _age, id: _id },         success: function (response) {             alert("Success");         },         error: function () {             alert("Error");         }     }); public JsonResult SubmitAction(string name, string age, int id) {       try       {             Person obj = context.Person.FirstOrDefault(x=>x.id = id);             obj.Name = name;             obj.Age = age;
Read more

Htc sensation XL mobile not working with windows 7 or above, along with Htc sync software

Problem: Htc sensation XL connectivity issue with windows 7 or above + Htc sensation XL device detection issue with Android Studio + Htc sensation XL connectivity issue with Htc sync software Solution: For all of the above mentioned issues, please see steps below for smooth & successful activity. Please make sure that 1. In Pc, Htc sync software version 3.2.26 or 3.3.63 is installed. 2. Ur device is connected to PC via usb cable. 3. In mobile, change connectivity options from 'charging' to 'htc sync' 4. In Pc, goto device manager and see for hardware changes in order to see whether device is detected by Pc or not yet, If yes you are good to go, if not follow below mentioned steps 5. Run htc sync in compatible mode by going to properties and changing OS to windows vista, then re-run Htc sync software and re-connect from mobile to see if it detects changes or not, if yes we are good to go but if not see below 6. In Pc, install htc usb drivers fro
Read more