From Multiple connection strings i have to call SQL Server

Posted by Radhika10 under .NET Framework on 1/11/2018 | Points: 10 | Views : 2507 | Status : [Member] | Replies : 1

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

Hi Team,

In App.config file we have multiple connection strings from which we need to use SQLServer connection string.

<Connectionstrings>
<addname ="DB2" providerName="DB2" Connectionstring="">
<addname = "Oracle" providerName="Oracle" Connectionstring="">
<addname = "SQLServer" providerName="SQLServer" Connectionstring=""

Currently the application is hitting the Oracle DB to get the details and we need to interact with the SQL Server to get the details as part of the requirement.

What changes need to be done in the Connection string file that it should refer to the SQL Server?How to create a new class in the layer which will hit the SQL Server?

Thanks in Advance!!

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Sheonarayan on: 1/12/2018 [Administrator] HonoraryPlatinum | Points: 25

0	No need of any class. Simply change the connection string name to SQLServer and it should do the work. Or change the ConnectionString value in the app.config file. Of course, you will have to use SqlClient in place of OracleClient as name space (System.Data.SqlClient). The classes to connect to sql server are SqlConnection in place of OracleConnection SqlCommand in place of OracleCommand SqlDataAdapter in place of OracleDataAdapter SqlDataReader in place of OracleDataReader Thanks Regards, Sheo Narayan http://www.dotnetfunda.com Radhika10, if this helps please login to Mark As Answer. \| Alert Moderator

No need of any class. Simply change the connection string name to SQLServer and it should do the work.
Or change the ConnectionString value in the app.config file.

Of course, you will have to use SqlClient in place of OracleClient as name space (System.Data.SqlClient). The classes to connect to sql server are

SqlConnection in place of OracleConnection
SqlCommand in place of OracleCommand
SqlDataAdapter in place of OracleDataAdapter
SqlDataReader in place of OracleDataReader

Thanks

Regards,
Sheo Narayan
http://www.dotnetfunda.com

Radhika10, if this helps please login to Mark As Answer. | Alert Moderator

Latest Posts