Difference between ? and @VarName parameters in VB.net

[PsychoData]

I'm working on a vb.net program for in house use. I've been looking around and trying to understand what the best way to use parameterized queries is. I've seen many places that mention @VarName that would be used as INSERT INTO people (FirstName,LastName) VALUES (@FName,@LName) where each is their respective parameter, but I've also seen several places that say to use positional parameters as ? used as INSERT INTO people (FirstName,LastName) VALUES (?,?) where the first parameter of ? is FirstName and the second is LastName. I'm working with an OpenEdge Progress Database.

Which is the convention for VB.net, if there is one? What is the difference between them?

Continue reading...