dynamic sqlquery

ebagaipo

I have like this:

   public JsonResult GetAll()     
    {
        var list = _db.Database.SqlQuery<string>("SELECT * FROM  vwList for json path").FirstOrDefault();

        return Json(new
        {
            data = list
        }, JsonRequestBehavior.AllowGet);

    }

does anybody have an idea on how to pass the data to datatables?

TIA.

allan

That looks like all you need. Have DataTables' ajax option point a that controller to Ajax fetch the JSON data that will return.

Allan