Typed dataset with oracle db ?

[R]

Hi

If I have typed dataset with sql client and I am moving the db to oracle,
can I use the typed dataset I have created for the sql?

 

[RobinS]

I don't think so. I think you'll need to recreate it. THe typed dataset
has a bunch of generated code that uses the specific SQLServer
data adapter, command object, connection object, etc.

Robin S.

 

[sloan]

It depends on how "tightly" you created it .... using the GUI tools to drag
and drop an schema, or did you manually create the schema.
(even if you used the GUI, you're not screwed.........)


Here is a small tidbit:
http://blogs.msdn.com/echarran/archive/2006/02/17/534113.aspx

I'd suggest the EnterpriseLibrary.Data ...

google this:
http://www.google.com/search?hl=en&q=EnterpriseLibrary+Data+Oracle+LoadDataSet

The EnterpriseLibrary (.Data is one of them) is an abstract way to talking
to databases.
You'll have to build the Oracle stored procedures (and learn the way of the
"cursor"), but you'll be able to load datasets.

That's the beauty of the IDataReader and the DataSet, they allow yourself to
work with data, and not be tied exclusively to any one RDBMS.

...

See my blog entries;
http://sholliday.spaces.live.com/blog/

6/5/2006 or the May/2006 one.
Custom Objects and Tiered Development II // 2.0


This will show you how to LoadDataSet in a moer generic way.

 

[sloan]

This google search is more exact to your need:
http://www.google.com/search?hl=en&q=EnterpriseLibrary+Oracle+LoadDataSet+cursor