JsonResult ASP.NET Entity Framework Core Error

Question

I am creating an app through ASP.Net Core 1.0 and EF Core. I have my models and my view model mapped out with AutoaMapper.

When I create a controller and call it, I get this error:

Error Number:208,State:1,Class:16 Exception thrown: 'System.Data.SqlClient.SqlException' in Microsoft.EntityFrameworkCore.dll CRAMSCore1.Models.CramsRepository:Error: Error getting complaints Microsoft.AspNetCore.Mvc.Formatters.Json.Internal.JsonResultExecutor:Information: Executing JsonResult, writing value.

When I check my Sql Profiler on SSMS, I do see that it is querying the database with:

SQL:BatchCompleted SELECT [c].[COMP_ID], [c].[AddrCity], [c].[AddrState], [c].[AddrZip], [c].[Address], [c].[CRORoute_DT] FROM [Complaints] AS [c] Core .Net SqlClient Data Provider

My Repository looks very simple:

public IEnumerable<COMPLAINT> getAll()
    {
        try
        {
            return _context.Complaints
                .ToList();
        }
        catch (Exception ex)
        {
            _logger.LogError("Error getting complaints", ex);
            return null;
        }
    }

My controller looks like:

[HttpGet("")]
    public JsonResult Get()
    {
        var complaints = _repository.getAll();
        var results = Mapper.Map<IEnumerable<ComplaintViewModel>>(complaints);
        return Json(complaints);
    }

rborob · Accepted Answer · 2016-07-15 15:55:03Z

1

What does running that SQL manually give you? The error doesn't appear to have anything to do with your JSONResult but more to do with the retrieval of data from SQL via the EF.

I'm also guessing your return should be

return Json(results);

answered Jul 15, 2016 at 15:55

rborob

381 silver badge4 bronze badges

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

1 Comment

enavuio Over a year ago

It appears my DBcontext isn't working like it was when it was EF7. I'll have to debug that...

Collectives™ on Stack Overflow

JsonResult ASP.NET Entity Framework Core Error

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related