Any good C# code generator for using oracle stored procedures?

Question

I'm looking for a C# code generator which generate C# automatically to access stored procedures on Oracle Database.

For instance, if I have some packages on schema DEV like:

• PACKAGE1 with FUNC1, FUN2
• PACKAGE2 with FUNC3, FUN4

The generator creates code to run from C# the following code:

int a = PACKAGE1.FUNC1(12, 34, "hello");

Any clue?

Answer 1

MyGeneration is open source, is template driven, and the templates can be written in C#. So would meet your needs, or there might even by a template out their already.

Answer 2

I have something close to what you want... it currently generates stored procedure wrappers for Python. It's an open source package and you can fill in the template with the C# code you desire.

http://markharrison.net/orapig/

http://code.google.com/p/orapig/

I'd be happy to assist in getting this going. My email address is in my profile if you want to discuss further.