Views accessing different DB server

Posts   
 
    
stacr
User
Posts: 4
Joined: 03-May-2007
# Posted on: 03-May-2007 05:13:51   

Hello,

Im currently using LLBLGen version 1.0.2004.2 and I want to know if it supports the usage of a view/stored proc in my current catalog that connects and gets data from a different server. Also is there additional things we need to do to make this posible? Thanks.

Walaa avatar
Walaa
Support Team
Posts: 14995
Joined: 21-Aug-2005
# Posted on: 03-May-2007 09:32:44   

LLBLGen Pro doesn't care what the View/SP does. At the end it issues a Select query for the View or a Exec call to the SP. What is done inside them is purely a database concern.

stacr
User
Posts: 4
Joined: 03-May-2007
# Posted on: 03-May-2007 09:47:21   

Thanks for the reply.

Floow up question is if I can connect to different servers, with different schemas, using one LLBLGen project. Posible case is that we create a view within DB 1 which uses columns from tables in DB2.

Walaa avatar
Walaa
Support Team
Posts: 14995
Joined: 21-Aug-2005
# Posted on: 03-May-2007 10:01:15   

using one LLBLGen project. Posible case is that we create a view within DB 1 which uses columns from tables in DB2.

Using a view that access another database in the same server or in another server is not LLBLGen Pro's business. LLBLGen Pro will query the view and will return those rows returned by the view. Whether the view is accessing the same database or not.

stacr
User
Posts: 4
Joined: 03-May-2007
# Posted on: 03-May-2007 10:10:34   

Thanks!