// 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, starting at a specific row
        // links:
        //  docLink: http://sql2x.org/documentationLink/3fe9f1b3-97b6-4f58-a0f2-adfcbd973bfc
        public List <CrudeFinancialBookingTransactionTypeRefContract> FetchAllWithLimitAndOffset(int limit, int offset)
        {
            var list = new List <CrudeFinancialBookingTransactionTypeRefContract>();
            List <CrudeFinancialBookingTransactionTypeRefData> dataList = CrudeFinancialBookingTransactionTypeRefData.FetchAllWithLimitAndOffset(limit, offset);

            foreach (CrudeFinancialBookingTransactionTypeRefData crudeFinancialBookingTransactionTypeRef in dataList)
            {
                var contract = new CrudeFinancialBookingTransactionTypeRefContract();
                DataToContract(crudeFinancialBookingTransactionTypeRef, contract);
                list.Add(contract);
            }

            return(list);
        }
        // fetch all rows from table with an offset, and limit of rows
        // links:
        //  docLink: http://sql2x.org/documentationLink/a87e5c54-b47e-4031-bc3b-837b4cf9f692
        public List <CrudeFinancialBookingTransactionTypeRefModel> FetchAllWithLimitAndOffset(string limit, string offset)
        {
            var list = new List <CrudeFinancialBookingTransactionTypeRefModel>();
            List <CrudeFinancialBookingTransactionTypeRefData> dataList = CrudeFinancialBookingTransactionTypeRefData.FetchAllWithLimitAndOffset(int.Parse(limit), int.Parse(offset));

            foreach (CrudeFinancialBookingTransactionTypeRefData crudeFinancialBookingTransactionTypeRefBusiness in dataList)
            {
                var model = new CrudeFinancialBookingTransactionTypeRefModel();
                DataToModel(crudeFinancialBookingTransactionTypeRefBusiness, model);
                list.Add(model);
            }

            return(list);
        }