How to union two data tables and order the result
var dt1 = new DataTable(); // Replace with Dt1
var dt2 = new DataTable(); // Replace with Dt2
var result = dt1.AsEnumerable()
.Union(dt2.AsEnumerable())
.OrderBy (d => d.Field<string>("emp_name"));
i think this code will help u to do it without using entity...
Dt1.Merge(Dt2);