You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Hi,
At this moment it is not possible to use Postgresql's ANY() operator to pass arrays as sql input parameters.
When trying code such as
publicclassSomeEntity{publicintId{get;set;}}publicTask<List<SomeEntity>>AcceptRejectRule(AsyncPoco.DatabasedbConn){objectids=new[]{1,2,3,4};returndbConn.FetchAsync<SomeEntity>("where id = ANY(@0)",ids);}
It fails because it generates:
sql query: select id from SomeEntity where id = ANY(@0, @1, @2, @3)
query parameters: SqlParameter(@0, 1), SqlParameter(@1, 2),SqlParameter(@2, 3),SqlParameter(@3, 4)
Implementation proposal as PR will follow shortly.
The text was updated successfully, but these errors were encountered:
Hi,
At this moment it is not possible to use Postgresql's ANY() operator to pass arrays as sql input parameters.
When trying code such as
It fails because it generates:
sql query:
select id from SomeEntity where id = ANY(@0, @1, @2, @3)
query parameters:
SqlParameter(@0, 1), SqlParameter(@1, 2),SqlParameter(@2, 3),SqlParameter(@3, 4)
Implementation proposal as PR will follow shortly.
The text was updated successfully, but these errors were encountered: