public bool ManageExamDates() { DateTime?dtAvailableDate = Convert.ToDateTime(DateTime.Today.ToShortDateString()); var transferdatesEnity = new TADEDBEntities(); var AvailableDateRemains = transferdatesEnity.AvailableDates.Where(ad => ad.AvailableDate1 < dtAvailableDate).ToList(); if (AvailableDateRemains != null) { DataTable dtsourceTable = tsql.SelectAvailableDates(); tsql.MakeBulkCopyTable("dbo.AvailableDatesHistory", dtsourceTable); tsql.DeleteAvailableDates(); } return(true); }