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