>>I asked your question in the first thread that came by the Google Search
>>
>>http://social.msdn.microsoft.com/Forums/vstudio/en-US/c30b3850-a72a-47d4-a197-21efe4afa0c0/mismatch-between-net-datetime-and-sql-server-datetime2-and-datetime?forum=csharpgeneral
>
>It appears that this would be the way to do it. Forcing the SQL Server specific type would then allow it to get through.
>
>Also, Date.Now and DateTime.Now is represented by the same documentation in VB.NET. I believe Date.Now is just for old support as DateTime.Now seems to be the new format to use. Is that your understanding as well?
>
>As for DateTime.MinValue, I am not sure if this is relevant here. In my case, I want the actual time. So, I believe DateTime.Now would do.

DateTime.Now doesn't have precision up to nanosecond according to that documentation.