1 - Create new ODBC Connection to CCT DB Source

Reference: Maxim Tsvetov’s Blog

2 - Setup Database.Net to connect to CCT ODBC connection

3 - Execute Query

SELECT "NcctcAgent"."AgentLoginID", "NcctcAgent"."FirstName", "NcctcAgent"."LastName", "NcctcUser"."LoginName"
FROM "NcctcAgent"
INNER JOIN "NcctcUserAgent" ON "NcctcUserAgent"."AgentID"="NcctcAgent"."ID"
INNER JOIN "NcctcUser" ON "NcctcUser"."ID"="NcctcUserAgent"."UserID"

Hope somebody finds this helpful.