Moving to Provider Factories RRS feed

  • Question

  • Good day,


    We have a large database application that was written in VS2005 with C# and back-ended with SQL Server 2005. There a few DataReaders and custom SQL statements, but the vast majority of the database access uses DataSets/DataTables and the TableAdapters that the Data Source Configuration wizard generates.


    We are researching deploying the application against other backends, and have been checking out Provider Factories and the Enterpise Library's Data Access Application Block, which uses the factories. As I understand it, TableAdapters can only be generated with database-specific adapters, connections and commands, so they are probably not appropriate for a backend-flexible app.


    For the vast majority of our data access, the SQL will be the same regardless of the backend. Do the Provider Factories or the Data Access Application Block have any SQL building/generating tools (the examples seem oriented toward stored procedures)? It seems a step backward to go this model and have to hand-code all the SQL!


    Thanks in advance for any feedback...

    Monday, March 17, 2008 3:36 PM


  • The Enterprise Manager can help you with SQL Server and Oracle but you still need to write code for IBMs DB2, Informix. MySQL, PostgreSQL and Sybase.  The reason DML(data manipulation language) is similar but different in all RDBMS.


    Monday, March 17, 2008 11:56 PM