public async Task <ActionResult> OracleConnectionManager()
{
try
{
OracleConnectionManager orcon = new OracleConnectionManager(new OracleConnectionString(oracleconStr));
ControlFlow.DefaultDbConnection = orcon;
CreateTableTask.Create(orcon, "ATABLE1", new List <TableColumn>()
{
new TableColumn("VCH_DIST_NAME", "varchar2(20)", allowNulls: true),
new TableColumn("INT_DIST_ID", "varchar2(20)", allowNulls: true)
});
CsvSource <string[]> source = new CsvSource <string[]>("t_covid_care_center.csv");
RowTransformation <string[], MyData> row = new RowTransformation <string[], MyData>
(
input => new MyData()
{
VCH_DIST_NAME = input[1], INT_DIST_ID = input[2]
}
);
DbDestination <MyData> destOralce = new DbDestination <MyData>(orcon, "ATABLE1");
source.LinkTo(row);
row.LinkTo(destOralce);
await source.ExecuteAsync();
destOralce.Wait();
return(View());
}
catch (Exception ex)
{
throw ex;
}
}
