.Include and .IncludeMany does not work with Guid keys in Postgres databases

[ldias91]

Hi,

When i use include method in postgres database with primary keys as guid i get the following error:

operator does not exist: uuid = text

I think the problem is here

querybuilder/SqlKata.Execution/QueryFactory.Extensions.Async.cs

Line 344 in d098a4e

.Select(x => x[include.LocalKey].ToString())

instead of
.Select(x => x[include.LocalKey].ToString())

may be
.Select(x => x[include.LocalKey]);

[chrisgate]

Do u have workaround for Include in Postgresql?

[ahmad-moussawi]

Yes that's true, can you make a PR for it?

[bpasha7]

Hi @ahmad-moussawi,
I try to use Include feature, see example

db.Query("environment").Where("siteenvironmentid", UserEnvironmentId).IncludeMany("Organizations", db.Query("organization"), "environmentid", "siteenvironmentid");

it generates this sql statements
SELECT * FROM "environment" WHERE "siteenvironmentid" = 1
SELECT * FROM "organization" WHERE "environmentid" IN ('1')

So it does not work because the second SELECT converts integers to strings
Is it bug or I do something wrong?
Thanks

[bsekin-jb]

there is a pr about that issue (see #494), why you don't merge this pr to solve this issue?

[andrewweitzer]

Would love if this gets solved