コード例 #1
0
ファイル: SQLDataAccess.cs プロジェクト: holmes2136/POS-CRM
        private void TExecuteReaderCmd <t>(SqlCommand sqlCmd, TGenerateListFromReader <t> gcfr, ref List <t> List)
        {
            if (string.IsNullOrEmpty(this.GetConnectionString()))
            {
                throw new ArgumentOutOfRangeException("ConnectionString");
            }

            if (sqlCmd == null)
            {
                throw new ArgumentOutOfRangeException("sqlCmd");
            }

            using (SqlConnection conn = new SqlConnection(GetConnectionString()))
            {
                sqlCmd.Connection = conn;
                conn.Open();
                gcfr(sqlCmd.ExecuteReader(), ref List);
            }
        }
コード例 #2
0
        private void TExecuteReaderCmd <T>(SqlCommand sqlCmd, TGenerateListFromReader <T> gcfr, ref List <T> List)
        {
            if (ConnectionString == string.Empty)
            {
                throw (new ArgumentOutOfRangeException("ConnectionString"));
            }

            if (sqlCmd == null)
            {
                throw (new ArgumentNullException("sqlCmd"));
            }

            using (SqlConnection cn = new SqlConnection(this.ConnectionString)) {
                sqlCmd.Connection = cn;

                cn.Open();

                gcfr(sqlCmd.ExecuteReader(), ref List);
            }
        }