/// <summary>
/// Получить строку подключения к БД
/// </summary>
/// <param name=""></param>
/// <returns></returns>
public string GetSqlConnectionString(TConnectionDetails connectionDetails)
{
var connectionBuilder = new SqlConnectionStringBuilder();
connectionBuilder.IntegratedSecurity = true;
connectionBuilder.DataSource = connectionDetails.ServerName;
connectionBuilder.InitialCatalog = connectionDetails.DatabaseName;
return(connectionBuilder.ToString());
}
/// <summary>
/// Получить соединение к БД
/// </summary>
/// <param name="connectionDetails"></param>
/// <returns></returns>
SqlConnection GetSqlConnection(TConnectionDetails connectionDetails)
{
if (sqlConnection == null)
{
var connectionBuilder = new SqlConnectionStringBuilder();
connectionBuilder.IntegratedSecurity = true;
connectionBuilder.DataSource = connectionDetails.ServerName;
connectionBuilder.InitialCatalog = connectionDetails.DatabaseName;
sqlConnection = new SqlConnection(connectionBuilder.ToString());
Debug.Assert(sqlConnection != null, "sqlConnection should be not null");
}
return(sqlConnection);
}
public SqlRunner(TConnectionDetails _connectionDetails)
{
connectionDetails = _connectionDetails;
}
public EntityRepository(TConnectionDetails connectionDetails)
{
entityConfig = new EntityConfig();
this.connectionDetails = connectionDetails;
sqlRunner = new SqlRunner(connectionDetails);
}
