Click here to Skip to main content
Click here to Skip to main content
Go to top

Simple C# code generator for Oracle

, 12 Mar 2007
Rate this:
Please Sign up or sign in to vote.
This is a simple C# code generator for stored procedures in an Oracle database. It also can create text for the new stored procedures.

Screenshot - ora_gen1.jpg

Introduction

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

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

rovshan_b
Web Developer
Azerbaijan Azerbaijan
No Biography provided

Comments and Discussions

 
GeneralErrors Pinmembertroybooth17-Mar-11 4:39 
GeneralGot my 5! PinmemberJoe Sonderegger1-Apr-08 19:36 
GeneralMyGeneration - It's free too Pinmembermike.griffin@entityspaces.net19-Mar-07 8:34 
GeneralRe: MyGeneration - It's free too Pinmembertroybooth17-Mar-11 4:30 
QuestionNice. Does this have pre-coded CRUD procs? Pinmembersherifffruitfly14-Mar-07 7:58 
AnswerRe: Nice. Does this have pre-coded CRUD procs? Pinmemberrovshan_b14-Mar-07 19:55 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Mobile
Web01 | 2.8.140926.1 | Last Updated 13 Mar 2007
Article Copyright 2007 by rovshan_b
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid