Return Json Using PetaPoco Dynamic & WebAPI

Question

Is it possible to use PetaPoco dynamic query to return Json in the ASP.net WebAPI?

//WebAPI Controller

public class BranchController : ApiController
{
    public IEnumerable<dynamic> Get()
    {
        // Create a PetaPoco database object
        var db = new PetaPoco.Database("DefaultConnection");

        // Show all Branches
        var b = db.Query<dynamic>("SELECT * FROM Branches").ToList();

        return b;
    }

}

I am receiving an error

To be XML serializable, types which inherit from IEnumerable must have an implementation of Add(System.Object)

I've never used PetaPoco, but have you tried converting returned objects to dynamic JsonObject or JsonArray instances ? http://goo.gl/BaIx5 — cecilphillip, Apr 19 '12 at 04:15

score 2 · Accepted Answer · answered Apr 19 '12 at 18:11

2

JSON.Net handles this out of the box, so I Had to add a Custom Formatter.

This is the MSDN article I used to resolve the issue: http://code.msdn.microsoft.com/Using-JSONNET-with-ASPNET-b2423706

answered Apr 19 '12 at 18:11

MHop

3,053
3
17
13

Eduardo Molteni · Answer 2 · 2012-04-19T17:49:47.317

0

Since PetaPoco returns a List<dynamic> the real answer here is "Can WebApi return a Json from a List"?

The answer is yes, but WebApi has a thing called Content Negotiation than return Json or XML based on the request.

Try requesting Json or try this for XML:

    // Show all Branches
    return (IEnumerable<dynamic>)db.Query<dynamic>("SELECT * FROM Branches");

edited Apr 19 '12 at 17:49

answered Apr 19 '12 at 14:46

Eduardo Molteni

38,786
23
141
206

Return Json Using PetaPoco Dynamic & WebAPI

2 Answers2