Using LINQ to query database through a proxy server of some kind?
- by Mustafakidd
Hey All
Sorry for using (perhaps) the wrong lingo, but my question may be clearer if you view this diagram as you read it.
http://dl.dropbox.com/u/13256/DIAGRAM.PNG
Our client is requiring us to adhere to the server configuration (poorly) diagrammed in the above image. The web server is accessible over port 80 and is where our web application is hosted - a second firewall permits this web server to access a second server which in turn is the only server permitted to access the database server. My question is: How do I deploy a web application that uses LINQ-to-SQL in this environment? Is there a way to proxy my LINQ queries through the app server so that the database connection goes through that server? This is uncharted territory for me, as we always have had access to the DB server directly from our web server in the past.
Any help is appreciated.
Thanks
Mustafa