public static void TestExtractStates(string oracleWebUatConnString)
{
Console.WriteLine("Test - Extarcting States");
StateExtract regionExtract = new StateExtract();
List <StateForeign> statesForeign = regionExtract.ExtractStatesForeign(oracleWebUatConnString);
Console.WriteLine(statesForeign);
}
public async Task ImportForeignStates(WRLDCWarehouseDbContext _context, ILogger _log, string oracleConnStr, EntityWriteOption opt)
{
StateExtract stateExtract = new StateExtract();
List <StateForeign> stateForeigns = stateExtract.ExtractStatesForeign(oracleConnStr);
LoadState loadState = new LoadState();
foreach (StateForeign stateForeign in stateForeigns)
{
State insertedState = await loadState.LoadSingleAsync(_context, _log, stateForeign, opt);
}
}