About Site Map Submit Contact Us Log in | Create an account
Create an account Log In
Average Rating
User Rating:
Visitors Rating:
My rating:

Write review
  • License: Freeware
  • Last update: 7 years ago
  • Total downloads: 188
  • Price: Free |
  • Operating system: Win All
  • Publisher: Patrick Verbeeten
See full specifications

scripts default iconEmbedded Sql Publisher's description

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

Embedded Sql Tags:

Click on a tag to find related softwares

Is Embedded Sql your software?

Manage your software

Most Popular

scripts default icon iPod Control 1.1
iPod Control facilitates the usage of your iPod on multiple computers.
scripts default icon SwfDotNet framework for Graphics and Animations 1.0RC1
SwfDotNet framework is a full Net open source library for writing, reading and generating Flash(tm) Swf files
scripts default icon NHibernate 3.2.0.Alpha1
This is a plugin of Java Hibernate Core for the .NET Framework
scripts default icon Driver Backup 1.1
Driver Backup is a .Net 2.0 application to backup non-Microsoft drivers on a Windows box.
scripts default icon iTunes Export for Music and Sound 1.4
iTunes Export exports playlists defined in your iTunes Music Library to standard m3u, .

Related Category