>>I suspect it should work from VB.NET fine, you need to run Google search for this. If you want to have high precision of datetime values, then of course, updating datetime to datetime2(7) sounds like a good plan.
>
>Well, there are two. There is DateTime2 and DateTime2(7). I didn't have time to look at the second one yet. But, I would assume they are both as precised.

Can you not have SQL Server default the timestamp for you instead of VB.Net? After the record is added, you can obtain the value from the database.