Linq Query Using Left Joins With AsEnumerable()
var qu = (from tt in table1.AsEnumerable() join ss in table2.AsEnumerable() on tt.Field<int>("UniqID") equals ss.Field<int>(" UniqID ") into tt_ss from ss in tt_ss.DefaultIfEmpty() select new ...