public SqlConnection CreateDbConnection(DatabaseConnectionName connectionName)
{
if (_connectionDict.TryGetValue(connectionName, out string connectionString))
{
return(new SqlConnection(connectionString));
}
throw new ArgumentNullException();
}
public IDbConnection CreateDbConnection(DatabaseConnectionName connectionName)
{
if (_connectionDict.TryGetValue(connectionName, out string connectionString))
{
return(new SqlConnection(connectionString));
}
throw new ArgumentNullException("DatabaseConnectionName key is not present in the dictionary");
}
public IDbConnection CreateDbConnection(DatabaseConnectionName connectionName)
{
string connectionString = null;
if (_connectionDict.TryGetValue(connectionName, out connectionString))
{
return(new SqlConnection(connectionString));
}
throw new ArgumentNullException("Não foi passado nenhuma conexao valida");
}
public IDbConnection CreateDbConnection(DatabaseConnectionName connectionName)
{
string connectionString = null;
if (_connectionDict.TryGetValue(connectionName, out connectionString))
{
return(new OracleConnection(connectionString));
}
throw new ArgumentNullException();
}
public AppConfiguration(DatabaseConnectionName databaseConnectionName)
{
var configurationBuilder = new ConfigurationBuilder();
var path = Path.Combine(Directory.GetCurrentDirectory(), "appsettings.json");
configurationBuilder.AddJsonFile(path, false);
var root = configurationBuilder.Build();
_connectionString = root.GetSection("ConnectionStrings")
.GetSection(databaseConnectionName.ToString()).Value;
_ = root.GetSection("ApplicationSettings");
}
public TItem GetItem <TItem>(string sql, DatabaseConnectionName DBname, TItem item, object parametrs = null)
{
string cacheKey = SetCacheKey(sql, parametrs);
if (cache.TryGetValue(cacheKey, out item))
{
return(item);
}
var con = connectionFactory.CreateConnection(DBname);
using (con)
{
con.Open();
item = con.QuerySingle <TItem>(sql, parametrs, commandType: CommandType.StoredProcedure);
cache.Set(cacheKey, item, TimeSpan.FromSeconds(60));
return(item);
}
}
protected DbConnection1RepositoryBase(IDbConnectionFactory dbConnectionFactory, DatabaseConnectionName connectionName)
{
_dbConnectionFactory = dbConnectionFactory;
_connectionName = connectionName;
}
