<div>
Note that you can perfectly work and set up datareaders while using stored procedures. &nbsp;Using stored procedures simply means you have a nice clean separation between the Data Layer and the Object Layer...
</div>


<div>
Thanks guys. <br />
<br />
I'm going in the right way!<br />
<br />
jpaulino
</div>


<div>
<div class="content wysiwyg-content">
I have worked allot with SQL Server and I always used direct commands like sqlcommand, sqldatareader, etc, and never with storage procedures.<br />
<br />
My question is: what the advantages and disadvantages of using then? <br />
<br />
We have to create the storage procedures and the SQL instruction in the code, so why?<br />
<br />
Any good example of it would be nice (VB).<br />
<br />
Thanks<br />

</div>
</div>


I have worked allot with SQL Server and I always used direct commands like sqlcommand, sqldatareader, etc, and never with storage procedures.

My question is: what the advantages and disadvantages of using then? 

We have to create the storage procedures and the SQL instruction in the code, so why?

Any good example of it would be nice (VB).

Thanks


Note that you can perfectly work and set up datareaders while using stored procedures.  Using stored procedures simply means you have a nice clean separation between the Data Layer and the Object Layer...

Thanks guys. 

I&#39;m going in the right way!

jpaulino

Advantages and disadvantages of storage procedures

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.

.NET Programming

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,