I have a column in my table which contains values as
Filters are separated by ';' and the values of each filter are separated by ','. There is a ':' in between a Filter's name and it's values.
Now, can I do anything which could fetch out the values part only? Like "123,234,34" for "FilterA". Or can I give it a number like "234" to search in the value part of "FilterA" and/or "54" in the value part of "FilterB"? I know it is possible with using regex, i guess, but I have no idea how.
You can't use regular expressions in Linq to Entities queries, because they cannot be translated into SQL. You even can't use
String.Split to split your filters by
;. You have two options here:
Foo_Filterwhich will link your entities to filters. And then create table
Filterswhich will contain filters data.