LINQ Stored Procedure DATETIME NULL <p>I got this errormessage when I use Linq and and stored procedure as follow. I got this message when the DateTime parameter is NULL. How will I do to solve this?</p> <p>Errormessage Serverfel i tillämpningsprogrammet. SqlDateTime-spill: Det måste vara mellan 1/1/1753 12:00:00 AM och 12/31/9999 11:59:59 PM. </p> <p>Codeblock in C#</p> <pre><code>protected void ButtonSearch_Click(object sender, EventArgs e) { Postit p = new Postit(); DateTime? dt; if(TextBoxDate.Text=="") { dt=null; } else { dt=System.Convert.ToDateTime(TextBoxDate.Text); } GridView1.DataSource = p.SearchPostit(TextBoxMessage.Text, TextBoxWriter.Text, TextBoxMailto.Text, System.Convert.ToDateTime(dt)); GridView1.DataBind(); } public ISingleResult&lt;Entities.SearchPostitResult&gt; SearchPostit([Parameter (DbType="VarChar(1000)")] string message, [Parameter(DbType="VarChar(50)")] string writer, [Parameter(DbType="VarChar(100)")] string mailto, [Parameter(DbType="DateTime")] System.Nullable&lt;System.DateTime&gt; date) { IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())), message, writer, mailto, date); return ((ISingleResult&lt;Entities.SearchPostitResult&gt;)(result.ReturnValue)); Procedure ALTER PROCEDURE [dbo].[SearchPostit] ( @message varchar(1000)='', @writer varchar(50)='', @mailto varchar(100)='', @date Datetime=null ) AS SELECT P.Message AS Postit, P.Mailto AS 'Mailad till', P.[Date] AS Datum , U.UserName AS Användare FROM PostIt P INNER JOIN [User] U ON P.UserId=U.UserId WHERE P.message LIKE '%'+@message+'%' AND P.Mailto LIKE '%'+@mailto+'%' AND ( @date IS NULL OR P.Date = @date ) AND U.UserName LIKE '%'+@writer+'%' GROUP BY P.Message, P.Mailto, P.[Date], U.UserName } </code></pre>