Hello,
As part of the testing i am doing for Mapsuite, I would like to be able to map large volumes of data in an SQL Server database. I have been able to do this by querying the database and then joining the result to a shapefile, though now i would like to be able to embed the shapefile in my database and pass a query string to MsSql2008FeatureLayer. This isnt currently available in the contructor, so the only way i have been able to join a table with my spatial data is by creating a view. Is there another way to do this? The problem is that my view needs to be dynamic depending on what the user selects through a "data selection wizard". I imagine that i could create a temporary view, but if multiple users are connecting to the database at the same time i then to to monitor view names etc.
I imagine i am not the only person with this type of request, how would you recommend I get around this?
thanks
Phil