Using SMO with Oracle?

8 Jun 2006 3:28 PM

Scott

All,

Microsoft has Sql Server Management Object (SMO) for use with Sql Server
databasess; is there something simliar for using ADO.NET with an Oracle
database?

Thanks in advance.

9 Jun 2006 8:29 AM

Frans Bouma [C# MVP]

Scott wrote:

> All,
>
> Microsoft has Sql Server Management Object (SMO) for use with Sql
> Server databasess; is there something simliar for using ADO.NET with
> an Oracle database?

No, SMO is for SQLServer only. Though you can control oracle with SQL
so all you need is a connection with the oracle db and of course the
knowledge of which SQL statements to use :)

FB

--
------------------------------------------------------------------------
Lead developer of LLBLGen Pro, the productive O/R mapper for .NET
LLBLGen Pro website: http://www.llblgen.com
My .NET blog: http://weblogs.asp.net/fbouma
Microsoft MVP (C#)
------------------------------------------------------------------------