>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.