System.Data.SqlTypes.SqlTypeException: SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.

You get this exception when the datetime in your where clause is out of the range specified in error.
This is because SqlServer only stores the dates between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59  as the error specifies