Npgsql.Tests.SystemTransactionTests.FunctionTestTimestamptzParameterSupport C# (CSharp) Method

FunctionTestTimestamptzParameterSupport() private method

private FunctionTestTimestamptzParameterSupport ( ) : void
return void
        public void FunctionTestTimestamptzParameterSupport()
        {
            /*
            ExecuteNonQuery(@"INSERT INTO data (name) VALUES ('X')");
            ExecuteNonQuery(@"CREATE OR REPLACE FUNCTION testtimestamptzparameter(timestamptz) returns refcursor as
                              $BODY$
                              declare ref refcursor;
                              begin
                                      open ref for select * from data;
                                      return ref;
                              end
                              $BODY$
                              language 'plpgsql' volatile called on null input security invoker;");
            var connectionString = ConnectionString + ";enlist=true";
            using (var scope = new TransactionScope())
            {
                using (var connection = new NpgsqlConnection(connectionString))
                {
                    connection.Open();
                    var command = new NpgsqlCommand("testtimestamptzparameter", connection);
                    command.CommandType = CommandType.StoredProcedure;

                    command.Parameters.Add(new NpgsqlParameter("p1", NpgsqlDbType.TimestampTZ));

                    //NpgsqlDataReader dr = command.ExecuteReader();

                    //Int32 count = 0;

                    //while (dr.Read())
                    //count++;
                    var da = new NpgsqlDataAdapter(command);
                    var dt = new DataTable();
                    da.Fill(dt);

                    Assert.AreEqual(1, dt.Rows.Count);
                }
            }
            */
        }