Thursday, 17 January 2019

How to connect local visual studio code with server Data Base and local Data Base

 Connect visual studio code with local Sql server DB:

<add name="FMECADB" providerName="System.Data.SqlClient" connectionString="Data Source=.;Initial Catalog=FMECADB;Integrated Security=True;" />

Name:- name of the connection string
DataSource:-login details(for local DB we are login using DOT(.))
Initial Catalog:-Name of the DataBase


Connect visual studio code with Server Sql server DB:

    <add name="FMECADB" providerName="System.Data.SqlClient" connectionString="Data Source=190.25.118.54;Initial Catalog=FMECADB_Onsite;Integrated Security=false;User Id=FMECADB;Password=1qaz2wsx@"/>

No comments:

Post a Comment

How to get the value from web.config(if any value assign as static Key)

Web.Config File:   <appSettings>     <add key="DomainName" value="PW" />     </appSettings> Cl...