Saving JSON objects to SQL Server database

Question

What is the best way to save JSON objects to a SQL Server database? How can I save the deserialized objects to a database instead of outputting to the console? Maybe I could use Entity Framework? Hope somebody can put me on the right track. Thanks

public class Program
{
    static void Main(string[] args)
    {
        string json = @"{
       'Email': '[email protected]',
       'Active': true,
       'CreatedDate': '2015-01-20T00:00:00Z'}";

        Account account = JsonConvert.DeserializeObject<Account>(json);

        Console.WriteLine(account.Email);
        Console.WriteLine(account.CreatedDate);
        Console.ReadKey();
    }
}

Account.cs

public class Account
{
    public string Email { get; set; }
    public DateTime CreatedDate { get; set; }
}

You want to save the Deserialized object to database? Or the Serialized string? Create a insert statement, use the property values from deserialized object and insert into db. — Amit Kumar Ghosh
– Amit Kumar Ghosh, Commented Feb 26, 2016 at 10:33

nithin · Accepted Answer · 2016-02-26 10:38:25Z

4

public class Program
{
    static void Main(string[] args)
    {
        string json = @"{
       'Email': '[email protected]',
       'Active': true,
       'CreatedDate': '2015-01-20T00:00:00Z'}";

        Account account = JsonConvert.DeserializeObject<Account>(json);

        string email=account.Email.ToString();
        DateTime date=account.CreatedDate.ToDateTime();

      //Open a connection with database.Write a insert query and provide these values and run the query.
    }
}

answered Feb 26, 2016 at 10:38

nithin

1,6102 gold badges17 silver badges26 bronze badges

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

Collectives™ on Stack Overflow

Saving JSON objects to SQL Server database

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related