示例#1
0
        public static IEnumerable <PersonSelectByKeyResult> PersonSelectByKey(this TestDataDB dataConnection, int?id)
        {
            var parameters = new []
            {
                new DataParameter("@id", id, DataType.Int32)
            };

            return(dataConnection.QueryProc <PersonSelectByKeyResult>("[Person_SelectByKey]", parameters));
        }
示例#2
0
        public static IEnumerable <PersonSelectListByNameResult> PersonSelectListByName(this TestDataDB dataConnection, string?firstName, string?lastName)
        {
            var parameters = new []
            {
                new DataParameter("@firstName", firstName, DataType.NText)
                {
                    Size = 50
                },
                new DataParameter("@lastName", lastName, DataType.NText)
                {
                    Size = 50
                }
            };

            return(dataConnection.QueryProc <PersonSelectListByNameResult>("[Person_SelectListByName]", parameters));
        }