I want to create a table that will generate this kind of JSON string:
{
"imagename": "Picture1",
"date": "03.09.2014",
"customer": {
"customernumber": "8",
"name": "any customer name"
}
}
-
1What code have you already tried? Please see What topics can I ask about here?, How do I ask a good question? and How to create a Minimal, Complete, and Verifiable example.Makyen– Makyen ♦2015-02-04 05:26:12 +00:00Commented Feb 4, 2015 at 5:26
-
no, i dont need any code for this, just table schema for sqlserverGopal– Gopal2015-02-04 05:34:13 +00:00Commented Feb 4, 2015 at 5:34
-
because i want to create table for storing those values and when i convert sql to json it should be like thisGopal– Gopal2015-02-04 05:35:09 +00:00Commented Feb 4, 2015 at 5:35
-
1What have you already tried?Makyen– Makyen ♦2015-02-04 05:41:51 +00:00Commented Feb 4, 2015 at 5:41
Add a comment
|
1 Answer
Create the table as is but exclude the field customer, something like this:
CREATE TABLE [dbo].[aTable](
[ImageName] [nchar](10) NULL,
[Date] [nchar](10) NULL,
[CustomerNumber] [nchar](10) NULL,
[Name] [nchar](10) NULL
) ON [PRIMARY]
Select data from the table and create a dynamic object to assign the data (hard coded values as example):
var dyna = new {imageName = "Picture1", date = "03.02.2014", customer = new {customerNumber = "8", name = "any cust name"}};
Then serialize the dyna object using a JSON serializer.
1 Comment
Gopal
thank you so much for helping me on this. it worked for me. great efforts