Multiple Where Conditions In Linq

Question

I want to retrieve the agencyName added between the date ranges arrivalFDate & arrivalTDate . How do I add a linq query having multiple where conditions. ArrivalDate is field of InternationalArrivals. Like the same way as : SELECT * FROM InternationalArrival where AgentName=@agentName ArrivalDate IN BETWEEN (@arrivalFDate  @arrivalTDate ) string agentName = result[0]; DateTime arrivalFDate = DateTime.ParseExact(result[1] dd/MM/yyyy CultureInfo.InvariantCulture); DateTime arrivalTDate = DateTime.ParseExact(result[2] dd/MM/yyyy CultureInfo.InvariantCulture); List intarrivals = null; using (var _context = new SQLHELPSEntities()) { intarrivals = _context.InternationalArrivals.Where(t => t.AgentName.Contains(agentName)).OrderBy(a => a.AgentName).ToList(); ++++++++++WHERE CONDITION OF DATERANGE FIELD CONTAINS where ArrivalDate In BETWEEN arrivalFDate & arrivalTDate

Ramesh Palanivel · Answer

Hi Ashok Try the below code intarrivals = _context.InternationalArrivals.Where(t => t.AgentName.Contains(agentName) && x.ArrivalDate>=arrivalFDate && x.ArrivalDate a.AgentName).ToList();