Beispiel #1
0
        public static IEnumerable <PersonSelectAllResult> PersonSelectAll(this TestDataDB dataConnection, out int?returnValue)
        {
            var parameters = new []
            {
                new DataParameter("RETURN_VALUE", null, DataType.Int32)
                {
                    Direction = ParameterDirection.ReturnValue,
                    Size      = 10
                }
            };

            returnValue = Converter.ChangeTypeTo <int?>(parameters[0].Value);
            return(dataConnection.QueryProc <PersonSelectAllResult>("[dbo].[Person_SelectAll]", parameters).ToList());
        }
Beispiel #2
0
        public static int AddIssue792Record(this TestDataDB dataConnection, out int?returnValue)
        {
            var parameters = new []
            {
                new DataParameter("RETURN_VALUE", null, DataType.Int32)
                {
                    Direction = ParameterDirection.ReturnValue,
                    Size      = 10
                }
            };

            returnValue = Converter.ChangeTypeTo <int?>(parameters[0].Value);
            return(dataConnection.ExecuteProc("[dbo].[AddIssue792Record]", parameters));
        }