//[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; }