Stringhe di connessione a Database per Web.Config

Database Access
<connectionstrings>
  <add name="AccessConnectionString"
   connectionString="Provider=Microsoft.Jet.OLEDB.4.0;
   Data Source=|DataDirectory|nomedb.mdb"
   providerName="System.Data.OleDb" />
</connectionstrings>

Database ODBC
<connectionstrings>
  <add name="ODBCConnectionString"
   connectionString="DSN=nomedsn;Uid=sa;Pwd=pwd;
   providerName="System.Data.Odbc” />
</connectionstrings>

Database SQLServer
<connectionstrings>
  <add name="OLEDBConnectionString"
   connectionString="Server=nomeserver;Integrated Security=SSPI;Database=nomedb;"
   providerName="System.Data.SqlClient" />
</connectionstrings>

Connessione ad Excel
<connectionstrings>
  <add name="OLEDBConnectionString"
   connectionString="Provider=Microsoft.Jet.OLEDB.4.0;
   Data Source= nomefile.xls; Extended Properties=Excel 8.0;"; />
</connectionstrings>

Connessione a file .csv
<connectionstrings>
  <add name="OLEDBConnectionString"
   connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=nomefile.csv;
   ExtendedProperties=""Text;HDR=Yes;FMT=Delimited""";/>
</connectionstrings>


Inoltre si possono utilizzare le connessioni native verso Oracle.