Dear Archana,
I was able to get past issue with Reserve words tables names keeping enableefcasesenstivity=true in Db2 Connections string only. I didn't have to Scaffold the entire thing. The Switch actually enforces every object to be wrapped with double quotes. Hence, it did the trick for us.
Thanking with warm heart over the same, I am facing yet another issues which I think might have to do with adapter only!!
We are passing paging options as paging object to be implement pagination on the Result Array.
Hence using Using
.UseDb2(connectionString, db2 =>
{
Sdb2.UseRowNumberForPaging();
sql.SetServerInfo(IBMDBServerType.LUW);
});
//..>>Where connections string has enableefcasesenstivity=true.
On early encounters to put it in simple words UseRowNumberForPaging() is not covered/supported with enableefcasesenstivity=true , as we get query such as below (note the section not having quotes on where clause):-
SELECT "t"."ID", "t"."NAME", "t"."DESCRIPTION", "t"."ID0", "t"."UPDATE_MODE", "t"."UPDATE_TIME", "t"."UPDATE_URL", "t"."ALLOW_DIRECT_LOGIN", "t"."AUTOFEDERATION", "t"."c"
FROM (
SELECT "o"."ID", "o"."NAME", "o"."DESCRIPTION", "t"."ID" AS "ID0", "s"."UPDATE_MODE", "s"."UPDATE_TIME", "s"."UPDATE_URL", "s"."ALLOW_DIRECT_LOGIN", "s"."AUTOFEDERATION", COALESCE("o"."TWO_FACTOR_REQUIRED", 0) AS "c", ROW_NUMBER() OVER(ORDER BY "o"."NAME") AS "c0"
FROM "DB2ADMIN"."ORG_UNIT" AS "o"
INNER JOIN (
SELECT "o0"."ID", "o0"."ALLOW_CONCURRENT_SESSIONS", "o0"."DESCRIPTION", "o0"."GUID", "o0"."NAME", "o0"."PARENT_ID", "o0"."ROOT_ORG_ID", "o0"."TWO_FACTOR_REQUIRED", "o0"."UNIT_LEVEL"
FROM "DB2ADMIN"."ORG_UNIT" AS "o0"
WHERE "o0"."UNIT_LEVEL" = 1
) AS "t" ON "o"."ID" = "t"."PARENT_ID"
LEFT JOIN "DB2ADMIN"."SAML2_FEDERATION" AS "s" ON "t"."ID" = "s"."ORG_UNIT_ID"
WHERE "o"."UNIT_LEVEL" = 0
ORDER BY "o"."NAME"
) AS "t"
WHERE (t.c0 > 0) AND (t.c0 <= (0 + 10))
Kindly note the where clause which there because of paging support without breaking app.
I did a fine amount of digging around this but not getting anything relevant. Request you to kindly address this as well asap in priority!
Thanks & Regards