Calling Oracle 10g stored procedures from .Net 2.0

  • Thread starter Thread starter Reno
  • Start date Start date
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 ?
 
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 ?
Click to expand...
Click to expand...
 
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 ?
Click to expand...
Click to expand...
Click to expand...
 
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!
Click to expand...

You could consider CodeSmith, too.
 
Back
Top