Trying to create ITable from a MS SQL Server Express table with spatial column

Discussion created by martin_wong on Apr 24, 2012
Latest reply on May 1, 2012 by dlednik-esristaff
Hi, I'm pretty new to C#, SQL Server, and AO so excuse the noobness.  What I want to do is take the AdventureWorks2012.Person.Address table (which contains the "SpatialLocation" geography column) stored in my local MS SQL Server Express server and create a query layer and eventually create an ILayer to display in a MapControl on a Windows form.  I've tried searching the forums but haven't had any luck finding anything.  Is there an example of this that someone can explain to me or point me to?