We help IT Professionals succeed at work.

Two conditions in IQueryable

Whing Dela Cruz
on
Medium Priority
297 Views
Last Modified: 2012-03-10
How to correct this two conditions?
        public IQueryable<SalesRecord> GetSalesRecordsBranchId(int branchid, string sDate)
        {
            return this.ObjectContext.SalesRecords.Where(so => so.BranchID == branchid);
        }
I want to insert sDate something like this... Where so.TheDate == sDate

Please help I don't know how to combine this two conditions...
Comment
Watch Question

return this.ObjectContext.SalesRecords.Where(so => so.BranchID == branchid && so.TheDate == sDate );

Author

Commented:
Hi! Thanks a lot.. I've got it.. can I ask 1 more question?
What about if I put another conditions specifying  the range. example I want to view only the date between February 02, 2012 and March 01, 2012

        public IQueryable<SalesRecord> GetSalesRecordsBranchId(int branchid, string sDate, string xDate)
        {
            return this.ObjectContext.SalesRecords.Where(so => so.BranchID == branchid);
        }
 I want to set sDate and xDate as the range.. Thanks in advance..

Author

Commented:
Thank you so much..

Explore More ContentExplore courses, solutions, and other research materials related to this topic.