Last post Feb 06, 2017 07:04 AM by aman_5631
Feb 02, 2017 05:38 AM|aman_5631|LINK
I want to get data from 3 type of database having same tables & data, using one query(just passing parameter of type of database.) Please guide me thanks...
Feb 02, 2017 06:20 AM|kaushalparik27|LINK
Based on your complexity of Select Statement, you will require to implement different functions to select data from these different sources. I suggest of writing an Abstract class that will hold common functions declaration and inherit different classes
per data source (as name them like Provider classes, for Example) and implement logic to fetch data from different data sources. for SQL Server, you can simply use SQLConnection, SQLCommand (System.Data.SQLClient) (ADO.NET) object to fetch data from SQL Server.
For Oracle, MySQL you may require connectors/binaries to download and reference them in your application to write logic to fetch data from different particular sources.
hope that helps./.
Feb 06, 2017 07:04 AM|aman_5631|LINK
using separate functions we can fetch data, that is what I am using right now. I want to know, if there is any interface or other functionality there to use pass just type database a parameter & get data. Some one told me about the interface. But I forgot.