Remoting - Reaching DB over WAN

Posts   
 
    
sunnyman
User
Posts: 51
Joined: 21-Feb-2007
# Posted on: 17-Apr-2009 15:06:53   

I have a working application that connects to db over LAN. The requirement now is to connect to db over WAN (internet) where db server can't be reached directly.

From what I read in forums, I think remoting should produce the best performance, Right? I see remoting sample and I have one question about it

Is it a must to create the interface project to wrap adapter methods like this

CustomerEntity GetCustomer(string customerId)?

I don’t need this extra overhead as my application server(Service) is just a mean to reach the db, there is no business logic inside it at all (BL is built inside the db itself)

Is there anyway to remove this overhead and directly call the adapter methods remotely? If not, is there any automated tool to write the interface project?

Thanks a lot

sunnyman
User
Posts: 51
Joined: 21-Feb-2007
# Posted on: 21-Apr-2009 19:46:40   

Hello, Anyone there simple_smile

I just want a way to reach the db behind a firewall using llblgen and either Remoting, WS ,WCF or any other method.

Thanks.

MTrinder
User
Posts: 1461
Joined: 08-Oct-2008
# Posted on: 21-Apr-2009 21:42:41   

There is a long discussion about this very topic here

Matt