So I am currently just trying to simply iterate through a for loop and bulk insert into snowflake the values, however it seems to be just running each query one at a time instead of bulking them together.

I've been looking at other solutions to using IDbCommand but none seem to work...

```
        //SnowflakeConnector snowflake = snowflakeCon;
        //IDbCommand snowCommand = snowflake.con.CreateCommand();
        try
        {

            IDbCommand cmd = snowflake.con.CreateCommand();
            cmd.CommandText = "insert into TEST values (?)";
            //IDataReader reader = cmd.ExecuteReader(); // this crashes

            var p1 = cmd.CreateParameter();
            p1.ParameterName = "1";
            p1.Value = 10;
            p1.DbType = DbType.Int32;
            cmd.Parameters.Add(p1);

            for (int i = 0; i < 100; i++)
            {
                p1.Value = i;
                cmd.ExecuteNonQuery(); // inserts one at a time instead of bulk
            }

        }
        catch (Exception ex)
        {
            Console.WriteLine(ex.Message);
        }

```

the documentation provided is a very basic example; <https://github.com/snowflakedb/snowflake-connector-net>