How to use Json data type in C# Entity Framework model?

Question

model.cs

[Column(TypeName = "json")]
    public string application_role { get; set; }

Its MySQL, data type of particular column is json, and how to add it in a model class. I tried with DataAnnotations but getting error as

The specified type member 'application_role' is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties are supported.

Linq Query to get data

context.sc_employee_details
                    .Where(e => e.user_name.Equals(userName))
                    .Select(o => o.application_role).SingleOrDefault();

Why not use it as string only? just serialize and deserialize ? — Hey24sheep
– Hey24sheep, Commented Nov 23, 2017 at 12:35
PraveenR You will need to serialize and deserialize json data as @Hey24sheep has indicated. I don't think you can handle json any other way. — Abhishek Maurya
– Abhishek Maurya, Commented Nov 23, 2017 at 12:42
@AbhishekMaurya removed DataAnnotations but still same error — Praveen R
– Praveen R, Commented Nov 23, 2017 at 12:47
@PraveenR I meant something like this newtonsoft.com/json/help/html/SerializingJSON.htm — Abhishek Maurya
– Abhishek Maurya, Commented Nov 23, 2017 at 12:51
@AbhishekMaurya I got it, some what like this? get { var ser = new JsonSerializer(); /// .. return ser.Deserialize<Car[]>(jr); } set { var ser = new JsonSerializer(); //... } — Praveen R
– Praveen R, Commented Nov 23, 2017 at 12:54

facundofarias · Accepted Answer · 2018-09-23 08:44:05Z

5

It might be a bit late, but EF on MySQL supports JSON format, here is announcement. Basically, you have to define an attribute like this one:

public JsonObject<string[]> Tags { get; set; } // Json storage

hope it helps!

answered Sep 23, 2018 at 8:44

facundofarias

3,04933 silver badges27 bronze badges

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

Comments

Hey24sheep · Accepted Answer · 2017-11-23 13:08:11Z

2

You will do something like this

   private string _application_role;
   public string application_role 
   { 
       get{
            return JsonConvert.DeserializeObject<string>(_application_role)
         } 
       set{
           _application_role = JsonConvert.SerializeObject(value);
         } 
   }

Or if you do not want to edit your model then you could do something like this

var myRole = context.sc_employee_details
                    .Where(e => e.user_name.Equals(userName))
                    .Select(o => o.application_role).SingleOrDefault();

if(myRole != null){
  var desRole = JsonConvert.DeserializeObject<string>(myRole);
}

edited Nov 23, 2017 at 13:08

answered Nov 23, 2017 at 13:03

Hey24sheep

1,2127 silver badges16 bronze badges

Collectives™ on Stack Overflow

How to use Json data type in C# Entity Framework model?

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related