Skip to content

Essentially incompatible with Npgsql v10+ #772

@SIEDA-EliasHeydrich

Description

@SIEDA-EliasHeydrich

The new release of Npgsql came with a number of breaking changes. Particularly fundamental for SqlKata is the fact that date and time are now mapped to DateOnly and TimeOnly by default, as that effectively eliminates the ability to perform queries with SqlKata using that library.

For example, if one simply selects data from a table that contains colums of e.g. type timestamp without time zone using simple SqlKata-code like this...

var sqlQueryObj = new Query().From( someTable );
QueryFactory.Get<T>( sqlQueryObj, dbTransaction)

one ends with with an exception Error parsing column 3 (col3=01.01.1971 - Object) from Dapper, with the root cause / inner exception showing Object must implement IConvertible..

It seems the version of Dapper being employed by SqlKata is currently incompatible with an up-to-date Npgsql.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions