public void Transform()
        {
            var properties = new List<IRespondWithProperty>();

            var property = Response.Tables["Properties"].AsEnumerable()
                .Select(s => new PropertyModel(
                    GetIntRowValue(s, "sr_id"),
                    GetDecimalRowValue(s, "prop_id"),
                    GetDecimalRowValue(s, "PROPTYPE_ID"),
                    GetDecimalRowValue(s, "SS_ID"),
                    GetStringRowValue(s, "property_type"),
                    GetStringRowValue(s, "PROVINCE"),
                    GetStringRowValue(s, "MUNICNAME"),
                    GetStringRowValue(s, "DEEDTOWN"),
                    GetStringRowValue(s, "FARMNAME"),
                    GetStringRowValue(s, "SECTIONAL_TITLE"),
                    GetIntRowValue(s, "UNIT"),
                    GetDecimalRowValue(s, "PORTION"),
                    GetStringRowValue(s, "BUYER_NAME"),
                    GetStringRowValue(s, "FIRSTNAME"),
                    GetStringRowValue(s, "MIDDLENAME"),
                    GetStringRowValue(s, "MIDDLENAME2"),
                    GetStringRowValue(s, "MIDDLENAME3"),
                    GetStringRowValue(s, "SURNAME"),
                    GetStringRowValue(s, "PERSON_TYPE_ID"),
                    GetStringRowValue(s, "BUYER_IDCK"),
                    GetDecimalRowValue(s, "MUNIC_ID"),
                    GetDecimalRowValue(s, "PROV_ID"),
                    GetStringRowValue(s, "STREET_NUMBER"),
                    GetStringRowValue(s, "STREET_TYPE"),
                    GetStringRowValue(s, "PO_CODE"),
                    GetGuidRowValue(s, "user_id"),
                    GetIntRowValue(s, "GARAGE"),
                    GetStringRowValue(s, "SS_Number"),
                    GetIntRowValue(s, "SS_UnitNoFrom"),
                    GetIntRowValue(s, "SS_UnitTo"),
                    GetDoubleRowValue(s, "Size"),
                    GetDoubleRowValue(s, "X"),
                    GetDoubleRowValue(s, "Y"),
                    GetStringRowValue(s, "SUBURB"),
                    GetStringRowValue(s, "Title_Deed_No"),
                    GetStringRowValue(s, "Reg_Date"),
                    GetStringRowValue(s, "TownShip"),
                    GetIntRowValue(s, "Purchase_Price"),
                    GetIntRowValue(s, "Purchase_Date"),
                    GetStringRowValue(s, "Bond_Number"),
                    GetStringRowValue(s, "Township_alt"),
                    GetStringRowValue(s, "ADD_Description"),
                    GetIntRowValue(s, "sub_id"),
                    GetIntRowValue(s, "street_id"),
                    GetStringRowValue(s, "Active_Status"),
                    GetStringRowValue(s, "Estate_Name"),
                    GetIntRowValue(s, "est_id"),
                    GetIntRowValue(s, "ReqStatus_ID"),
                    GetBoolRowValue(s, "estimatedcad")));

            properties.AddRange(property);
            Result = new LightstonePropertyResponse(properties);
            Result.AddResponseState(Result.PropertyInformation.Any() ? DataProviderResponseState.Successful : DataProviderResponseState.NoRecords);
        }
 public Lace.Domain.Core.Entities.LightstonePropertyResponse Default()
 {
     var result = new Lace.Domain.Core.Entities.LightstonePropertyResponse(new List<IRespondWithProperty>()
     {
         new PropertyModel(0, 0M, 0M, 0M, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty,
             string.Empty, 0, 0M, string.Empty, string.Empty, string.Empty, string.Empty, string.Empty,
             string.Empty, string.Empty, string.Empty, 0M, 0M, string.Empty, string.Empty, string.Empty,
             Guid.Empty, 0, string.Empty, 0, 0, 0D, 0D, 0D, string.Empty, string.Empty, string.Empty,
             string.Empty, 0, 0, string.Empty, string.Empty, string.Empty, 0, 0M, string.Empty, string.Empty, 0,
             0, false)
     });
     result.AddResponseState(DataProviderResponseState.NoRecords);
     return result;
 } 
 private static void NotHandledResponse(ICollection<IPointToLaceProvider> response)
 {
     var propertyResponse = new LightstonePropertyResponse();
     propertyResponse.HasNotBeenHandled();
     response.Add(propertyResponse);
 }