protected override void RunActualProcess() { const string filename = @"U:\SimZukunft\RawDataForMerging\stadtprofil_15min_auflösung.csv"; const string profilename = "01-bkwlast"; var bkwRaw = ZZ_ProfileImportHelper.ReadCSV(filename, profilename); Services.SqlConnection.RecreateTable <BkwProfile>(Stage.ProfileImport, Constants.PresentSlice); var bkp = new BkwProfile { Profile = bkwRaw, Name = "BKW übergabe" }; var db = Services.SqlConnection.GetDatabaseConnection(Stage.ProfileImport, Constants.PresentSlice).Database; db.BeginTransaction(); db.Save(bkp); db.CompleteTransaction(); }
protected override void RunActualProcess() { string fn = CombineForRaw("stadtprofil_15min_auflösung.csv"); const string profilename = "01-bkwlast"; var bkwRaw = ZZ_ProfileImportHelper.ReadCSV(fn, profilename); JsonSerializableProfile jsp = new JsonSerializableProfile(bkwRaw); var bkp = new BkwProfile { Profile = jsp, Name = "BKW übergabe" }; var db = Services.SqlConnectionPreparer.GetDatabaseConnection(Stage.Raw, Constants.PresentSlice); db.RecreateTable <BkwProfile>(); db.BeginTransaction(); db.Save(bkp); db.CompleteTransaction(); }