Home > .Net CLR, SQL Server > ConnectionString in App.config

ConnectionString in App.config

In order to add a connection string to the app.config for a .Net application you only need the following websites:

E.g for connection to a SQL 2008 server:

< ?xml version="1.0" encoding="utf-8" ?>
<configuration>
  <connectionstrings>
    <clear />
    <add name ="Default" providerName ="System.Data.SqlClient"
    connectionString ="Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;"
  </connectionStrings>
</add></connectionstrings></configuration>

However, you should not forget about security Securing Connection Strings.

Advertisements
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: