// Creates the specified connection instance public DbConnection Create(DatabaseConnectionString connectionString) { DbProviderFactories.RegisterFactory("System.Data.SqlClient", System.Data.SqlClient.SqlClientFactory.Instance); var factory = DbProviderFactories.GetFactory(connectionString.Provider); var connection = factory.CreateConnection(); connection.ConnectionString = connectionString.ConnectionString; return(connection); }
public DatabaseConnectionString GetConnectionString(string databaseLogicalName) { var connectionStringSettings = new ConnectionStringSettings() { ConnectionString = @"Data Source=LAPTOP-FMJUMSNP\ELAD;Initial Catalog=PandologicDataBase;Integrated Security=True;", ProviderName = "System.Data.SqlClient" }; //string conString = ConfigurationExtensions.GetConnectionString(Configuration, databaseLogicalName); if (connectionStringSettings == null) { throw new ApplicationException(); } var result = new DatabaseConnectionString { ConnectionString = connectionStringSettings.ConnectionString, Provider = connectionStringSettings.ProviderName }; return(result); }