Calling Oracle 10g stored procedures from .Net 2.0

R

Reno

I'm looking for a way to get automatically generated code for using Oracle
stored procedures. I'd like to get strong typed methods, as it is possible
with SQL Server using the dataset designer.
I seems that VS2005 dataset designer isn't able to do so, even with Oracle
..Net Developper tools installed.

According to you, what is the best way to generate this .Net code ?
 
R

Reno

Thank you for replying.

I thought this was a so common problem that it should exist a solution with
..Net Framework 2...

I'll have a look at Entity Framework, but if anyone has another idea, please
tell me!


Miha Markic said:
Try using Entity Framework, it should generate strong typed sp calls for
you.

--
Miha Markic [MVP C#, INETA Country Leader for Slovenia]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

Reno said:
I'm looking for a way to get automatically generated code for using Oracle
stored procedures. I'd like to get strong typed methods, as it is possible
with SQL Server using the dataset designer.
I seems that VS2005 dataset designer isn't able to do so, even with Oracle
.Net Developper tools installed.

According to you, what is the best way to generate this .Net code ?
 
J

Jim Rand

I found the dataset designer / adapter wizard tool so inadequate that I
wrote my own.

Reno said:
Thank you for replying.

I thought this was a so common problem that it should exist a solution
with
.Net Framework 2...rd


I'll have a look at Entity Framework, but if anyone has another idea,
please
tell me!


Miha Markic said:
Try using Entity Framework, it should generate strong typed sp calls for
you.

--
Miha Markic [MVP C#, INETA Country Leader for Slovenia]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

Reno said:
I'm looking for a way to get automatically generated code for using
Oracle
stored procedures. I'd like to get strong typed methods, as it is
possible
with SQL Server using the dataset designer.
I seems that VS2005 dataset designer isn't able to do so, even with
Oracle
.Net Developper tools installed.

According to you, what is the best way to generate this .Net code ?
 
M

Miha Markic

Reno said:
Thank you for replying.

I thought this was a so common problem that it should exist a solution
with
.Net Framework 2...

I'll have a look at Entity Framework, but if anyone has another idea,
please
tell me!

You could consider CodeSmith, too.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top