Link non-spatial SQL Server query to a Geodatabase?

Question

Is it possible to build an object (of whatever kind) in ArcEngine code that links the geodatabase data with a non-spatial SQL Server query? How would you go about doing this?

Answer 1

Easiest Answer; is to just create a data connection to your SQL Server, Make your query and the returning dataset can be added to a ESRI table in memory that you can join.

Once you have the data into a table in memory; you can join/relate or do whatever ESRI function you want to do.