private static IDbConnectionProvider InitConnectionProvider(DirectoryInfo directory, QueueName queueName, IDiagnosticService diagnosticService) { var myDiagnosticService = diagnosticService ?? Diagnostics.DiagnosticService.DefaultInstance; var dbPath = Path.Combine(directory.FullName, queueName + ".db"); #if NET452 || NET461 var connectionStringSettings = new ConnectionStringSettings { Name = dbPath, ConnectionString = "Data Source=" + dbPath + "; Version=3; BinaryGUID=False; DateTimeKind=Utc", ProviderName = "System.Data.SQLite" }; #endif #if NETSTANDARD2_0 SQLiteProviderFactory.Register(); var connectionStringSettings = new ConnectionStringSettings { Name = dbPath, ConnectionString = "Data Source=" + dbPath + "", ProviderName = SQLiteProviderFactory.InvariantName }; #endif return(new SingletonConnectionProvider(connectionStringSettings, myDiagnosticService)); }
private static IDbConnectionProvider InitConnectionProvider(DirectoryInfo directory, IDiagnosticService diagnosticService) { var myDiagnosticsService = diagnosticService ?? Diagnostics.DiagnosticService.DefaultInstance; if (directory == null) { var appDomainDirectory = AppDomain.CurrentDomain.BaseDirectory; directory = new DirectoryInfo(Path.Combine(appDomainDirectory, "platibus", "subscriptions")); } directory.Refresh(); if (!directory.Exists) { directory.Create(); } var dbPath = Path.Combine(directory.FullName, "subscriptions.db"); #if NET452 || NET461 var connectionStringSettings = new ConnectionStringSettings { Name = dbPath, ConnectionString = "Data Source=" + dbPath + "; Version=3; BinaryGUID=False; DateTimeKind=Utc", ProviderName = "System.Data.SQLite" }; #endif #if NETSTANDARD2_0 SQLiteProviderFactory.Register(); var connectionStringSettings = new ConnectionStringSettings { Name = dbPath, ConnectionString = "Data Source=" + dbPath + "", ProviderName = SQLiteProviderFactory.InvariantName }; #endif return(new SingletonConnectionProvider(connectionStringSettings, myDiagnosticsService)); }