Database Connectivity/Query class
-
Hello Guys, I have to connect to Oracle and SQL Server in my database projects. So I have to write the code to connect and query these tables... I am looking for a class/assembly that provides connectivity/query facility for 2 databases (oracle and SQL Server). I should be able to pass connection parameters from my application. Then use the methods to query the database through the class/dll. I have seen one @ DB Connectivity Provider[^] If any one known of one please let know. Thanks in advance
o O º(`'·.,(`'·., ☆,.·''),.·'')º O o° »·'"`»* *☆ t4ure4n ☆* *«·'"`« °o O º(,.·''(,.·'' ☆`'·.,)`'·.,)º O o°
-
Hello Guys, I have to connect to Oracle and SQL Server in my database projects. So I have to write the code to connect and query these tables... I am looking for a class/assembly that provides connectivity/query facility for 2 databases (oracle and SQL Server). I should be able to pass connection parameters from my application. Then use the methods to query the database through the class/dll. I have seen one @ DB Connectivity Provider[^] If any one known of one please let know. Thanks in advance
o O º(`'·.,(`'·., ☆,.·''),.·'')º O o° »·'"`»* *☆ t4ure4n ☆* *«·'"`« °o O º(,.·''(,.·'' ☆`'·.,)`'·.,)º O o°
-
Hello Guys, I have to connect to Oracle and SQL Server in my database projects. So I have to write the code to connect and query these tables... I am looking for a class/assembly that provides connectivity/query facility for 2 databases (oracle and SQL Server). I should be able to pass connection parameters from my application. Then use the methods to query the database through the class/dll. I have seen one @ DB Connectivity Provider[^] If any one known of one please let know. Thanks in advance
o O º(`'·.,(`'·., ☆,.·''),.·'')º O o° »·'"`»* *☆ t4ure4n ☆* *«·'"`« °o O º(,.·''(,.·'' ☆`'·.,)`'·.,)º O o°
A little bit different approach: You can connect to Oracle from SQL Server and vice versa. After that you can for example define a view that actually hides where the data is coming from, so basically your application can connect to a single database and still get data from multiple databases but the application does not see it. In some cases this is easier to implement.
The need to optimize rises from a bad design.My articles[^]