How to create a SQL Server table from a json.net model with Entity Framework

Question

If I had a simple model

public class Company
{
        [JsonProperty("id")]
        public int Id { get; set; }

        [JsonProperty("name")]
        public string Name { get; set; }
}

How would I convert this model into a SQL Server table with Entity Framework code-first?

you can generate the entities and the DbContext wiht T4 Templating with json but this is a hardware work and I do not think you want to do that! — Bassam Alugili
– Bassam Alugili, Commented May 21, 2016 at 19:57

Admir Tuzović · Accepted Answer · 2016-05-21 20:03:06Z

1

Answer to your question would actually end up being a full tutorial.

That said, I suggest that you visit the following website and get yourself familiar with Entity Framework Code First concepts:

http://www.entityframeworktutorial.net/code-first/entity-framework-code-first.aspx

Mentioned tutorial has both conceptual overview as well as code samples.

Once you are done with tutorial, you will understand the following code snippet:

public class ApplicationContext : DbContext
{
     public DbSet<Company> Companies { get; set; }
}

Then you need to create adequate migration and apply it to your database which will end up with creation of "Companies" or "Company" table (depending on EF version you are using).

edited May 21, 2016 at 20:03

answered May 21, 2016 at 19:48

Admir Tuzović

11.2k7 gold badges38 silver badges75 bronze badges

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

5 Comments

Demarily Over a year ago

Can I use Entity and json.net annatations together?

Admir Tuzović Over a year ago

@Demarily Yes, although it is a bad practice to use same classes as domain models and API models. Your API models should expose only those properties that client apps (i.e. mobile app or JavaScript app) use, and not entire entity model.

Demarily Over a year ago

It will be an import from the api json data to sql server. Would it still be bad practice?

Admir Tuzović Over a year ago

@Demarily Well if that is only usage case and you have 1:1 mapping of API to SQL, it could go by. But i.e. if your entity class has property IsAdmin and you want to set that programmatically only (through code), exposing that property publicly could result in user setting himself as admin through your API.

Demarily Over a year ago

Perfect. Thank you for your time. I would have tried the questions myself on my code but my laptop is at the office. I'm just doing research right now. Thank again.

Collectives™ on Stack Overflow

How to create a SQL Server table from a json.net model with Entity Framework

1 Answer 1

5 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Related