}//end method
/// <summary>
/// Internal method to retrieve connection
/// </summary>
/// <param name="dataStore"></param>
/// <param name="executionEnvironment"></param>
/// <param name="commandTimeOut">Command time out specified by caller</param>
/// <returns></returns>
private static SqlConnectionInfo _RetrieveConnection(int commandTimeOut = Int32.MinValue)
{
SqlConnectionInfo toReturn = null;
string connectionString = String.Format("data source={0};initial catalog={1};integrated security=True;", Global.AppSettings.DBServer, Global.AppSettings.DBName);
/*string connectionString = string.Format("data source={0};initial catalog={1};user id={2};password={3};persist security info={4};packet size={5};",
* Global.AppSettings.DBServer,
* Global.AppSettings.DBName,
* Global.AppSettings.DBAccountName,
* Global.AppSettings.DBPassword,
* Global.AppSettings.DBPersistentSecurity,
* Global.AppSettings.DBPacketSize);*/
toReturn = new SqlConnectionInfo(new SqlConnection(connectionString), Global.AppSettings.DBNumberOfRetries, Global.AppSettings.DBDefaultTimeout);
return(toReturn);
}//end method
}//end constructor
/// <summary>
/// Constructor accepting specific connection info
/// </summary>
/// <param name="connectionInfo"></param>
public SqlService(SqlConnectionInfo connectionInfo, SqlTransaction transaction = null)
{
this.m_ConnectionInfo = connectionInfo;
m_Transaction = transaction; //Set transaction value
}//end constructor