int ddl_emp = 0;
var queryEmployes = from e in dc.EMPLOYEES
join d in dc.DEPARTMENTs on e.empID equals d.empID
where (ddl_emp != 0 ? e.empID == ddl_emp : e.empID == d.empID)
select new { e.Fname, d.Department};
Kindly mark this post as "Answer", if it helped you.
Marked as answer by CSharper7 on May 09, 2012 05:01 PM
pierrefrc
Participant
947 Points
201 Posts
Re: If statement for WHERE clause
May 09, 2012 04:32 PM|LINK
Hi
You can try:
int ddl_emp = 0; var queryEmployes = from e in dc.EMPLOYEES join d in dc.DEPARTMENTs on e.empID equals d.empID where (ddl_emp != 0 ? e.empID == ddl_emp : e.empID == d.empID) select new { e.Fname, d.Department};