using System;
using System.Linq;
using System.IO;
namespace ConsoleApplication1
{
class Program
{
static void Main(string[ args)
{
using (DataClasses1DataContext dataContext = new DataClasses1DataContext())
{
StreamWriter sw = new StreamWriter(@"d:\log.txt");
sw.AutoFlush = true;
TextWriter tw = TextWriter.Synchronized(sw);
dataContext.Log = tw;
var rs = (
from t1 in dataContext.Table_1 select t1
).Union(
from t2 in dataContext.Table_1 select t2
).OrderBy(t => t.ID);
foreach (var r in rs)
Console.WriteLine("{0}:{1}", r.ID, r.Number);
}
Console.ReadLine();
}
}
}