G
Guest
ADOX is the extension ADO. And I wonder if there is any extension for ADO.NET? I need a object model in C#, with which I could easily access the schema of a database.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
Teemu Keiski
Hi,
AFAIK, ADOX is not supported in ADo.NET and to use it you'd need to play
with COM Interoperability.
--
Teemu Keiski
MCP, Microsoft MVP (ASP.NET), AspInsiders member
ASP.NET Forum Moderator, AspAlliance Columnist
http://blogs.aspadvice.com/joteke
schema of a database.
AFAIK, ADOX is not supported in ADo.NET and to use it you'd need to play
with COM Interoperability.
--
Teemu Keiski
MCP, Microsoft MVP (ASP.NET), AspInsiders member
ASP.NET Forum Moderator, AspAlliance Columnist
http://blogs.aspadvice.com/joteke
ADO.NET? I need a object model in C#, with which I could easily access theLaser Lu said:ADOX is the extension ADO. And I wonder if there is any extension for
schema of a database.
O
Otis Mukinfus
On Sun, 30 May 2004 01:46:01 -0700, "Laser Lu"
Although you can use ADOX in .NET applications to get schema and any
of the other things ADOX does, you can get the schema of a database by
using the GetOleDbSchemaTable method of the Connection object.
Otis Mukinfus
http://www.otismukinfus.com
Although you can use ADOX in .NET applications to get schema and any
of the other things ADOX does, you can get the schema of a database by
using the GetOleDbSchemaTable method of the Connection object.
ADOX is the extension ADO. And I wonder if there is any extension for ADO.NET? I need a object model in C#, with which I could easily access the schema of a database.
Otis Mukinfus
http://www.otismukinfus.com
G
Guest
Although you can use ADOX in .NET applications to get schema and an
of the other things ADOX does, you can get the schema of a database b
using the GetOleDbSchemaTable method of the Connection object
You can, of course, read the schema information from the SchemaTable, but you can not modify the schema in your code. For example, if you want to change the name of a table or a field programmatically, then how to do it? So I wonder if there is a purely .NET based object model to modify the shema of a database?
of the other things ADOX does, you can get the schema of a database b
using the GetOleDbSchemaTable method of the Connection object
You can, of course, read the schema information from the SchemaTable, but you can not modify the schema in your code. For example, if you want to change the name of a table or a field programmatically, then how to do it? So I wonder if there is a purely .NET based object model to modify the shema of a database?
M
Miha Markic [MVP C#]
Hi Laser,
No, there isn't.
--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com
change the name of a table or a field programmatically, then how to do it?
So I wonder if there is a purely .NET based object model to modify the shema
of a database?
No, there isn't.
--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com
you can not modify the schema in your code. For example, if you want toLaser Lu said:of the other things ADOX does, you can get the schema of a database by
using the GetOleDbSchemaTable method of the Connection object.
You can, of course, read the schema information from the SchemaTable, but
change the name of a table or a field programmatically, then how to do it?
So I wonder if there is a purely .NET based object model to modify the shema
of a database?
P
Paul Clement
¤ >Although you can use ADOX in .NET applications to get schema and any
¤ of the other things ADOX does, you can get the schema of a database by
¤ using the GetOleDbSchemaTable method of the Connection object.
¤
¤ You can, of course, read the schema information from the SchemaTable, but you can not modify the schema in your code. For example, if you want to change the name of a table or a field programmatically, then how to do it? So I wonder if there is a purely .NET based object model to modify the shema of a database?
If you want to modify schema then you will have to use the SQL DDL language for the database type
you are working with. As was mentioned there is no equivalent to ADOX in .NET.
Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
¤ of the other things ADOX does, you can get the schema of a database by
¤ using the GetOleDbSchemaTable method of the Connection object.
¤
¤ You can, of course, read the schema information from the SchemaTable, but you can not modify the schema in your code. For example, if you want to change the name of a table or a field programmatically, then how to do it? So I wonder if there is a purely .NET based object model to modify the shema of a database?
If you want to modify schema then you will have to use the SQL DDL language for the database type
you are working with. As was mentioned there is no equivalent to ADOX in .NET.
Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
G
Guest
Is it possible to rename a table or a filed just using SQL DDL
----- Paul Clement wrote: -----
If you want to modify schema then you will have to use the SQL DDL language for the database typ
you are working with. As was mentioned there is no equivalent to ADOX in .NET
Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic
----- Paul Clement wrote: -----
If you want to modify schema then you will have to use the SQL DDL language for the database typ
you are working with. As was mentioned there is no equivalent to ADOX in .NET
Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic
C
Cor Ligthert
Hi Laser,
You can create everything using an SQL Textstring and the
command.executenonQuerry
As far as I know is the only thing you can not do in ADONET is creating an
empty Access database or whatever datatabase.
http://msdn.microsoft.com/library/d...aodbcodbccommandclassexecutenonquerytopic.asp
I hope this helps?
Cor
You can create everything using an SQL Textstring and the
command.executenonQuerry
As far as I know is the only thing you can not do in ADONET is creating an
empty Access database or whatever datatabase.
http://msdn.microsoft.com/library/d...aodbcodbccommandclassexecutenonquerytopic.asp
I hope this helps?
Cor
P
Paul Clement
¤ Is it possible to rename a table or a filed just using SQL DDL?
¤
That would depend upon the database. I don't think you can use SQL DDL to rename an Access table or
column. In SQL Server you can use the stored procedure sp_rename.
Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
¤
That would depend upon the database. I don't think you can use SQL DDL to rename an Access table or
column. In SQL Server you can use the stored procedure sp_rename.
Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)