I have clr code that is using fastjson to turn a dataset into a json string using
return fastJSON.JSON.Instance.ToJSON(dData);
this is using all default parameters.
in my testing of the library, I go from dataset to json, then from json back to the dataset with no problem
However,
I have a web service that I use to call the stored procedure.
the results look identical, but this call:
DataSet dsJSON = (DataSet)fastJSON.JSON.Instance.ToObject<dataset>(jData);
blows up with 'cannot determine type' on this line of the result:
tn "fastJSON.DatasetSchema, SMERoutines, Version=7.3.0.0, Culture=neutral, PublicKeyToken=ff4db5626e8814fb" object {string}
SMERoutines is the CLR library that is generating the result.
I am not sure how to continue with this.
Any ideas how I can troubleshoot/fix?
the full string being returned from the clr code is:
{"$schema":{"$types":{"fastJSON.DatasetSchema, SMERoutines, Version=7.3.0.0, Culture=neutral, PublicKeyToken=ff4db5626e8814fb":"1"},"$type":"1","Info":["TABLE","RecUID","System.Int64","TABLE","UID","System.String","TABLE","SalesUID","System.String","TABLE","Created","System.DateTime","TABLE","Name","System.String","TABLE","AccountNumber","System.String","TABLE","Division","System.String","TABLE","DivisionUID","System.String","TABLE","SMPSystem","System.String","TABLE","SMPSystemUID","System.String","TABLE","WarrantyExp","System.DateTime","TABLE","Address1","System.String","TABLE","Address2","System.String","TABLE","City","System.String","TABLE","St","System.String","TABLE","Zip","System.String","TABLE","Contact","System.String","TABLE","Phone","System.String","TABLE","Fax","System.String","TABLE","Cell","System.String","TABLE","Pager","System.String","TABLE","Email","System.String","TABLE","AddressBlock","System.String","TABLE","fPhone","System.String","TABLE","fFax","System.String","TABLE","fCell","System.String","TABLE","fPager","System.String","TABLE","ContactUID","System.String","TABLE","Country","System.String","TABLE","Zone","System.String","TABLE","ZoneUID","System.String","TABLE","PhoneLbl","System.String","TABLE","FaxLbl","System.String","TABLE","CellLbl","System.String","TABLE","PagerLbl","System.String","TABLE","BillName","System.String","TABLE","BillAddress1","System.String","TABLE","BillAddress2","System.String","TABLE","BillCity","System.String","TABLE","BillZip","System.String","TABLE","BillContact","System.String","TABLE","BillPhone","System.String","TABLE","BillSt","System.String","TABLE","BillFax","System.String","TABLE","BillingEmail","System.String","TABLE","BillAddressBlock","System.String","TABLE","fBillPhone","System.String","TABLE","fBillFax","System.String","TABLE","BillContactUID","System.String","TABLE","BillCountry","System.String","TABLE","BillingUID","System.String","TABLE","BillPhoneLbl","System.String","TABLE","BillFaxLbl","System.String","TABLE","Installer","System.String","TABLE","InstallerUID","System.String","TABLE","SalesPerson","System.String","TABLE","SalesPersonUID","System.String","TABLE","BusinessType","System.String","TABLE","BusinessTypeUID","System.String","TABLE","TaxID","System.String","TABLE","TaxGroup","System.String","TABLE","TaxGroupUID","System.String","TABLE","Terms","System.String","TABLE","TermUID","System.String","TABLE","DateMoved","System.DateTime","TABLE","Directions","System.String","TABLE","Notes","System.String","TABLE","SiteNotes","System.String","TABLE","SalesNotes","System.String","TABLE","CSRNotes","System.String","TABLE","PONumRequired","System.Boolean","TABLE","URL","System.String","TABLE","LDCarrier","System.String","TABLE","LDCarrierUID","System.String","TABLE","Tech1","System.String","TABLE","Tech1UID","System.String","TABLE","Tech2","System.String","TABLE","Tech2UID","System.String","TABLE","CreditCardType","System.String","TABLE","CCTypeUID","System.String","TABLE","CreditCardName","System.String","TABLE","Comments","System.String","TABLE","Current30","System.Decimal","TABLE","Net30","System.Decimal","TABLE","Net60","System.Decimal","TABLE","Net90","System.Decimal","TABLE","YTD","System.Decimal","TABLE","Balance","System.Decimal","TABLE","Status","System.String","TABLE","DepositOnAccount","System.Decimal","TABLE","LastService","System.DateTime","TABLE","UseCustRates","System.Boolean","TABLE","TripCharge","System.Decimal","TABLE","LaborRate","System.Decimal","TABLE","CreditLimit","System.Decimal","TABLE","MaintCost","System.Decimal","TABLE","MaintExp","System.DateTime","TABLE","Premium","System.Decimal","TABLE","MatTaxRate","System.Decimal","TABLE","LaborTaxRate","System.Decimal","TABLE","OrderTaxRate","System.Decimal","TABLE","ServiceTaxRate","System.Decimal","TABLE","ExciseTaxRate","System.Decimal","TABLE","FinanceCharge","System.Decimal","TABLE","MatPriceLvl","System.Int16","TABLE","MailName","System.String","TABLE","MailAddress1","System.String","TABLE","MailAddress2","System.String","TABLE","MailCity","System.String","TABLE","MailSt","System.String","TABLE","MailZip","System.String","TABLE","MailContact","System.String","TABLE","MailPhone","System.String","TABLE","MailingEmail","System.String","TABLE","MailAddressBlock","System.String","TABLE","fMailPhone","System.String","TABLE","MailContactUID","System.String","TABLE","MailCountry","System.String","TABLE","MailPhoneLbl","System.String","TABLE","MailAddInvoice","System.Boolean","TABLE","MailAddLabel","System.Boolean","TABLE","LastAction","System.DateTime","TABLE","IsActive","System.Boolean","TABLE","Messages","System.String","TABLE","MsgMaint","System.Boolean","TABLE","MsgWarr","System.Boolean","TABLE","MsgPastDue","System.Boolean","TABLE","IsBillable","System.Boolean","TABLE","CustID","System.String","TABLE","QBModified","System.DateTime","TABLE","IAccountID","System.String","TABLE","IAccountName","System.String","TABLE","PAccountID","System.String","TABLE","PAccountName","System.String","TABLE","DAccountID","System.String","TABLE","DAccountName","System.String","TABLE","ParentID","System.String","TABLE","QBTaxID","System.String","TABLE","QBExport","System.Boolean","TABLE","FullName","System.String","TABLE","MinService","System.Decimal","TABLE","MinHours","System.Decimal","TABLE","MinServiceUID","System.String","TABLE","ServiceMsg","System.Boolean","TABLE","MinHoursUID","System.String","TABLE","HoursMsg","System.Boolean","TABLE","AddExciseTax","System.Boolean","TABLE","QBNonTaxed","System.Boolean","TABLE","ClassID","System.String","TABLE","ClassUID","System.String","TABLE","Class","System.String","TABLE","PriceBookUID","System.String","TABLE","PriceBook","System.String","TABLE","LocationUID","System.String","TABLE","Location","System.String","TABLE","ConvertDate","System.DateTime","TABLE","DocDir","System.String","TABLE","CertCodeUID","System.String","TABLE","CertCode","System.String","TABLE","HasLead","System.Boolean","TABLE","FormCode","System.String","TABLE","WhoEdit","System.String","TABLE","EditDateTime","System.DateTime","TABLE","EditCount","System.Int32","TABLE","EditModule","System.String","TABLE","EditTimeStamp","System.Byte[]","TABLE","LocationID","System.String","TABLE","EditUID","System.String","TABLE","SLACatUID","System.String","TABLE","SLACategory","System.String","TABLE","ItemBalance","System.Decimal","TABLE","HoursBalance","System.Decimal"],"Name":"NewDataSet"},"TABLE":[]}
|