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
LinqConnect Proxy?
-
- Devart Team
- Posts: 1710
- Joined: Thu 03 Dec 2009 10:48
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
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
LinqConnect Proxy?
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) Oracle
for some reasons, clients cannot connect to DB directly.
So, is there any solution for this situation?
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) Oracle
for some reasons, clients cannot connect to DB directly.
So, is there any solution for this situation?
-
- Devart Team
- Posts: 1710
- Joined: Thu 03 Dec 2009 10:48
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
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