示例#1
0
        /// <summary>
        /// 调存储过程.
        /// </summary>
        private static void CallProc()
        {
            Console.WriteLine("===== 测试执行存储过程的处理.");

            using (Test context = new Test(connString))
            {
                string outVal = "", inoutVal=" Hello";

                int result = context.HelloWorld2("Edward", ref outVal, ref inoutVal);

                Console.WriteLine("执行存储过程 HelloWorld2, 返回值={0}, out参数1={1}, out参数2={2}",
                    result, outVal, inoutVal);



                // 执行返回结果集的存储过程.
                var query = context.testProc();

                foreach (testProcResult data in query)
                {
                    Console.WriteLine("执行返回结果集的存储过程,执行结果:A={0},B={1}", data.A, data.B);
                }

            }
        }