C# (CSharp) SchemaArrayParameter Examples

Example #1

        public void AddInTable(NpgsqlCommand command, SchemaArrayParameter parameter, object[] array)
        {
            var sqlParameter = command.CreateParameter();

            sqlParameter.NpgsqlDbType  = NpgsqlDbType.Array | parameter.ElementType;
            sqlParameter.ParameterName = parameter.Name;
            sqlParameter.Value         = array;

            command.Parameters.Add(sqlParameter);
        }

Example #2

 public void SetInTable(NpgsqlCommand command, SchemaArrayParameter param, object[] array)
 {
     command.Parameters[param.Name].Value = array;
 }