JsonProperty.EFCore 2.6.2

JsonProperty.EFCore

About

This project allows you to use JSON fields in EF Core without setting up Fluent API

Instruction

Here are few steps how to use JsonProperty.EFCore project:

1. Connect the project and specify 'using'

   using JsonProperty.EFCore;
   

2. Create entity model

   public class Product
   {
       [Key, Required]
       public int Id { get; set; }
       public string? Name { get; set; }
       public decimal? Price { get; set; }
   }
   

   Or

   public class Note
   {
       [Key, Required]
       public int Id { get; set; }
       public string? Header { get; set; }
   }
   

3. Create a JSON collection item class if necessary

   public class TodoItem
   {
       public string? Text { get; set; }
       public bool? CompleteStatus { get; set; }
   }
   

4. Add JSON field property of type JsonEntity, JsonList or JsonDictionary to your entity model

   You can use the basic type like JsonEntity or JsonDictionary which uses elements of type object

   public class Product
   {
       [Key, Required]
       public int Id { get; set; }
       public string? Name { get; set; }
       public decimal? Price { get; set; }
   
       public JsonDictionary Parameters { get; set; } = new();
   }
   

   Or add property of generic type like JsonEnumerable<T> or JsonDictionary<TKey, TValue> with custom element type

   public class Note
   {
       [Key, Required]
       public int Id { get; set; }
       public string? Header { get; set; }
   
       public JsonEnumerable<TodoItem> Todos { get; set; } = new();
   }
   

5. Usage example:

   Here is example for JsonDictionary

   Product product = new() {Name="Phone",Price=500.95m,Amount=21,Parameters={
       VirtualDictionary = new Dictionary<string,object>() {
           {"Camera",13.5 },{"OS","Android" },{"Screen","1080x900"},{"Storage",32}
       }
   }};
   db.Goods.Add(product);
   db.SaveChanges();
   

   This will generate the following JSON data into the corresponding table string field:

   { "Camera": 13.5, "OS": "Android", "Screen": "1080x900", "Storage": 32 }
   

   And here is example for JsonEnumerable<T>

   Note note = db.Notes.FirstOrDefault();
   note.Todos.Edit(en => en.Append(new("MyTodoItemTitle")));
   

   And here is also the result in JSON:

   [ ... , { "Text": "MyTodoItemTitle", "CompleteStatus": false }]