Click here to Skip to main content
13,088,453 members (56,126 online)
Click here to Skip to main content
Add your own
alternative version


64 bookmarked
Posted 12 Mar 2007

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


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


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


About the Author

Web Developer
Azerbaijan Azerbaijan
No Biography provided

You may also be interested in...


Comments and Discussions

GeneralErrors Pin
troybooth17-Mar-11 4:39
membertroybooth17-Mar-11 4:39 
GeneralGot my 5! Pin
Joe Sonderegger1-Apr-08 19:36
memberJoe Sonderegger1-Apr-08 19:36 
GeneralMyGeneration - It's free too Pin
mike.griffin@entityspaces.net19-Mar-07 8:34
membermike.griffin@entityspaces.net19-Mar-07 8:34 
GeneralRe: MyGeneration - It's free too Pin
troybooth17-Mar-11 4:30
membertroybooth17-Mar-11 4:30 
QuestionNice. Does this have pre-coded CRUD procs? Pin
sherifffruitfly14-Mar-07 7:58
membersherifffruitfly14-Mar-07 7:58 
AnswerRe: Nice. Does this have pre-coded CRUD procs? Pin
rovshan_b14-Mar-07 19:55
memberrovshan_b14-Mar-07 19:55 

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

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

Permalink | Advertise | Privacy | Terms of Use | Mobile
Web02 | 2.8.170813.1 | Last Updated 13 Mar 2007
Article Copyright 2007 by rovshan_b
Everything else Copyright © CodeProject, 1999-2017
Layout: fixed | fluid