Can dynamic layer support in-memory feature class?

Discussion created by chenbing_6 on Jan 14, 2013
Hi There,

I have a requirement that shows aggregated data on dynamic map. The aggregated data is the result set of a dynamic query on some database tables and has geo-reference on each record, for example US state, County or lat/long pair. I would need to build a in-memory feature layer for each query and dynamically add this feature layer to a map service so that the user can see the aggregated data on the map on the fly. I was trying to do this with query layer but had difficult time to change the definition of query layer on the fly. Can any one give me a clue how to achieve this task. I know that Geoserver/Postgres can do this, but I need to implement it in ArcGIS server.