Productivity Tools

Published: 2018.02.16

Category: C#, SQL

ConnectionString

ConnectionString generates connection string in c# code.

Connection string can be prepared in 3 format:

SqlDataSource – just name of the server without database name – usefull for creation database in code
SqlServer – most popular connection string with server name and database name
EntityFramework – connection string used to initialize EntityFramework context

Folowing code

 var serverName=ConnectionStringHelper.ConnectionString.GetSqlDataSourceConnectionString("serverName");
 Console.WriteLine(serverName);
 Console.WriteLine();
 var serverNameWithDatabase= ConnectionStringHelper.ConnectionString.GetSqlServerConnectionString("serverName","databaseName");
 Console.WriteLine(serverNameWithDatabase);
 Console.WriteLine();
 var entityFramework = ConnectionStringHelper.ConnectionString.GetSqlEntityFrameworkConnectionString("serverName", "databaseName", "metadata");
 Console.WriteLine(entityFramework);
 Console.WriteLine();

var serverName=ConnectionStringHelper.ConnectionString.GetSqlDataSourceConnectionString("serverName");

Console.WriteLine(serverName);

Console.WriteLine();

var serverNameWithDatabase= ConnectionStringHelper.ConnectionString.GetSqlServerConnectionString("serverName","databaseName");

Console.WriteLine(serverNameWithDatabase);

Console.WriteLine();

var entityFramework = ConnectionStringHelper.ConnectionString.GetSqlEntityFrameworkConnectionString("serverName", "databaseName", "metadata");

Console.WriteLine(entityFramework);

Console.WriteLine();

Will result in following connection strings:

Module dependents on the ConnectionStringLight