Converting a database table into JSON stream

Question

I have a key-value pair database table and need to convert it to a JSON stream programmaticlally using C#.

My table structure:

Table1
__________
Category
Title
Type
StageNumber
LineNumber
Key
Value

So I am going to need all of the fields: Category, Title, Type, StageNumber, LineNumber, and then the Key and Value in my stream.

I have created a class:

public class MyRecord
{

    public string Title { get; set; }
    public string Type { get; set; }
    public string Category { get; set; }
    public int StageNumber { get; set; }
    public int LineNumber { get; set; }
    public string FieldKey { get; set; }
    public string FieldValue { get; set; }
}

I am new to JSON, so could someone please point me in the right direction on how to proceed?

Fill your object *MyRecord*, than call *JsonConvert.SerializeObject*, that is all. — EZI, Jul 24 '15 at 16:22
I am new to this so I am going top need more details and some samples — Coding Duchess, Jul 24 '15 at 16:23

score 2 · Accepted Answer · answered Jul 24 '15 at 16:24

2

the simplest way is:

var obj = new MyRecord();
var json = new JavaScriptSerializer().Serialize(obj);

For what you need a stream?

answered Jul 24 '15 at 16:24

burning_LEGION

13,246
8
40
52

How do I fill obj with several instances of class MyRecord? – Coding Duchess Jul 24 '15 at 16:44
var obj = new List(); var json = new JavaScriptSerializer().Serialize(obj); – burning_LEGION Jul 24 '15 at 16:46
List lst = ....; var json = new JavaScriptSerializer().Serialize(lst); <--ERROR HERE "The length of a string exceeds the maxJSonLength property". I filled lst from the database with about 53K records. – Coding Duchess Jul 29 '15 at 13:17
@ElenaDBA it's another issue, look this http://stackoverflow.com/questions/1151987/can-i-set-an-unlimited-length-for-maxjsonlength-in-web-config – burning_LEGION Jul 29 '15 at 13:39

score -1 · Answer 2 · answered Jul 24 '15 at 16:37

-1

//Serialize var obj = new MyRecord(); var json = new JavaScriptSerializer().Serialize(obj);

//Deserialize var obj = new JavaScriptSerializer().Deserialize(obj);

answered Jul 24 '15 at 16:37

SP007

1,871
1
22
31

Converting a database table into JSON stream

2 Answers2