By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,210 Members | 1,405 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,210 IT Pros & Developers. It's quick & easy.

Typed dataset with oracle db ?

P: n/a
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?

Jan 26 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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.
--------------------------------
"R" <in**@citsecure.comwrote in message
news:Ou*************@TK2MSFTNGP05.phx.gbl...
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?

Jan 26 '07 #2

P: n/a

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/archi...17/534113.aspx

I'd suggest the EnterpriseLibrary.Data ...

google this:
http://www.google.com/search?hl=en&q...le+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.


"R" <in**@citsecure.comwrote in message
news:Ou*************@TK2MSFTNGP05.phx.gbl...
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?

Jan 26 '07 #3

P: n/a

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

"R" <in**@citsecure.comwrote in message
news:Ou*************@TK2MSFTNGP05.phx.gbl...
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?

Jan 26 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.