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); }