How would I map an array or list of value types to a single column in my table? The example is this...

The customer class has a property "CustomerTypes" and is a simple string array or a generic string list. My database has a table "Customers" with a nvarchar field "CustomerTypes".

I want to be able to store the types as a simple nvarchar value in the customers table, but work with them as an array or IList<string>.

I cannot figure this out. I am sure it is simple to do.

Any help greatly appreciated!

Kevin

You can write a user type to do this for you.
A word of caution first, there is a reason why databases doesn't support this natively, it goes against the way they operate, and likely to land you into trouble further down the road.

Yes, I think I am going to go ahead and create a separate table to support this. Thanks.

Kevin