The main issue is suppose i have two databases and when
user wants data for last 10 years data,it has to connect to
one database and if user wants data for the past 1 year,it
has to connect to the other database.like that .can i
create two data sources in one properties file.is it
possilbe.if so provide me the explaination.Thanks in
advance.



The main issue is suppose i have two databases and when user wants data for last 10 years data,it ..

Answer / vamshi krishna

from .net technology point of view, u can use multipls
connectionstrings to connect to the database.you can define
that in web.config file under appSettings as follows....

<connectionStrings>
<clear/>
<!--Report Data base Connection String -->
<add name="ReportingConnection"
connectionString="Server=192.168.1.13;Database=Pegasus;UID=p
egasus;PWD=pegasus;Pooling=true;Max Pool
Size=300;Connection Timeout=60"/>
<!-- Data base Connection String to the
pegasus admin database -->
<add name="PegasusAdminConnection"
connectionString="Server=192.168.1.13;Database=Pegasus;UID=p
egasus;PWD=pegasus;Pooling=true;Max Pool
Size=300;Connection Timeout=60"/>
<!-- Data base Connection String to the
pegasus course database (admin database course database
role. so, same as admin db conn string)-->
<add name="PegasusDBConnection1"
connectionString="Server=192.168.1.13;Database=Pegasus;UID=p
egasus;PWD=pegasus;Pooling=true;Max Pool
Size=300;Connection Timeout=60"/>
<!-- Data base Connection String to the
pegasus course 1 database -->
<add name="PegasusDBConnection2"
connectionString="Server=192.168.1.13;Database=Pegasus;UID=p
egasus;PWD=pegasus;Pooling=true;Max Pool
Size=300;Connection Timeout=60"/>
<!-- Data base Connection String to the
pegasus course 2 database -->
<add name="PegasusDBConnection3"
connectionString="Server=192.168.1.13;Database=Pegasus;UID=p
egasus;PWD=pegasus;Pooling=true;Max Pool
Size=300;Connection Timeout=60"/>
</connectionStrings>

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Architecture Design AllOther Interview Questions

How to construct Pile foundation?

1 Answers  


what is the design architecture of cognos8?

0 Answers   ABC,


How the Islamic Iwan or stalactite vaulting is accomplished with brick or stone?

0 Answers  


What personal quality is important to be an architect?

0 Answers  


Is there any symbolic or cultural significance behind the structure of the buildings you are observing?

0 Answers  






how to know low voltage and high voltage ranges for electrical machinery ?

0 Answers  


what is the maximum depth at which the open foundation bridge can be done

0 Answers  


is profit a liability for an organisation if yes why if no why

0 Answers  


i wan job in architectural degsiner

1 Answers  


I am Planning to Contruct a floor appartment on my own thro a Contractor . How to estimate the Constrction Cost , to negociate with the Contractor.

0 Answers  


What is the difference between (with what type of material they are made of)RAM cells and Cache memory cells

2 Answers   MIT,


1 bag cement =who many seq er meters plastering (1:5)

1 Answers  


Categories
  • Interior Design Interview Questions Interior Design (21)
  • Architecture Design AllOther Interview Questions Architecture Design AllOther (185)