private static IEnumerable <WhiteLists> GetData(wt.WhiteListContext context, IMapper mapper) { var whiteLists = context .Whitelists .Include(x => x.Source) .ToList(); var wl2 = whiteLists .Select(x => mapper.Map <WhiteLists>(x)) .ToList(); context.Dispose(); return(wl2); }
internal static wt.WhiteListContext CreateContext(Sql sql, IWebHostEnvironment env) { DbContextOptionsBuilder <wt.WhiteListContext> op = new DbContextOptionsBuilder <wt.WhiteListContext>(); sql.UseSqlService(op); if (env == null || env.IsDevelopment()) { op .UseLoggerFactory(LoggerFactory.Create(builder => { builder.AddDebug().AddConsole(); })) .EnableSensitiveDataLogging(); } var context = new wt.WhiteListContext(op.Options); return(context); }