Create appropriate provider at run time(use factory patterns) based on so

If we want to connect to many databases in dataaccess layer
such as MSAccess,Sql server,oracle means not to a particular
database depends on condition we have to connect to
appropriate database in this scenario if we without changing
code Ho wdo you handle this situation?

Question Posted / ganesh

4 Answers
9765 Views
Honeywell, I also Faced
E-Mail Answers

Answer Posted / ganesh

Create appropriate provider at run time(use factory
patterns) based on some configurations setting (probably a
XML file).This will allow user to decide providers
dynamicallly and enable connecting to whatever database he
wants

Is This Answer Correct ?

2 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Which components of a data provider is used to retrieve, insert, delete, or modify data in a data source?

1147

What providers does Ado.net uses?

1022

What is data view and variable view?

929

Define Execute Scalar?

1024

What is a serialized object?

1030

Explain how do you connect to sql server database without using sqlclient?

1012

What is data reader in ado.net?

1008

Can we load multiple tables in a dataset?

1135

What is Data view?

1082

What is the provider being used to access oracle database?

998

What does datareader object do?

1011

How to find the given query is optimised one or not?

979

Explain advantages of ado.net?

1054

What DataReader class do in ADO.NET ?

1101

What is difference between dataset and datatable?

1186