Embedded Sql Publisher's description
from Patrick Verbeeten
Embedded Sql allows you to manage SQL statements in ASP.NET.
When ever you create an application which uses a database. There certainly are variations but you have basically two option when it comes to deal with SQL-Statements.
You can choose to type the SQL-statements in the source code or you can create stored procedures. Both of these have their own advantages and disadavatanges.
In-code statements ensure that when te application is deployed, no stored procedures have to be updated. Stored procedures on the other hand offer better speed and reusablility.
To allow stored procedures to be created, maximize easy of deployment, this application exists. The .sql files can be edited in either Visual Studio or the SQL Management studio with full support of the syntax checkers and code-Highlighting.
This class does have one other main feature it makes each declared procedure available as a strong type .NET class to access the parameters.
Calling this procedure would normally require you the create a new command object, pass in the procedure name, add the parameter (with value) and execute the command. Then to manage the procedure it self you would either create it in the database or create a file with the create statement.
When using embedded sql you can add the procedure declaration a normal .sql file containing a stored procedure declaration and ASP.Net or Visual Studio can than parse this file into a .Net class which exposes each of the parameters as typed properties.
Now you can manage the procedure in the same place it is used and if you open it in for instance Sql management studio with all the benefits of syntax highlighting and validation.
System Requirements:No special requirements.
Program Release Status:
Program Install Support: Install Only