LinqConnect Proxy?

LinqConnect Proxy?

Postby Blave » Fri 30 Dec 2011 05:58

My network structure:
Oracle: Private IP (eg. 192.168.0.1)
Server farm: Public IP

Client <--> Server <--> Oracle
(Public) (Private)

Clients connot connect to Oracle directly.

So clients can't use LinqConnect with my DB.

Is there a proxy to solve my problem?

Like this:

Client(with LinqConnect) <--> LinqConnect Proxy <--> DB
Blave
 
Posts: 8
Joined: Fri 23 Sep 2011 12:46

Postby StanislavK » Thu 05 Jan 2012 17:29

Could you please describe this situation in more details? For example, please specify what exactly the intermediate layer is, and what functionality you suggest the LinqConnect proxy would perform.

If, e.g., the 'Server' layer is a web service, you can use LinqConnect to access the Oracle server at this layer only, and pass the entity objects to the client layer and back. For some details and examples concerning such a scenario, please refer to the following article (which is written for LINQ to SQL, but mostly can be applied to LinqConnect as well):
http://msdn.microsoft.com/en-us/library/bb546187.aspx
StanislavK
Devart Team
 
Posts: 1710
Joined: Thu 03 Dec 2009 10:48

LinqConnect Proxy?

Postby Blave » Fri 06 Jan 2012 00:53

This situation is ok:
Client(Web browser) <--> Web Server <--> Oracle

But, I'll develop an WinForm application for clients to connect to DB(which in Private IP Section, Only Web Servers can connect to):
Client(WinForm+LinqConnect) <-x-> Oracle

for some reasons, clients cannot connect to DB directly.
So, is there any solution for this situation?
Blave
 
Posts: 8
Joined: Fri 23 Sep 2011 12:46

Postby StanislavK » Tue 10 Jan 2012 11:23

As far as I can understand, the question is actually more related to the application architecture than to the ORM or data provider functionality.

It should be possible to create a web service that has permissions to access the database (and implement the data access layer in this service), and consume this service from a client application, the latter being either a web or a WinForms application. For some more information on this, please refer, e.g. to the following tutorials on ASP.NET and WCF web services:
http://msdn.microsoft.com/en-us/library/t745kdsh.aspx
http://msdn.microsoft.com/en-us/library/ms734712.aspx
StanislavK
Devart Team
 
Posts: 1710
Joined: Thu 03 Dec 2009 10:48


Return to dotConnect for Oracle