Dear Bob, Thank you very much. It saved me a great deal of time. And I also found this link (actually one of my friends found it):
http://groups.google.com/groups?q=adox+.net&hl=en&selm=XhvkL6NIBHA.185%40cppssbbsa01.microsoft.com&rnum=2 which was very useful. Interesting is that in ADOX I was having problem getting properties of a column while using SQLOLEDB but everything was just fine with JET. Now in .NET evrything is working fine. A. ----- Original Message ----- From: "Beauchemin, Bob" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, May 05, 2002 10:53 PM Subject: Re: [DOTNET] ADOX in .NET There is no replacement yet for ADOX. You can use it through COM interop. Do you need to access (read) tables metadata or *define* tables, indexes, etc? To read metadata on a DBMS independent (OleDbConnection.GetOleDbSchemaTable) or SQL Server-specific (but standard) "select * from information_schema.xxx" basis is certainly possible. I'm almost certain (not knowing exactly what you are doing) that using DataSet doesn't get you what you want. Bob Beauchemin [EMAIL PROTECTED] -----Original Message----- From: Alireza Kheyrollahi [mailto:[EMAIL PROTECTED]] Sent: Sunday, May 05, 2002 2:17 PM To: [EMAIL PROTECTED] Subject: [DOTNET] ADOX in .NET ----- Original Message ----- From: Alireza Kheyrollahi To: dotnet discussion Sent: Sunday, May 05, 2002 10:03 PM Subject: ADOX in .NET Hi all, Does anyone know what has replaced ADOX in .NET? In my new project I need access to tables metadata (like field names, types, foreign keys and ....) Does DataSet class impements those functionalities? Thanks Ali You can read messages from the DOTNET archive, unsubscribe from DOTNET, or subscribe to other DevelopMentor lists at http://discuss.develop.com. You can read messages from the DOTNET archive, unsubscribe from DOTNET, or subscribe to other DevelopMentor lists at http://discuss.develop.com. You can read messages from the DOTNET archive, unsubscribe from DOTNET, or subscribe to other DevelopMentor lists at http://discuss.develop.com.
