I recently started to implement a project with Oracle as a database backend and I needed some way to simplify database access to call stored procedures in my packages. After exploring several code generators I decided to write a simple code generator that I can always modify to suit my needs. Now it started to help me with my project and I decided to share it with you.
Using the application
After starting the application select the Connect menu item from the File menu and enter the connection string. The list of tables is displayed in the list box. Double click any of the tables. In the options dialog make the necessary selections and click OK button. First (New procedures) and second (Code) tabs will be filled with the generated code. Also you can switch to the third (Existing procedures) tab and click the refresh button. The combo box is populated with the list of existing database procedures. Now select the used table from the left and click the Show code button. DataTypes.xml file contains data type mappings between .NET and Oracle types. So, you can modify this file to suit your needs.
I will update this little app as I move with the project