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();
        }
Пример #2
0
        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();
        }