Date Range comparison in Lambda Expression (Entity Framework)
public IEnumerable<CRM_Customer> GetCustomersByMultipleFilter(DateTime sEnlistedDate, DateTime eEnlistedDate, string Branch, int Category,string Gender, int City, int Location, int AgeFrom, int AgeTo, DateTime BirthdayDate,DateTime MarriageDayDate, string SingleCustomer) { DateTime minDate = Convert.ToDateTime(DateTime.MinValue.ToShortDateString()); IEnumerable<CRM_Customer> CustomerList = (from a in DbContext.CRM_Customer where (a.SubscriptionDate >= sEnlistedDate && a.SubscriptionDate <= eEnlistedDate) && ((DateTime.Now.Year - ((a.DOB.Value.Year))) >= AgeFrom && (DateTime.Now.Year - ((a.DOB.Value...