none
DB and framework RRS feed

  • 問題

  •  

    Can we have a table listing the BEST solution of DB Connection string

    and getting data for each version of framework and databses?

    use Oledb? SQlConnection? ODBC? what's the BEST solution?

     

                                        Oracle                 |                 MS SQL  

    ==============================================

    Framework 1.0                 ?                   |                      ?

    Framework 1.1                 ?                   |                      ?

    Framework 2.0                  ?                  |                      ?

     

    Please have some code for the ?

    thanks alot

    2006年9月8日 上午 03:11

解答

  • SQL Server: always System.Data.SqlClient

    Oracle:

    • .NET 1.0, developer must download and install Oracle Provider, namespace: Microsoft.Data.Oracle
    • .NET 1.1 or later, Oracle provider already bulit-in, namespace: System.Data.Oracle
    • Oracle also provide a Provider for .NET to connect to Oracle Database
    • Oracle Client v8.1.7 or later is required.
    2006年9月8日 上午 04:31
    版主