using (MySqlConnection conn = new MySqlConnection(connectionString))
{
try
{
conn.Open();
//tran = conn.BeginTransaction();
MySqlBulkLoader bulk = new MySqlBulkLoader(conn)
{
FieldTerminator = ",",
FieldQuotationCharacter = '"',
EscapeCharacter = '"',
LineTerminator = @"\n",
FileName = filePath,
NumberOfLinesToSkip = 1,
TableName = "ips"
};
//bulk.Columns.AddRange(table.Columns.Cast<DataColumn>().Select(colum => colum.ColumnName).ToArray());
int count= bulk.Load();
Console.WriteLine(count + " lines uploaded.");
Console.WriteLine("time cast" + sw.Elapsed);
// tran.Commit();
}
{
try
{
conn.Open();
//tran = conn.BeginTransaction();
MySqlBulkLoader bulk = new MySqlBulkLoader(conn)
{
FieldTerminator = ",",
FieldQuotationCharacter = '"',
EscapeCharacter = '"',
LineTerminator = @"\n",
FileName = filePath,
NumberOfLinesToSkip = 1,
TableName = "ips"
};
//bulk.Columns.AddRange(table.Columns.Cast<DataColumn>().Select(colum => colum.ColumnName).ToArray());
int count= bulk.Load();
Console.WriteLine(count + " lines uploaded.");
Console.WriteLine("time cast" + sw.Elapsed);
// tran.Commit();
}