PosharpDb 1.0.0 Screenshot

PosharpDb is a .NET stored procedure wrapper generator that generates a set of static C# or VB.NET methods into different classes to wrap the chosen stored procedures.

It not only supports Microsoft Oracle, SQL Server, OleDb and ODBC .Net data providers, but also can be extended, through simple configuration settings, to third party .Net data providers, such as Oracle, DB2, MySQL, etc. PosharpDb provides a variety of options to cover most of ADO.Net data access scenarios and an alternative to manage a large scale of stored procedures as well.

The option settings can be saved to file for repeating generation such that the generated data layer can be synchronized with the database whenever changes are made to stored procedures. This is especially helpful for large, complex projects to discover data-layer mismatching issues as early as in compiling time.

Here are some key features of "PosharpDb":

· Generate C# and VB.NET code in to call stored procedures
· Support Multiple .Net data providers.
· Support output procedure parameters.
· Support typed and untyped .Net parameters which match the procedure parameter types.
· Support transactions that a procedure call can execute in the context of a transaction.
· Flexible for effecient use of ADO.Net functionality: (1) Call stored procedures by using ExecuteNonQuery(), ExecuteScalar(), ExecuteReader(), or Fill() ADO.Net method. (2)Return data by using (typed)DataTable, (typed)DataSet, or a single value. (3)Pass database connection information through command object, connection object or connection string. (4)Embed instrumentation code to monitor runtime input and output information for debugging and troubleshooting.
· Support stored procedure grouping based on procedure functionality or programming subsystems where the procedures are to be used.
· Suport setting persistence for code regeneration