private static void CreateDatabasesIfNotExists(IHost host)
{
using (var scope = host.Services.CreateScope())
{
var services = scope.ServiceProvider;
Database1Context context1 = null;
Database2Context context2 = null;
try
{
context1 = services.GetRequiredService <Database1Context>();
Database1Initializer.Initialize(context1);
}
catch (Exception ex)
{
var logger = services.GetRequiredService <ILogger <Program> >();
logger.LogError(ex, "An error occurred creating the DB.");
}
try
{
context2 = services.GetRequiredService <Database2Context>();
Database2Initializer.Initialize(context1, context2);
}
catch (Exception ex)
{
var logger = services.GetRequiredService <ILogger <Program> >();
logger.LogError(ex, "An error occurred creating the DB.");
}
}
}
protected override void OpenDataConnection()
{
var settings =
ConfigurationManager.ConnectionStrings;
var connString = settings["Zad2.Properties.Settings.Database1ConnectionString"].ConnectionString;
var connection = new SqlCeConnection(connString);
connection.Open();
_context = new Database1Context(connection);
}
protected override void OpenDataConnection()
{
var settings =
ConfigurationManager.ConnectionStrings;
var connString = settings["Zad2.Properties.Settings.Database1ConnectionString"].ConnectionString;
var connection = new SqlCeConnection(connString);
connection.Open();
_context = new Database1Context(connection);
}
public int GetResultFromData()
{
var settings =
ConfigurationManager.ConnectionStrings;
var connString = settings["Zad2.Properties.Settings.Database1ConnectionString"].ConnectionString;
var connection = new SqlCeConnection(connString);
connection.Open();
using (var context = new Database1Context(connection))
{
return context.Numbers.Select(row => row.Number1).Sum();
}
}
public int GetResultFromData()
{
var settings =
ConfigurationManager.ConnectionStrings;
var connString = settings["Zad2.Properties.Settings.Database1ConnectionString"].ConnectionString;
var connection = new SqlCeConnection(connString);
connection.Open();
using (var context = new Database1Context(connection))
{
return(context.Numbers.Select(row => row.Number1).Sum());
}
}
public Departments1Controller(Database1Context context)
{
_context = context;
}
public EmpT2Controller(Database1Context db, IEmployeeRepository emp, IDepartmentRepository dep)
{
DB = db;
empRepo = emp;
departmentRepo = dep;
}
public DepartmentRepository(Database1Context context)
{
Context = context;
}
public DepartmentsController(Database1Context db, IDepartmentRepository dep)
{
DB = db;
departmentRepo = dep;
}
public EmployeeService(Database1Context db, IEmployeeRepository empRepo)
{
DB = db;
EmpRepo = empRepo;
}
public EmployeeRepository(Database1Context context)
{
Context = context;
}
