private static void testETL()
{
clsMAST_INSR_POLICY_TB clstb = new clsMAST_INSR_POLICY_TB();
clsMAST_INSR_POLICY_TB_MIRROR clstb_m = new clsMAST_INSR_POLICY_TB_MIRROR();
clsMAST_INSR_POLICY_TB_MIRROR.TableClear();
DataTable dt = clstb.Select();
//DatabaseLayer.DataBaseConnection.SqlConnection_.Close();
//DatabaseLayer.DataBaseConnection.SqlConnection_ = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=C:\project\InsuranceHedgeProject\InsruranceHedge_sln\InsuranceHedge\HedgeSystemAsh.mdf;Integrated Security=True");
int i = 1;
foreach (DataRow dr in dt.Select())
{
clsMAST_INSR_POLICY_TB_MIRROR.Create(dr).Insert();
Console.WriteLine(i);
i = i + 1;
}
}
