Insert/Update DateTime field using Linq to SQL

See more:

SQL

LINQ

Hi All,

I am trying to insert/update the datetime field using Linq to SQL. It will show the following error

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

TimeSpan tsDays = dtTo.SelectedDate.Subtract(dtFrom.SelectedDate);
                EmployeeLeave empleave = new EmployeeLeave();
                empleave.EmployeeID = Convert.ToInt32(cmbEmployee.SelectedItem.Value);
                empleave.LeaveTypeName = cmbLeaveType.SelectedItem.Value;
                empleave.IsHalfDay = (chkHalfDay.Checked) ? true : false;
                empleave.IsFormal = (chkFormal.Checked) ? true : false;
                empleave.Reason = txtReason.Text.Trim();
                if (tsDays.Days > 0)
                {
                    for (int i = 0; i < tsDays.Days; i++)
                    {
                        empleave.Date =dtFrom.SelectedDate.AddDays(i);
                        pdc.EmployeeLeaves.InsertOnSubmit(empleave);
                    }

                }
                else
                {
                    empleave.Date = dtFrom.SelectedDate;
                    pdc.EmployeeLeaves.InsertOnSubmit(empleave);
                }
                pdc.SubmitChanges();

Please help me, what is the wrong in this source and give you suggestions