Hi Florida,
Followings are the standard ways to create connection string in the cofig file of the application.
Windows Authentication:
<connectionStrings>
<add name="connString" connectionString="Data Source=SPICITY1140\SQLEXPRESS;Initial Catalog=SPI_RFID2016;Integrated Security=True" providerName="System.Data.SqlClient" />
</connectionStrings>
SQL Server Authentication:
<connectionstrings>
<add name="connString" connectionstring="Data Source=MT000XBSQL107\INST2;Initial Catalog=SRA;Persist Security Info=True;User ID=SRA_SSIS;Password=password">
providerName="System.Data.SqlClient" />
</add></connectionstrings>
In C# code:
private string conStr = ConfigurationManager.ConnectionStrings["connString"].ConnectionString;
Programmaticalyy:
private DbConnection CreateConnection(string connectionString)
{
return new SqlConnection(connectionString);
}
private string CreateConnectionString(string server, string databaseName, string userName, string password)
{
var builder = new SqlConnectionStringBuilder
{
DataSource = server,
InitialCatalog = databaseName,
IntegratedSecurity = false,
MultipleActiveResultSets = false,
PersistSecurityInfo = true,
UserID = userName,
Password = password
};
return builder.ConnectionString;
}
How to Use:
public void ConnectoToDbWithEf6()
{
using(var connection = CreateConnection(CreateConnectionString("server", "db", "you", "password")
{
using(var context = new YourContext(connection, true))
{
foreach(var someEntity in context.SomeEntitySet)
{
Console.WriteLine(someEntity.ToString());
}
}
}
}
Thanks,
Prateek