Information Using VB.NET SQL STORED PROCEDURES DAL BLL

I am a bit confused on what method to use when creating an applicati开发者_开发百科on that deals with MSSQL Stored Procedures and VB.NET.

Should i study and implement the Data Access Layer along side with the Business Logic Layer? Is this approach the most efficient when needing to display data from database tables and update data also or should I be approaching this another way?

Thanks

Your question is somewhat vague, but I'll try anyway.

Yes, your data access layer should be separate from your business logic layer. It makes your code cleaner and more maintainable. Look into ORMs like Entity Framework for accessing your database. In some scenarios, you may not even need to write stored procedures to retrieve the data you need or perform updates.