Table-1 ID date 1 21/10/2016 2 22/10/2016 3 24/10/2016
Table-2 seqNum LCdate 1 21/10/2016 2 22/10/2016 3 23/10/2016 4 25/10/2016
(from s in db.Table-1 select new { s.ID , seqNum= 0, LCdate=s.date } .Concat(from s in db.Table-2 select new { ID=0 , s.seqNum, s.LCdate });
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)