// // GET: /Show/ public ActionResult Show() { List<Task> taskListFalse = new List<Task>(); List<Task> taskListTrue = new List<Task>(); List<Task> taskListDelete = new List<Task>(); MyDBDataContext db = new MyDBDataContext(); taskListFalse = db.ExecuteQuery<Task>(@"SELECT * FROM [MyTable125] WHERE done = 'false' AND [delete] = 'false'").ToList<Task>(); //taskListFalse = db.ExecuteQuery<Task>(@"SELECT * FROM [MyTable125] WHERE done = 'false' ").ToList<Task>(); taskListTrue = db.ExecuteQuery<Task>(@"SELECT * FROM [MyTable125] WHERE done = 'true' AND [delete] = 'false'").ToList<Task>(); taskListDelete = db.ExecuteQuery<Task>(@"SELECT * FROM [MyTable125] WHERE [delete] = 'true'").ToList<Task>(); /* WriteResult(taskListFalse); WriteResult(taskListTrue); WriteResult(taskListDelete); */ ThreeModel tm = new ThreeModel(); tm.taskListFalse = taskListFalse; tm.taskListTrue = taskListTrue; tm.taskListDelete = taskListDelete; return View(tm); }