Linq Query

Ramco Ramco

I want if there is value in Status then it should return only those records else it should return all records.

List Result = (from t in context.View_Details
                                                          where t.FromDate.Value.Date >= frDate.Date && t.FromDate.Value.Date <= toDate.Date
                                                          
                                                          && (t.Status != "" ? t.Status == TStatus.ToString() : 1 == 1)
                                                          
                                                          select t).ToList();
                return Result;

Thanks

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh3y ago

Accepted answer

test this

List Result = 
(
from t in context.View_Details
where t.FromDate.Value.Date >= frDate.Date && t.FromDate.Value.Date <= toDate.Date
&& (string.IsNullOrEmpty(t.Status)||t.Status == TStatus.ToString())
select t
).ToList();
return Result;

Jignesh Kumar3y ago

Hi Ramco,

Please use below query which will help you out,

List result = new List();
var q = (from t in context.View_Detailswhere t.FromDate.Value.Date >= frDate.Date && t.FromDate.Value.Date <= toDate.Dateselect t);if(!string.IsNullOrEmpty((TStatus.ToString())
{result = q.Where(x => x.Status == TStatus.ToString()).ToList();						
}	
else
{		result = q.ToList();;
}return result;