static void Main(string[] args) { try { var q = new SqlConnectionStringBuilder() { DataSource = @"tcp:192.168.0.134, 1444", InitialCatalog = @"SCME_ResultsDB", IntegratedSecurity = false, UserID = "sa", Password = "******", ConnectTimeout = 15 }; var mssqlDbService = new MSSQLDbService(new SqlConnection(q.ToString())); var msSqlDbServiceProxy = new DatabaseProxy("SCME.CentralDatabase"); var centralProfiles = msSqlDbServiceProxy.GetProfilesDeepByMmeCode("MME007"); var centralProfiles1 = msSqlDbServiceProxy.GetProfilesDeepByMmeCode("MME007"); foreach (var i in centralProfiles1) { i.Version++; i.Timestamp = DateTime.Now; i.Key = Guid.NewGuid(); i.Id = 0; } var w = centralProfiles.Zip(centralProfiles1, (m, n) => new { oldP = m, newP = n }).ToList(); int qwe = 0; foreach (var i in w) { mssqlDbService.InsertUpdateProfile(i.oldP, i.newP, "MME007"); qwe++; } } catch (Exception ex) { File.WriteAllText("error.txt", ex.ToString()); } }
static void Main(string[] args) { string mmeCode = "MME013"; SQLiteDbService q = new SQLiteDbService(new SQLiteConnection(new SQLiteConnectionStringBuilder() { DataSource = "SCME_ResultsDB_Local.sqlite", DefaultTimeout = 15, SyncMode = SynchronizationModes.Full, JournalMode = SQLiteJournalModeEnum.Truncate, FailIfMissing = true }.ToString())); var w = new MSSQLDbService(new SqlConnection(new SqlConnectionStringBuilder() { DataSource = @"tcp:192.168.0.134, 1444", InitialCatalog = "SCME_ResultsDB", IntegratedSecurity = false, ConnectTimeout = 15, UserID = "sa", Password = "******" }.ToString())); if (w.GetMmeCodes().Count(m => m.Key == mmeCode) == 0) { w.InsertMmeCode(mmeCode); } var e = q.GetProfilesDeepByMmeCode(mmeCode); foreach (var i in e) { w.InsertUpdateProfile(null, i, mmeCode); } e = null; }
internal static void StartService() { Journal = new LogJournal(); try { var path = String.Format(Settings.Default.LogPathTemplate, DateTime.Now.ToString(CultureInfo.CurrentCulture).Replace('/', '_').Replace(':', '_')); if (!Path.IsPathRooted(path)) { path = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, path); } Journal.Open(path, true, true); } catch (Exception ex) { LogCriticalErrorMessage(ex); return; } // try // { // SQLDatabaseService dbForMigration = new SQLDatabaseService(SQLCentralDatabaseService.GetConnectionStringFromSettings(Settings.Default)); // dbForMigration.Open(); // dbForMigration.Migrate(); // dbForMigration.Close(); // } // catch (Exception ex) // { // Journal.AppendLog("Central DB SQL SERVER migration", LogJournalMessageType.Error, String.Format("Migrate database error: {0}", ex.Message)); // return; // } try { var service = new SQLCentralDatabaseService(Settings.Default); ms_ServiceHost = new ServiceHost(service); var behaviour = ms_ServiceHost.Description.Behaviors.Find <ServiceBehaviorAttribute>(); behaviour.InstanceContextMode = InstanceContextMode.Single; ms_ServiceHost.Open(); } catch (Exception ex) { Journal.AppendLog("SystemHost", LogJournalMessageType.Error, $"Error starting database service: {ex.Message}"); return; } try { MSSQLDbService mssqlDbService; _databaseServiceHost = new ServiceHost(mssqlDbService = new MSSQLDbService(new SqlConnection(new SqlConnectionStringBuilder() { DataSource = Settings.Default.DbPath, InitialCatalog = Settings.Default.DBName, IntegratedSecurity = Settings.Default.DBIntegratedSecurity, UserID = Settings.Default.DBUser, Password = Settings.Default.DBPassword, ConnectTimeout = 5 }.ToString()), false)); var behaviour = _databaseServiceHost.Description.Behaviors.Find <ServiceBehaviorAttribute>(); behaviour.InstanceContextMode = InstanceContextMode.Single; mssqlDbService.Migrate(); _databaseServiceHost.Open(); } catch (Exception ex) { Journal.AppendLog("SystemHost", LogJournalMessageType.Error, $"Error starting database service: {ex?.InnerException?.ToString() ?? ex.ToString()}"); return; } Journal.AppendLog("SystemHost", LogJournalMessageType.Info, $"SCME database service started on {_databaseServiceHost.BaseAddresses.FirstOrDefault()}"); }