Changing the database of a typed DataSet after generation
-
Hello, Using Visual C# 2008, I have created a typed DataSet that connects to a SQL Server database. I would like to change it to connect to an ODBC data source (which in fact connects to the same SQL Server database). No need to be dynamic here. Is there a simple way to do that, or do I have to re-create everything from scratch ? Thanks, J-L
-
Hello, Using Visual C# 2008, I have created a typed DataSet that connects to a SQL Server database. I would like to change it to connect to an ODBC data source (which in fact connects to the same SQL Server database). No need to be dynamic here. Is there a simple way to do that, or do I have to re-create everything from scratch ? Thanks, J-L
Recreate everything from scratch. The classes involved are going to be different and there is stuff that the SQL Server classes supports that the ODBC classes do not. By using ODBC instead of the SQL Server dedicated classes you are also giving up the flexibility and performance benefits of the dedicated classes.
A guide to posting questions on CodeProject[^]
Dave Kreskowiak