My workflow (and security restrictions) for a new html/javascript based web application is making me think that I could program an ASP.NET application, inside which I load the 'map' and the 'legends' objects etc using the usual Dojo libraries.
But before I go too far with this approach, I need to know whether usual ASP.NET Sql queries would be enough to kind of feed the map all the information which typically the ESRI Javascript API based applications use. Specifically, currently:
http://myserver/myservice/MapServer/0/query?f=json&where=
could become a standard ASP.NET SQL Server query targeting the database's tables; I suspect I will need to somehow make the return as JSON output and then feed to the web application?
Am I on right track? Has anyone done something like this before? What are the pitfalls I need to be aware of?