DuckDbStreamToByteArrayPropertyHandler

A property handler that maps a DuckDB BLOB column onto a byte array property.

A property handler that maps a DuckDB BLOB column onto a byte[] property. DuckDB.NET returns an unmanaged Stream when reading a BLOB value, which has no built-in coercion to byte[]. Writing is unaffected — a byte[] parameter value is already accepted natively by DuckDB.NET, so only the read direction needs this handler.

DuckDbBootstrap registers this handler at the type level keyed by Stream — the CLR type DuckDB.NET’s reader reports for a BLOB column — rather than by byte[]. RepoDb.Core falls back to a type-level handler keyed by the reader’s reported type whenever a property has no explicit (attribute or property-level) handler of its own, so any byte[]-typed property reading from a BLOB column is converted automatically, with no attribute or manual mapping required.

Overview

Conversions

Usability

public class Document
{
    public int Id { get; set; }
    public byte[] Content { get; set; }
}

using (var connection = new DuckDBConnection(ConnectionString))
{
    connection.Insert(new Document { Id = 1, Content = File.ReadAllBytes("file.pdf") });
    var document = connection.Query<Document>(e => e.Id == 1).First();
}

To override the default registration:

PropertyHandlerMapper.Add<Stream, MyCustomStreamToByteArrayPropertyHandler>(new MyCustomStreamToByteArrayPropertyHandler(), true);