Error while reading data from database in c#

Question

I have an error in this code. I deserialize a JSON file and stored that data in the database now I want to show that data from my database.

using System;
using System.Collections.Generic;
using System.Threading.Tasks;
using System.Web.Helpers;
using System.Web.Mvc;

using ReadingFromDb.Dto;

namespace ReadingFromDb.Controller
{
    public class StudentController
    {
        [HttpGet]
        [AllowAnonymous]
        public async Task<JsonResult> GetStudents()
        {
            using (var context = new UNIEntities1())
            {
                var query = @"Select ";
                var dbQuery = context.Database.SqlQuery<StudentDto>(query);
                var list = await dbQuery.ToListAsync();
                return Json(list,JsonRequestBehavior.AllowGet);
            }
        }
    }
}

Error is:

JSON can not be used like method.

What should I do?

This looks like code from an ASP.NET MVC project - is that correct? — Tieson T.
– Tieson T., Commented Dec 5, 2019 at 6:46
Did you store the data in json format? If yes then why are you returning it as return Json() again. — Muhammad Aftab
– Muhammad Aftab, Commented Dec 5, 2019 at 6:50

Prashant Pimpale · Accepted Answer · 2019-12-05 06:55:52Z

2

Your contoller must be extend the base class Controller in which the Json() virtual method is available:

public class StudentController : Controller
{
  // your code
}

edited Dec 5, 2019 at 6:55

answered Dec 5, 2019 at 6:49

Prashant Pimpale

10.7k10 gold badges52 silver badges88 bronze badges

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

Comments

Muhammad Aftab · Accepted Answer · 2019-12-05 06:51:38Z

1

To resolve this error you can try as below

    public class StudentController : Controller
    {
      // your code
     }


    [HttpGet]
    [AllowAnonymous]
    public async Task<JsonResult> GetStudents()
    {
        using (var context = new UNIEntities1())
        {
            var list = await context.StudentDto.ToListAsync();
            return Json(list,JsonRequestBehavior.AllowGet);
        }
    }

answered Dec 5, 2019 at 6:51

Muhammad Aftab

1,1188 silver badges19 bronze badges

Comments

Selaka Nanayakkara · Accepted Answer · 2019-12-05 06:53:29Z

What you need to do is to extend your StudentCotroller with Controller then put your code under that.

using System;
using System.Collections.Generic;
using System.Threading.Tasks;
using System.Web.Helpers;
using System.Web.Mvc;

using ReadingFromDb.Dto;

namespace ReadingFromDb.Controller
{
    public class StudentController:Controller
    {
        [HttpGet]
        [AllowAnonymous]
        public async Task<JsonResult> GetStudents()
        {
            using (var context = new UNIEntities1())
            {
                var query = @"Select ";
                var dbQuery = context.Database.SqlQuery<StudentDto>(query);
                var list = await dbQuery.ToListAsync();
                return Json(list,JsonRequestBehavior.AllowGet);
            }
        }
    }
}

Collectives™ on Stack Overflow

Error while reading data from database in c#

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related