datetime C# equvalent

I have the following table column

Code:

---

[hire_date] [datetime] NOT NULL DEFAULT (getdate()),

---

Then using Linq I try the following

employee e1 = new employee
{
.....
hire_date = new DateTime()
};

And I get this error:

Code:

---

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

---

What is the C# equivalent for MSSQL datatime database type ?

I don't think there is one. I normally set a static global variable to the "1753" date and just use that when instantiating dates.

Quote:

---

Originally Posted by eclipsed4utoo

I don't think there is one. I normally set a static global variable to the "1753" date and just use that when instantiating dates.

---

like this
new Datetime("1973") ?

no, like

Code:

---

Convert.ToDateTime("1/1/1753 12:00:00 AM");

---

Thank you.

DateTime maps to SQL's datetime, but the valid range is different. To initialize a DateTime with the minimum value use:
System.Data.SqlTypes.SqlDateTime.MinValue.Value