//[TestMethod]
public void ConnectionTest()
{
using (GageStatsDBContext context = new GageStatsDBContext(new DbContextOptionsBuilder <GageStatsDBContext>().UseNpgsql(this.connectionstring, x => x.UseNetTopologySuite()).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 (GageStatsDBContext context = new GageStatsDBContext(new DbContextOptionsBuilder <GageStatsDBContext>().UseNpgsql(this.connectionstring, x => x.UseNetTopologySuite()).Options))
{
try
{
var testQuery = context.Agencies.ToList();
Assert.IsNotNull(testQuery, testQuery.Count.ToString());
}
catch (Exception ex)
{
Assert.IsTrue(false, ex.Message);
}
finally
{
}
}
}
public GageStatsAgent(GageStatsDBContext context, IHttpContextAccessor httpContextAccessor) : base(context)
{
this._messages = httpContextAccessor.HttpContext.Items;
this.context.ChangeTracker.QueryTrackingBehavior = QueryTrackingBehavior.NoTracking;
}
