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
1 2 3 4 5 6 7 8 9 |
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