Lack a default Type Mapping for short array in composite to PostgreSQL smallint[]  #5591

using Npgsql;

// 1. Assuming a PostgreSQL setup with the following type and table:
CREATE TYPE public.inventory_item AS
(
    name text,
    supplier_id integer,
    price numeric,
    shortlist smallint[]
);

CREATE TABLE some_table (
  id serial PRIMARY KEY,
  my_composite inventory_item
);

// 2. C# code that demonstrates the issue:
public class InventoryItem
{
    public string Name { get; set; } = "";
    public int SupplierId { get; set; }
    public decimal Price { get; set; }
    public short[] ShortList { get; set; }
}

// (Code for connection setup using NpgsqlDataSourceBuilder)

await using var conn = dataSource.CreateConnection();
await conn.OpenAsync();

await using var cmdWriting = new NpgsqlCommand("INSERT INTO public.some_table (my_composite) VALUES (@composite)", conn);

var inventoryItem = new InventoryItem
{
  Name = "InventoryItemName",
  SupplierId = 4323,
  Price = 300.0m,
  ShortList = new short[] { 1, 2, 3 } 
};

cmdWriting.Parameters.AddWithValue("@composite", inventoryItem);
await cmdWriting.ExecuteNonQueryAsync();