internal static DataContextOptions CreateOptions(IConnectionSetting setting) { if (setting == null) { throw new ArgumentNullException(nameof(setting)); } Type type; string connection = setting.ConnectionString; type = Type.GetType(setting.ProviderName, true); if (type == null) { return(null); } DatabaseProvider dataBase = (DatabaseProvider)Activator.CreateInstance(type, setting.Name, setting.ConfigParam) as DatabaseProvider; if (dataBase == null) { throw new LightDataException(string.Format(SR.TypeIsNotDatabaseType, type.FullName)); } DataContextOptions contextOptions = new DataContextOptions() { Connection = connection, Database = dataBase }; return(contextOptions); }
public ConnectionString(IApplicationSettings appSetting, IConnectionSetting con) { try { string path = appSetting.FileLocation + appSetting.FileName; string[] lines = File.ReadAllLines(path, Encoding.UTF8); if (lines.Length > 0) { string cridential = ""; foreach (string res in lines) { cridential = cridential + res.ToString(); } cridential = "User " + cridential; this.DatabaseConnection = con.DefaultConnection; // cridential + con.DefaultConnection; } } catch { this.DatabaseConnection = con.DefaultConnection; //string error = ex.Message.ToString(); } }
public StockService(IConnectionSetting connection) { var client = new MongoClient(connection.ConnectionString); var database = client.GetDatabase(connection.DatabaseName); _stock = database.GetCollection <SNP500>("SNP500"); Populate().ConfigureAwait(false).GetAwaiter().GetResult(); }
public void ExecuteNonQuery(string queryString, IConnectionSetting connectionSetting) { using (SqlConnection con = new SqlConnection(connectionSetting.GetDataSourcePath())) { SqlCommand command = new SqlCommand(queryString, con); command.Connection.Open(); command.ExecuteNonQuery(); } }
public ConnectionFactorySqlite( IConnectionSetting setting, ISqlDialect dialect = null) { _setting = setting; if (dialect != null) { dialect.Init(SqlDialectEnum.Sqlite); } }
public ConnectionFactorySqlite( IAppLogger logger, IConnectionSetting setting, ISqlDialect dialect = null) { _logger = logger; _setting = setting; if (dialect != null) { dialect.Init(SqlDialectEnum.Sqlite); } }
public ConnectionFactoryOracle( IConnectionSetting setting, ISqlDialect dialect = null) { _setting = setting ?? throw new ArgumentNullException(nameof(setting)); if (string.IsNullOrEmpty(_setting.ConnectionString)) { throw new ArgumentOutOfRangeException(nameof(setting), "Connection string should not be null or empty"); } if (dialect != null) { dialect.Init(SqlDialectEnum.Oracle); } }
public MqttQueue(string name, IConnectionSetting connectionSetting) { if (string.IsNullOrEmpty(name)) { throw new ArgumentNullException(nameof(name)); } this.Name = name.Trim(); this.ConnectionSetting = connectionSetting; _client = Factory.CreateManagedMqttClient(); _subscribers = new Dictionary <string, MqttSubscriber>(); _client.UseApplicationMessageReceivedHandler(OnHandleAsync); }
public ConnectionFactoryPostgreSQL( IAppLogger logger, IConnectionSetting setting, ISqlDialect dialect = null) { _logger = logger ?? throw new ArgumentNullException(nameof(logger)); _setting = setting ?? throw new ArgumentNullException(nameof(setting)); if (string.IsNullOrEmpty(_setting.ConnectionString)) { throw new ArgumentOutOfRangeException(nameof(setting), "Connection string should not be null or empty"); } if (dialect != null) { dialect.Init(SqlDialectEnum.PostgreSql); } }
public void ExecuteStoredProcedure(IStoredProcedureNonQuery procedure, IConnectionSetting connectionSetting) { using (SqlConnection connection = new SqlConnection(connectionSetting.GetDataSourcePath())) { using (SqlCommand command = new SqlCommand(procedure.StoredProcedureName, connection)) { command.CommandType = CommandType.StoredProcedure; foreach (var parameter in procedure.Parameters) { command.Parameters.AddWithValue(parameter.Key, parameter.Value); } connection.Open(); command.ExecuteNonQuery(); } } }
internal static DataContextSetting CreateSetting(IConnectionSetting setting, bool throwOnError) { if (setting == null) { throw new ArgumentNullException(nameof(setting)); } Type type; string connection = setting.ConnectionString; type = Type.GetType(setting.ProviderName, throwOnError); if (type == null) { return(null); } if (!throwOnError) { Type dataBaseType = typeof(DatabaseProvider); if (!type.IsInherit(dataBaseType)) { return(null); } } DatabaseProvider dataBase = Activator.CreateInstance(type, setting.Name, setting.ConfigParam) as DatabaseProvider; if (dataBase == null) { if (!throwOnError) { return(null); } else { throw new LightDataException(string.Format(SR.TypeIsNotDatabaseType, type.FullName)); } } //dataBase.SetExtendParams(setting.ConfigParam); DataContextSetting context = new DataContextSetting(connection, dataBase); return(context); }
public CourseEnrollDal(IApplicationSettings appSetting, IConnectionSetting con) { this.con = new ConnectionString(appSetting, con); }
protected internal virtual void DatabaseExistsTest(IConnectionSetting connectionSetting, bool expectedValue) { Assert.AreEqual(expectedValue, this.GetDatabaseManager(connectionSetting).DatabaseExists(connectionSetting.ConnectionString)); }
protected internal virtual DatabaseManager GetDatabaseManager(IConnectionSetting connectionSetting) { return((DatabaseManager)this.DatabaseManagerFactory.Create(connectionSetting.ProviderName)); }
public ConnectionSettingValues(IConnectionSetting connectionSetting) { _connectionSetting = connectionSetting; _dictionary = new Dictionary <string, string>(StringComparer.OrdinalIgnoreCase); }
public void PostSqlNonQuery(IStoredProcedureNonQuery storedProcedure, IConnectionSetting connectionSetting) { new SqlExecutor().ExecuteStoredProcedure(storedProcedure, connectionSetting); }
public DataSet GetSqlDataSet(IStoredProcedureQueryWithResults storedProcedure, IConnectionSetting connectionSetting) { return(new SqlExecutor().ExecuteStoredProcedure(storedProcedure, connectionSetting)); }
public ProductContext(IConnectionSetting connectionSetting, IProductContextHelper productContextHelper) { this.connectionSetting = connectionSetting; this.productContextHelper = productContextHelper; }
public DataSet ExecuteStoredProcedure(IStoredProcedureQueryWithResults procedure, IConnectionSetting connectionSetting) { DataSet dataset = new DataSet(); using (SqlConnection con = new SqlConnection(connectionSetting.GetDataSourcePath())) { SqlCommand command = new SqlCommand(procedure.StoredProcedureName, con); foreach (var parameter in procedure.Parameters) { command.Parameters.AddWithValue(parameter.Key, parameter.Value); } command.CommandType = CommandType.StoredProcedure; SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = command; da.Fill(dataset); return(dataset); } }
public StudentDal(IApplicationSettings appSetting, IConnectionSetting con) { this.con = new ConnectionString(appSetting, con); }
public AuthorCourseDal(IApplicationSettings appSetting, IConnectionSetting con) { this.con = new ConnectionString(appSetting, con); }