How to serialize Linq to SQL data to JSON in C#

Question

I am trying to generate JSON. The data is there but it is my understanding that I need to serialize it for it to work. I'm a beginner in C# so the documentation on the newtonsoft site is a bit foreign to me. Here is my C# code.

public partial class Pages_ChartTest : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }

    [WebMethod]
    [ScriptMethod(ResponseFormat = ResponseFormat.Json)]
    public static IEnumerable<procReportSalesCountsResult> jsonData()
    {
        using (OpsDBDataContext dc = new OpsDBDataContext())
        {     
            return dc.ReportSalesCounts().ToList();          
        }   
    }
}

What is my final step to serialize. I pulled this data in using Linq To SQL in ASP. Thank you all.

If I make a get request in my JS file I get a 500 error. If I make a POST request from the same file and output to the console I get {"d":[{"__type":"procReportSalesCountsResult","MonthID":null,"SoldCount":74,"MonthName":"Jan"},{"__type":"procReportSalesCountsResult","MonthID":null,"SoldCount":74,"MonthName":"Feb"},{"__type":"procReportSalesCountsResult","MonthID":null,"SoldCount":114,"MonthName":"Mar"} — aaron
– aaron, Commented Sep 19, 2014 at 20:08
aside from some weird encoding (in 74 for the month Feb) what you pasted there (that I'm hoping wasn't in the original) and a missing ]} at the end (which I hope was in the original) that looks like valid JSON to me. Try pasting it into jsonlint.org — Matt Burland
– Matt Burland, Commented Sep 19, 2014 at 20:38
Unless you want it serialized some other way, no. You've told it you want json with the ResponseFormat = ResponseFormat.Json. — Matt Burland
– Matt Burland, Commented Sep 19, 2014 at 20:46

Stephen Kennedy · Accepted Answer · 2018-10-06 10:10:38Z

1

JSON isn't natively supported by .NET until 4.5. Download the Nuget package JSON.net by Newtonsoft, right from the VS package manager.

http://james.newtonking.com/json

public static string jsonData() {
    var buffer = null;
    using (OpsDBDataContext dc = new OpsDBDataContext()) {
        buffer = dc.ReportSalesCounts().ToList();
    } 
    return JsonConvert.SerializeObject(buffer);
}

edited Oct 6, 2018 at 10:10

Stephen Kennedy

21.8k24 gold badges99 silver badges114 bronze badges

answered Sep 19, 2014 at 20:11

Mark Dineen

4604 silver badges13 bronze badges

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

11 Comments

aaron Over a year ago

I did that. I brought in the newtonsoft namespace. Thank you for your reply. I just don't know how to implement it in my code

Mark Dineen Over a year ago

JsonConvert.SerializeObject(object) returns string

aaron Over a year ago

Thank you Mark. So like this? Sorry I'm just learning. public static IEnumerable<procReportSalesCountsResult> jsonData() { using (OpsDBDataContext dc = new OpsDBDataContext()) { return dc.ReportSalesCounts().ToList(); } JsonConvert.SerializeObject(dc.ReportSalesCounts().ToList()); }

Mark Dineen Over a year ago

Your comment isn't annotated as code, so a little hard to follow. It looks to my eye that you are creating a public static method to return an ienumerable, then in your using statement you're terminating it by returning the list. If I'm reading the above correctly, you're not going to see that json data. Perhaps: try instantiating an ienumerable above your using statement, set it equal to your counrs().ToList() in the using, then return the SerializeObject call's response.

Mark Dineen Over a year ago

There, added implementation above.

|

Collectives™ on Stack Overflow

How to serialize Linq to SQL data to JSON in C#

1 Answer 1

11 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

11 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related