How can I store a list or dictionary type into SQL as a single variable?
c#, sql, sqldatatypes, types
Solution
You could store a serialized (XML) version of an object in SQL server
Problem
I need to use a data type like list or dictionary in a class. All of this data needs to be stored into SQL. Is it possible to use them with SQL directly or do I have to transfer them into other data type like string to use with SQL? The problem is that I can't guarantee any symbol will never be used in the data, so I don't know how to separate the data to transfer them from string to list. For example, the data I need to use is: `Dictionary<string, int> topics;` there can be anything in the string key. How can I store this into SQL as one variable?