title: How to use Json data type in C# Entity Framework model?
body: <pre><code>model.cs
  
  [Column(TypeName = "json")]
      public string application_role { get; set; }
  </code></pre>
  
  <p>Its MySQL, data type of particular column is <code>json</code>, and how to add it in a model class. I tried with DataAnnotations but getting error as</p>
  
  <pre><code>The specified type member 'application_role' is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties are supported.
  </code></pre>
  
  <p>Linq Query to get data</p>
  
  <pre><code>context.sc_employee_details
                      .Where(e =&gt; e.user_name.Equals(userName))
                      .Select(o =&gt; o.application_role).SingleOrDefault();
  </code></pre>