0

My Question is : What is the best way to represent multi select property in model and database, for performance , dynamic...Etc

I have these two approach :

1- the field in database is string and store an array of selected values.

2- the filed is foreign key to immediate table as many to many relation. which is best , Or there is another solution.

notice: I am using Lambda Expression to filter.

  • Dont even consider option 1 - [Is storing a delimited list in a database column really that bad?](https://stackoverflow.com/questions/3653462/is-storing-a-delimited-list-in-a-database-column-really-that-bad) –  Aug 31 '18 at 11:32
  • Thanks for answering , the best way is Option 2 ? – Mohammed Eyad Fakhanee Aug 31 '18 at 13:06

0 Answers0