public void Execute() { #region "Creating and preparing the object to send to RavenDB" DataBaseBase dataBaseBase = new DatabaseSQLServer("Server=.\\SQLEXPRESS;Database=AdventureWorks2008;Trusted_Connection=True;", "http://localhost:8080", "Test"); dataBaseBase.LoadSchema(); ProcessingQueueReports reports = new ProcessingQueueReports("http://localhost:8080", "", "Teste", DataBaseBase.BancoDados.MSSQLSERVER, dataBaseBase); ReportConfiguration rc = new ReportConfiguration(); rc.Id = 1; rc.ReportName = "ReportTest"; rc.MainTable = new DSTable(1,"Test","schema"); rc.MainSchemaName = "schema"; rc.Columns = new List<DSColumn>{new DSColumn(),new DSColumn()}; reports.AddProcessReport(rc); #endregion using (var store = NewDocumentStore()) { using (var session = store.OpenSession()) { session.Store(reports); session.SaveChanges(); } } }
public void SendQueue() { ProcessingQueueReports processingQueueReports = new ProcessingQueueReports( base.ConnectionStringODDB, this.ConnectionStringRDB, base.DatabaseODDB, this._tipoBancoDados, this.DataBaseBase); processingQueueReports.LoadQueue(); var exceptDiference = processingQueueReports.ReportConfigurations.Except(this.ReportConfigurations); int count = exceptDiference.Count(); if (count > 0) { foreach (var reportConfiguration in exceptDiference) { this.ReportConfigurations.Add(reportConfiguration); } } using (var documentStore = new DocumentStore()) { documentStore.Url = ConnectionStringODDB; documentStore.Initialize(); documentStore.DatabaseCommands.EnsureDatabaseExists(DatabaseODDB); using (IDocumentSession session = documentStore.OpenSession(DatabaseODDB)) { var existingInDatabase = session.Query<ProcessingQueueReports>(); if (existingInDatabase != null) { foreach (var dataBaseBase in existingInDatabase) { session.Delete(dataBaseBase); session.SaveChanges(); } } } } base.SaveToRavenDB(); }