public static void Update(Dictionary <string, object> values, string tableName, string whereStatement, SqlConnection connection, SqlTransaction transaction) { string sql = SqlGeneralAccess.GetSqlUpdateStatement(values.Keys.ToList(), tableName, whereStatement); IList <SqlParameter> parameters = SqlGeneralAccess.GetParemeters(values); SqlRequest sqlRequest = new SqlRequest(sql, parameters); Update(sqlRequest, connection, transaction); }
public static DataTable Select(Dictionary <string, object> values, string tableName, string whereStatement, string connectionString) { string sql = SqlGeneralAccess.GetSqlSelectStatement(values.Keys.ToList(), tableName, whereStatement); SqlConnection connection = new SqlConnection(connectionString); SqlCommand command = new SqlCommand(sql, connection); SqlDataAdapter adapter = new SqlDataAdapter(command); DataTable table = new DataTable(); adapter.Fill(table); return(table); }