在 .net 6 中使用复合参数调用 Postgres 过程

问：

我已经在 postgres 中创建了一个自定义类型作为复合类型，并将其作为参数传递给过程，我想从 .net 6 调用该过程，但我一直收到错误"InvalidCastException: Can't convert .NET type 'ArtProductService.Models.Dtos.BulkUpdateAcquisitionDto' to PostgreSQL '.<unknown>' within an array"

这是我的职能

  var dataSourceBuilder = new NpgsqlDataSourceBuilder(_connectionString);
  dataSourceBuilder.MapComposite<List<myObject>>("composite[]");
  await using var dataSource = dataSourceBuilder.Build();
  using var conn = dataSource.CreateConnection();
  conn.ConnectionString = _connectionString;

  string query = "\"schema\".\"procedureName\"";
  conn.Open();
  NpgsqlCommand command = new NpgsqlCommand(query, conn);

  var param = command.CreateParameter();
  param.ParameterName = "paramName";

  param.Value = paramValue;
  param.DataTypeName = "composite[]";

  command.CommandType = CommandType.StoredProcedure;
  command.Parameters.Add(param);
  await command.ExecuteNonQueryAsync();