public SQLiteCommand GetInsertCommand(SQLiteConnection connection, CsvReader reader)
{
var insertCmd = connection.CreateCommand();
insertCmd.CommandText = "INSERT INTO {0} (";
for (var i = 0; i <= reader.FieldCount; i++)
insertCmd.CommandText += (i > 0 ? "," : "") + reader.GetName(i);
insertCmd.CommandText = ") VALUES (";
for (var i = 0; i <= reader.FieldCount; i++)
{
insertCmd.CommandText += i > 0 ? ", :" + i : ":" + i;
insertCmd.Parameters.Add(i.ToString(), System.Data.DbType.String);
}
return insertCmd;
}
public int ImportFromCsv(SQLiteConnection connection, string path, bool firstRowAsColumnName, string tableName)
{
var cnt = 0;
using (var reader = new CsvReader(path))
using(var insertCmd = GetInsertCommand(connection, reader))
{
CreateTable(reader);
while (reader.Read())
{
cnt++;
for (var i = 0; i <= reader.FieldCount; i++)
insertCmd.Parameters[0].Value = reader[i];
if (cnt % 1000 == 0)
Console.WriteLine(cnt);
}
}
return cnt;
}
private void CreateTable(CsvReader reader)
{
throw new NotImplementedException();
}