platformplatform / PlatformPlatform

🚀 Pre-alpha state. A platform designed for building enterprise-grade, multi-tenant products using Azure, .NET, React, TypeScript, Infrastructure as Code, etc.
https://platformplatform.github.io
MIT License
227 stars 25 forks source link

JSON columns/properties #535

Closed kswierszczyk closed 2 months ago

kswierszczyk commented 2 months ago

Contact Details

kuba.swierszczyk@gmail.com

Detailed description?

First off, WONDERFUL project! One thing I would like to see is making use of JSON objects. An example might be having the User entity include a MetaData or ExtraData property that is a typed object and uses the newer JSON features from EF and SQL server so that we can store complex objects (such as UserPreferences) as JSON. This would utilize the ef core ToJson feature where the generated queries use JSON_VALUE behind the scenes while LINQ code remains simple (_context.Users.Where(x=>x.UserPreferences.IsEnrolledInNotifications) for example

Feature Type

.NET

Code of Conduct