private IDbQueryBase BuildDbQueyBase()
{
ConnectionBuilder connectionBuilder = new ConnectionBuilder(SqlClientFactory.Instance);
this.connection = connectionBuilder.BuildConnection(connectionString);
this.connection.Open();
return(new DbQueryBase(this.connection, databaseDialect));
}
private IDbConnection BuildConnection()
{
string connectionString = MySqlServer.Instance.GetConnectionString().Replace("Protocol=pipe;", "");
ConnectionBuilder connectionBuilder = new ConnectionBuilder(MySqlClientFactory.Instance);
IDbConnection connection = connectionBuilder.BuildConnection(connectionString);
connection.Open();
return(connection);
}
private IDbQueryBase BuildDbQueryBase()
{
ConnectionBuilder connectionBuilder = new ConnectionBuilder(SqlClientFactory.Instance, connectionString);
this.dbConnection = connectionBuilder.BuildConnection();
return(new DbQueryBase(this.dbConnection, new AbstractionOptions
{
AutoCloseConnection = false,
Dialect = databaseDialect,
DialectParameterIdentifier = '@',
QueryParameterIdentifier = '@',
SortQueryParameters = false,
}));;
}
public void ConnectionBuilder_GivenConnectionString_ShouldReturnConnectionUpdatedConnectionWithPoolNoMARS()
{
//------------Setup for test--------------------------
var connectionBuilder = new ConnectionBuilder();
var source = new DbSource();
source.Server = "localhost";
source.ServerType = Common.Interfaces.Core.DynamicServices.enSourceType.SqlDatabase;
source.AuthenticationType = AuthenticationType.Windows;
//------------Execute Test---------------------------
var connection = connectionBuilder.BuildConnection(source.ConnectionString);
//------------Assert Results-------------------------
Assert.IsNotNull(connection);
Assert.IsInstanceOfType(connection, typeof(ISqlConnection));
}
internal static IServiceCollection ConfigureDataServices(this IServiceCollection serviceCollection)
{
return(serviceCollection
.AddTransient <CassandraSettings>(sp =>
{
var store = sp.GetRequiredService <IStringKeyValueStore>();
return new CassandraSettings
{
TransactionsReadConsistencyLevel = (ConsistencyLevel)Enum.Parse(typeof(ConsistencyLevel), store.GetAndConvertValue <string>("CassandraConfiguration/TransactionsReadConsistencyLevel"))
};
})
.AddSingleton <CassandraConfiguration>(sp =>
{
var store = sp.GetRequiredService <IStringKeyValueStore>();
return new CassandraConfiguration
{
ContactPoints = store.GetAndConvertValue <string>("CassandraConfiguration/ContactPoints").Split(','),
Keyspace = store.GetAndConvertValue <string>("CassandraConfiguration/Keyspace"),
ReplicationParameters = JsonConvert.DeserializeObject <Dictionary <string, string> >(store.GetAndConvertValue <string>("CassandraConfiguration/ReplicationParameters"))
};
})
.AddSingleton <IConnection>(sp => ConnectionBuilder.BuildConnection(sp.GetRequiredService <CassandraConfiguration>()))
.AddTransient <ITransactionsRepository, TransactionsRepository>());
}
public DbConnectionService(DbEnum dbType)
{
var builder = new ConnectionBuilder();
_conn = builder.BuildConnection(dbType);
}
