.NET How would I build a DAL to meet my requirments?

Posted by Jonno on Stack Overflow See other posts from Stack Overflow or by Jonno
Published on 2010-06-13T01:17:45Z Indexed on 2010/06/13 1:22 UTC
Read the original article Hit count: 315

Filed under:
|
|
|
|

Assuming that I must deploy an asp.net app over the following 3 servers:

1) DB - not public 2) 'middle' - not public 3) Web server - public

I am not allowed to connect from the web server to the DB directly. I must pass through 'middle' - this is purely to slow down an attacker if they breached the web server.

All db access is via stored procedures. No table access.

I simply want to provide the web server with a ado dataset (I know many will dislike this, but this is the requirement).

Using asmx web services - it works, but XML serialisation is slow and it's an extra set of code to maintain and deploy.

Using a ssh/vpn tunnel so that the one connects to the db 'via' the middle server, seems to remove any possible benefit of maintaining 'middle'.

Using WCF binary/tcp removes the XML problem, but still there is extra code.

Is there an approach that provides the ease of ssh/vpn, but the potential benefit of having the dal on the middle server?

Many thanks.

© Stack Overflow or respective owner

Related posts about .NET

Related posts about ASP.NET