I'm new to programming in VB.NET and SQL. i'd like to ask a general question regarding accessing a database from a VB.NET application.
What would be the most efficient method for manipulating the database from the application? I've read that using stored procedures are the best way to do this. Do i use stored procedures for every and all ways to manipulate the db - adding, delting, modifying, querying etc.?
Is using datasets also the best way of connecting your application to the database?
Appreciate any advice you could give me on this. Thanks.