i have web form .in which i have button to delete all records against one date.there are two fields in the form,one drop down list where all sector are given,and is a date.when user select a sector and put a date in the field,and click on delete button then all record will be deleted.c# code is as follow,i want linq statement in which i can use where clause.
protected void Clear_Roaster(object sender, EventArgs e)
{ int sectorId = SafeConvert.ToInt32(ddlsectorRoaster.SelectedValue);
DateTime dt = SafeConvert.ToDateTime(txtDate.Text);
_service.DeleteEmployeeStatus(sectorId);
}

Rasmita DashPosted Jan 14, 2015, 5:41 AM
// Get the list of records to be deleted
var LstEmployeeStatus = DbCtxt.EmployeeStatuses.Where((Temp=>Temp.OprDate == New DateTime(1,1,2015)) && (Temp => Temp.sectorId == 5 ));
DbCtxt.EmployeeStatuses.DeleteAllOnSubmot(LstEmployeeStatus);
DbCtxt.SubmitChanges();