I have a Product and product has number of configurable options of different types, some types are simple: string, number, boolean and so on, but some are quite complex and contain various information, for exmaple details about booking:booing id, dates and location.
Currently we serialize option value as json string and just dump them in NVARCHAR(MAX). It is quite simple, however it is hard to implement efficient search for these values.
Is there any popular/good pattern for that problem?
Thanks
Aucun commentaire:
Enregistrer un commentaire