Guest User

Untitled

a guest
Jul 21st, 2018
97
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.80 KB | None | 0 0
  1. private static void ConfigureServices(IServiceCollection serviceCollection)
  2. {
  3. serviceCollection.AddSingleton(new LoggerFactory()
  4. .AddSerilog());
  5. serviceCollection.AddLogging();
  6. serviceCollection.AddDbContext<Spiderdb>(options => options.UseSqlite("Data Source=(localdb)\ProjectsV13;Initial Catalog=SpiderDB1;Integrated Security=True"));
  7.  
  8. // Initialize serilog logger
  9. Log.Logger = new LoggerConfiguration()
  10. .WriteTo.File("app.log")
  11. .MinimumLevel.Debug()
  12. .Enrich.FromLogContext()
  13. .CreateLogger();
  14.  
  15. serviceCollection.AddTransient<App>();
  16. }
  17.  
  18. class App
  19. {
  20.  
  21. private readonly ILogger<App> _logger;
  22. private readonly Spiderdb _spiderDb;
  23.  
  24.  
  25. public App(ILogger<App> logger, Spiderdb context)
  26. {
  27. _logger = logger;
  28. _spiderDb = context;
  29. }
  30.  
  31. public async void RunAsync()
  32. {
  33. _logger.LogInformation("Starting App");
  34.  
  35. using (_spiderDb)
  36. {
  37. var x = await _spiderDb.ProxyServersProviders.ToListAsync();
  38. }
  39. }
  40.  
  41. }
  42.  
  43. 2018-07-21 06:42:39.004 +01:00 [DBG] An 'IServiceProvider' was created for
  44. internal use by Entity Framework.
  45. 2018-07-21 06:42:39.101 +01:00 [INF] Starting App
  46. 2018-07-21 06:42:40.160 +01:00 [INF] Entity Framework Core 2.1.1-rtm-30846
  47. initialized 'Spiderdb' using provider
  48. 'Microsoft.EntityFrameworkCore.SqlServer' with options: None
  49. 2018-07-21 06:42:40.356 +01:00 [DBG] Compiling query model:
  50. 'from ProxyServersProvider <generated>_0 in DbSet<ProxyServersProvider>
  51. select [<generated>_0]'
  52. 2018-07-21 06:42:40.413 +01:00 [DBG] Optimized query model:
  53. 'from ProxyServersProvider <generated>_0 in DbSet<ProxyServersProvider>
  54. select [<generated>_0]'
  55. 2018-07-21 06:42:40.691 +01:00 [DBG] (QueryContext queryContext) =>
  56. IAsyncEnumerable<ProxyServersProvider> _InterceptExceptions(
  57. source: IAsyncEnumerable<ProxyServersProvider> _TrackEntities(
  58. results: IAsyncEnumerable<ProxyServersProvider> _ShapedQuery(
  59. queryContext: queryContext,
  60. shaperCommandContext: SelectExpression:
  61. SELECT [p].[Id], [p].[DailyReqCount], [p].[DailyReqLimit], [p].
  62. [FailedCount], [p].[FirstReqToday], [p].[IsRestAPI], [p].[LastReq], [p].[URL]
  63. FROM [ProxyServersProviders] AS [p],
  64. shaper: UnbufferedEntityShaper<ProxyServersProvider>),
  65. queryContext: queryContext,
  66. entityTrackingInfos: { itemType: ProxyServersProvider },
  67. entityAccessors: List<Func<ProxyServersProvider, object>>
  68. {
  69. Func<ProxyServersProvider, ProxyServersProvider>,
  70. }
  71. ),
  72. contextType: Spider.EF.Spiderdb,
  73. logger: DiagnosticsLogger<Query>,
  74. queryContext: queryContext)
  75. 2018-07-21 06:42:40.814 +01:00 [DBG] Opening connection to database
  76. 'SpiderDB1' on server '(localdb)ProjectsV13'.
Add Comment
Please, Sign In to add comment