public void LumenCSVReadValuesAndDeleteIntoDest()
{
DBConnectionDelegate destinationConnection = new MSSQL2005_DBConnection("FGA_JMOINS1");
DataSet ds = new DataSet("PTF_PROXY_4DELETE");
List <string> columns = new List <string>();
using (var reader = new CsvReader(new StreamReader(@"Delete_PROXY1.csv"), true, ';'))
{
CsvDataAdapter adapter = new CsvDataAdapter(reader);
int nbReadLines = adapter.Fill(ds, "#PTF_PROXY_CLAUSE");
DataTable dt = ds.Tables["#PTF_PROXY_CLAUSE"];
destinationConnection.Delete(new DatabaseTable("dbo", "PTF_PROXY"), dt);
}
}
