public WaterUseServiceAgent(WaterUseDBContext context) : base(context)
{
this.IncludePermittedWithdrawals = false;
//optimize query for disconnected databases.
this.context.ChangeTracker.QueryTrackingBehavior = QueryTrackingBehavior.NoTracking;
}
public void ConnectionTest()
{
using (WaterUseDBContext context = new WaterUseDBContext(new DbContextOptionsBuilder <WaterUseDBContext>().UseNpgsql(this.connectionstring).Options))
{
try
{
if (!(context.GetService <IDatabaseCreator>() as RelationalDatabaseCreator).Exists())
{
throw new Exception("db does ont exist");
}
}
catch (Exception ex)
{
Assert.IsTrue(false, ex.Message);
}
}
}
public void QueryTest()
{
using (WaterUseDBContext context = new WaterUseDBContext(new DbContextOptionsBuilder <WaterUseDBContext>().UseNpgsql(this.connectionstring).Options))
{
try
{
var testQuery = context.Roles.ToList();
Assert.IsNotNull(testQuery, testQuery.Count.ToString());
}
catch (Exception ex)
{
Assert.IsTrue(false, ex.Message);
}
finally
{
}
}
}
