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