>>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.
I haven't re-checked BOL yet myself, but I think you need to explicitly specify precision for DateTime2 type otherwise it may be lower by default.
If it's not broken, fix it until it is.
My Blog