public DbDirectoryAccountService()
{
#if NET45
string url = ConfigurationManager.AppSettings["DirectoryAccountService.RootEntryPath"];
if (String.IsNullOrEmpty(url))
{
throw new KeyNotFoundException("The configuration key is not found in the config file, please add 'DirectoryAccountService.RootEntryPath' to the appSettings config.");
}
connectionName = url.Replace("DB://", "");
dbContext = new DbDirectoryAccountContext(connectionName);
#endif
#if NETCORE
var dir = Directory.GetCurrentDirectory();
var builder = new ConfigurationBuilder()
.SetBasePath(dir)
.AddJsonFile("appsettings.json", optional: true, reloadOnChange: true);
var configuration = builder.Build();
connectionName = configuration.GetValue <string>("DirectoryAccountService:connectionString");
connectionString = configuration.GetConnectionString(connectionName);
var optionsBuilder = new DbContextOptionsBuilder <DbDirectoryAccountContext>();
optionsBuilder.UseSqlServer(connectionString);
dbContext = new DbDirectoryAccountContext(optionsBuilder.Options);
#endif
}
public DbDirectoryAccountService(string connectionName) : base(connectionName)
{
this.connectionName = connectionName;
#if NET45
dbContext = new DbDirectoryAccountContext(connectionName);
#endif
#if NETCORE
var dir = Directory.GetCurrentDirectory();
var builder = new ConfigurationBuilder()
.SetBasePath(dir)
.AddJsonFile("appsettings.json", optional: true, reloadOnChange: true);
var configuration = builder.Build();
var optionsBuilder = new DbContextOptionsBuilder <DbDirectoryAccountContext>();
connectionString = configuration.GetConnectionString(connectionName);
optionsBuilder.UseSqlServer(connectionString);
dbContext = new DbDirectoryAccountContext(optionsBuilder.Options);
#endif
}
public override void Open()
{
if (dbContext == null)
{
#if NET45
dbContext = new DbDirectoryAccountContext(connectionName);
#endif
#if NETCORE
var optionsBuilder = new DbContextOptionsBuilder <DbDirectoryAccountContext>();
optionsBuilder.UseSqlServer(connectionString);
dbContext = new DbDirectoryAccountContext(optionsBuilder.Options);
#endif
}
else
{
#if NET45
dbContext.Database.Connection.Open();
#endif
#if NETCORE
dbContext.Database.OpenConnectionAsync();
#endif
}
}
public DbDirectoryAccountService(DbContextOptions options)
{
dbContext = new DbDirectoryAccountContext(options);
}