linq to sql not between
Posted on 2013-01-31
I have the following where clausing in sql, how do i write the comparable in linq?
where CONVERT(DATE, GETDATE()) not between CheckInDate and CheckOutDate
I'm trying to query the non active records in my table, which means today's date will not fall in between the check in and check out dates.