D'accord c'est la première méthode
public static ssortingng srConnectionSsortingng = "server=localhost;database=myDB; "+ " uid=sa;pwd=myPW;";
Et ceci est la deuxième méthode
public static ssortingng srConnectionSsortingng = "server=localhost;database=myDB; "+ " integrated security=SSPI;persist security info=False; Trusted_Connection=Yes;";
Y a-t-il des différences de performances ou d'autres différences entre ces deux strings de connection?
Voici ma class de connection sql toute suggestion?
using System; using System.Data.Sql; using System.Data.SqlClient; using System.Data; public static class DbConnection { public static ssortingng srConnectionSsortingng = "server=localhost; database=myDB; uid=sa; pwd=myPW;"; public static DataSet db_Select_Query(ssortingng strQuery) { DataSet dSet = new DataSet(); if (strQuery.Length < 5) return dSet; try { using (SqlConnection connection = new SqlConnection(srConnectionSsortingng)) { connection.Open(); using (SqlDataAdapter DA = new SqlDataAdapter(strQuery, connection)) { DA.Fill(dSet); } } return dSet; } catch { using (SqlConnection connection = new SqlConnection(srConnectionSsortingng)) { if (srConnectionSsortingng.IndexOf("select Id from tblAspErrors") != -1) { connection.Open(); strQuery = strQuery.Replace("'", "''"); using (SqlCommand command = new SqlCommand("insert into tblSqlErrors values ('" + strQuery + "')", connection)) { command.ExecuteNonQuery(); } } } return dSet; } } public static void db_Update_Delete_Query(ssortingng strQuery) { if (strQuery.Length < 5) return; try { using (SqlConnection connection = new SqlConnection(srConnectionSsortingng)) { connection.Open(); using (SqlCommand command = new SqlCommand(strQuery, connection)) { command.ExecuteNonQuery(); } } } catch { strQuery = strQuery.Replace("'", "''"); using (SqlConnection connection = new SqlConnection(srConnectionSsortingng)) { connection.Open(); using (SqlCommand command = new SqlCommand("insert into tblSqlErrors values ('" + strQuery + "')", connection)) { command.ExecuteNonQuery(); } } } }
}
La différence de performance est insignifiante qu'elle peut être ignorée. Les vérifications d'authentification sont
Pour info ces deux parameters sont les mêmes (utilisez l'un ou l'autre):
security embeddede = SSPI
Trusted_Connection = Oui