foreach (string line in File.ReadLines(@"file.txt"))
{
// line содержит прочтенную строку
}
using (SQLiteCommand cmd = new SQLiteCommand(connection))
{
using (using (SQLiteTransaction dbTrans = connection.BeginTransaction(isolationLevel))
{
cmd.Transaction = dbTrans;
// execute
// dbTrans.Comit();
}
}