private static void ShowTable(mydbsqlDataContext db)
{
//IQueryable<det> dt = from t1 in db.dets select t1;
IEnumerable<det> dt = db.ExecuteQuery<det>(@"select * from det where empid = 3");
Console.Write("| employee id |");
Console.Write(" First Name |");
Console.Write(" Last Name |");
Console.Write(" Middle Name |");
foreach (var v in dt)
{
Console.WriteLine();
Console.Write(v.empid);
Console.Write(" ");
Console.Write(v.fname);
Console.Write(" ");
Console.Write(v.lname);
Console.Write(" ");
Console.Write(v.mname);
}
}
