private void Connect(SqlConnection sqlConnection) { try { sqlConnection.Open(); } catch (Exception e) { OnDbConnection?.Invoke(this, new DbConnectionEventArgs(DateTime.Now, e.Message)); OnDbConnection?.Invoke(this, new DbConnectionEventArgs(DateTime.Now, sqlConnection.State.ToString())); } }
public DbManager() { ClientsSqlDataAdapter = new SqlDataAdapter(); DepositsSqlDataAdapter = new SqlDataAdapter(); CreditsSqlDataAdapter = new SqlDataAdapter(); PhysDataTable = new DataTable(); LegalDataTable = new DataTable(); DepositsDataTable = new DataTable(); CreditsDataTable = new DataTable(); var connectionStringBuilder = new SqlConnectionStringBuilder { DataSource = @"(localdb)\MSSQLLocalDB", InitialCatalog = "Bank", IntegratedSecurity = true, Pooling = false }; OnDbConnection?.Invoke(this, new DbConnectionEventArgs(DateTime.Now, $"Connection string: { connectionStringBuilder.ConnectionString}")); commonSqlConnection = new SqlConnection(connectionStringBuilder.ConnectionString); }