// copy all rows from a List of serialized data objects to a List of SOAP Contracts,
        //  with a limit on number of returned rows and order by columns
        // links:
        //  docLink: http://sql2x.org/documentationLink/f23c4cd8-e941-4b3e-8fda-7b2ac6a399f7
        public List <CrudeServiceSpecialServiceRequestGroupRefContract> FetchAllWithLimit(int limit)
        {
            var list = new List <CrudeServiceSpecialServiceRequestGroupRefContract>();
            List <CrudeServiceSpecialServiceRequestGroupRefData> dataList = CrudeServiceSpecialServiceRequestGroupRefData.FetchAllWithLimit(limit);

            foreach (CrudeServiceSpecialServiceRequestGroupRefData crudeServiceSpecialServiceRequestGroupRef in dataList)
            {
                var contract = new CrudeServiceSpecialServiceRequestGroupRefContract();
                DataToContract(crudeServiceSpecialServiceRequestGroupRef, contract);
                list.Add(contract);
            }

            return(list);
        }
        // fetch all rows from table with a limit of rows
        // links:
        //  docLink: http://sql2x.org/documentationLink/6028cc89-271d-4e09-b157-d1016dcaf85e
        public List <CrudeServiceSpecialServiceRequestGroupRefModel> FetchAllWithLimit(string limit)
        {
            var list = new List <CrudeServiceSpecialServiceRequestGroupRefModel>();
            List <CrudeServiceSpecialServiceRequestGroupRefData> dataList = CrudeServiceSpecialServiceRequestGroupRefData.FetchAllWithLimit(int.Parse(limit));

            foreach (CrudeServiceSpecialServiceRequestGroupRefData crudeServiceSpecialServiceRequestGroupRefBusiness in dataList)
            {
                var model = new CrudeServiceSpecialServiceRequestGroupRefModel();
                DataToModel(crudeServiceSpecialServiceRequestGroupRefBusiness, model);
                list.Add(model);
            }

            return(list);
        }