Пример #1
0
        }//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
Пример #2
0
        }//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