ADO NET Express Pro description
Visual Studio add-in, generates class methods for executing stored procedures

ADO.NET Express is an add-in for Visual Studio 2003 that generates class methods for calling stored procedures and executing common types of SQL statements. ADO.NET Express supports C#/VB and SQL Server/Oracle. ADO.NET Express looks similar to Server Explorer.

You can add database connections and browse schema objects such as tables and stored procedures. You can right click on a schema object to generate ADO.NET code for this object.

For example, you can right-click on a stored procedure and generate a C# method that executes the stored procedure and returns a DataReader. ADO.NET Express is especially useful for ASP.NET and middleware developers who write a lot of data access code and would like to save time to do more creative tasks.

Generated code is easy to understand and modify. ADO.NET Express has a variety of options for generating code that cover most of the common data access scenarios. Generated code can also be used as a template for modification.

Here are some key features of "ADO NET Express Pro":

· Generates class methods for calling stored procedures and executing common types of SQL statements.
· Supports C# and Visual Basic.NET.
· Supports SQL Server and Oracle databases.
· Common SQL statements can be generated for tables, foreign keys and views. Examples include: Select record by primary key, Update record with concurrency, Delete records by foreign key
· Several code generation options for stored procedures. Examples include: Call stored procedure, return DataReader, Create ADO.NET command with parameters that can be used later
· Method is generated with typed parameters that correspond to stored procedure parameters.
· Regular .NET types (int, string, decimal, ...) or provider specific types (SqlInt32, SqlString, SqlMoney, ...) can be used for method parameters. Provider specific types are useful for handling NULL values.
· Full support for output and input/output parameters for stored procedures.
· Flexible options for obtaining connection string. It can be read from a config file, it can be hardcoded or it can be obtained by calling a user specified object.
· Full support for transactions. Transaction object can be passed to the method, so that SQL command will execute in a context of a transaction.


Requirements:

· Visual Studio.NET 2003