Dapper Tutorial - Knowledge Base (KB)

How to return JSON not associative array

I'm writing simple API which returns array of JSON objects:...[ { "Id": 134649, "Type_id": 6, "Latitude": 56.904220, "Longitude":14.823440 }, { "Id": 134660, "Type_id": 6, "Latitude": 56....

Dapper ORM with dynamic model - How to return no field instead of 'Field' = NULL?

I'm using dapper with dynamic return model objects and I'd like to configure it to 'skip' fields which are null....For instance instead of :...[0]: {DapperRow, Type = 'PHYS', Street1 = NULL, Street2 = NULL, State = CO} ...I'd like Dapper to return...[0]: ...

Unexpected end when setting [PARAMETER]'s Value - Visual Studio says string is not valid JSON when online validators say it is

I have a SQL stored procedure returning a very large complex JSON string as its result through the use of ...FOR JSON PATH... and a set of ...JSON_QUERY..., and am attempting to convert this String to an object using ...JsonConvert.DeserializeObject<MyObj...