✅ PostgreSQL foreach() insert not working

var sql = @"INSERT INTO outstanding(name) VALUES(@name)";
            using var cmd = new NpgsqlCommand(sql, con);
            foreach (var item in outstanding)
            {
                cmd.Parameters.AddWithValue("name",item);
                cmd.Prepare();
                cmd.ExecuteNonQuery();
            }