예제 #1
0
        /// <summary>
        /// Return a Guid from the output parameter of calling the MultiDataSetStoredProcedure as Scalar.
        /// </summary
        /// <returns>
        /// A Guid from the output parameter of calling the MultiDataSetStoredProcedure as Scalar.
        /// </returns>
        internal Guid GetTestOutputGuidFromScalar()
        {
            MultiDataSetStoredProcedure storedProcedure = new MultiDataSetStoredProcedure("test");
            string result = ExecuteProcedureScalar <string>(storedProcedure);

            return(storedProcedure.GuidOutput);
        }
예제 #2
0
        /// <summary>
        /// Return a Guid from the output parameter of calling the MultiDataSetStoredProcedure as non-query.
        /// </summary
        /// <returns>
        /// A Guid from the output parameter of calling the MultiDataSetStoredProcedure as non-query.
        /// </returns>
        internal Guid GetTestOutputGuidFromNonQuery()
        {
            MultiDataSetStoredProcedure storedProcedure = new MultiDataSetStoredProcedure("test");

            ExecuteProcedureNonQuery(storedProcedure);
            return(storedProcedure.GuidOutput);
        }
예제 #3
0
        /// <summary>
        /// Return a composite object of various data.
        /// </summary>
        /// <param name="inputValue">
        /// The input value to pass to the database.
        /// </param>
        /// <returns>
        /// A new CompositeResultObject containing the data.
        /// </returns>
        internal CompositeResultObject GetCompositeResult(string inputValue)
        {
            MultiDataSetStoredProcedure storedProcedure = new MultiDataSetStoredProcedure(inputValue);

            using (StoredProcedureDataSetReader reader = ExecuteProcedureReader(storedProcedure))
            {
                TestRowOne[]   rowOnes   = reader.GetDataSetList <TestRowOne>();
                TestRowTwo[]   rowTwos   = reader.GetDataSetList <TestRowTwo>();
                TestRowThree[] rowThrees = reader.GetDataSetList <TestRowThree>();
                reader.ProcessOutputParameters();
                return(new CompositeResultObject(rowOnes, rowTwos, rowThrees, storedProcedure.GuidOutput));
            }
        }