Entity Framework Core API return table with .Include

Question

I have a Model with ICollection:

public class Blog
{
    public int Id { get; set; }

    [Required]
    public string Name { get; set; }

    public ICollection<Posts> Posts { get; set; }
}

This works with MVC:

public async Task<IActionResult> Index()
{
    return View(await _context.Blog.Include(l => l.Posts).ToListAsync());
}

I try to use API-Controller:

[Route("api/[controller]")]
[ApiController]
....
[HttpGet]
public IEnumerable<Blog> GetAll()
{
    return _context.Blog.Include(l => l.Posts).ToList();
}

This generate a error:

SyntaxError: JSON.parse: end of data after property value in object at line 1 column 44 of the JSON data

How to return a multidimensional Json with Blogs and for every Blog entry all Posts?

Seimann · Accepted Answer · 2018-09-01 12:15:16Z

2

Solution:

This is a error in JSON serialization.

Add in Startup.cs to Mvc ConfigureServices:

services.AddMvc()
            .AddJsonOptions(options => options.SerializerSettings.ReferenceLoopHandling = Newtonsoft.Json.ReferenceLoopHandling.Ignore);

answered Sep 1, 2018 at 12:15

Seimann

3931 gold badge3 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

axelio · Accepted Answer · 2018-08-31 13:21:16Z

0

Try this

[Route("api/[controller]")]
[ApiController]
 ....
[HttpGet]
public IActionResult GetAll()
{
   return Ok(_context.Blog.Include(l => l.Posts).ToList());
}

If you try async wrap IActionResult in Task

answered Aug 31, 2018 at 13:21

axelio

2371 silver badge6 bronze badges

1 Comment

Seimann Over a year ago

No, same problem "SyntaxError: JSON.parse: end of data after property value in object at line 1 column 44 of the JSON data" Return String is: [{"id":1,"name":"TestBlog","posts":[{"id":1

Collectives™ on Stack Overflow

Entity Framework Core API return table with .Include

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related