Using the designer to integrate more than one DataProvider into an application. RRS feed

  • Question

  • I created an application using the designer for creating DataSource, DataSet, TableAdapter including INSERT, UPDATE, and DELETE logic on an Oracle 10g database. I tried the same for accessing a SQL Express database.

    My question: Is it possible to integrate both Oracle and SQL Server DataProvider by using the VS designer in order to avoid diving into the depths of ADO.NET to program all things yourself?

    Only the connectionString definition should decide which database type the application will connect to.


    Friday, October 15, 2010 6:45 AM