Save delimited string from SQL query as string array

Question

I am hoping to provide just enough information so as not to bore anyone.

I have a model that creates a user, which has various properties including an array of specializations:

public class User
{
    ...
    public string[] specializations { get; set; }
}

Part of my query retrieves the specializations as a delimited list:

STUFF(( SELECT  ';' + csc.description
        FROM    certified_specialization_code csc
            INNER JOIN  certified_specialization cs ON  csc.specialization_code = cs.specialization_code
        WHERE   cs.member_number = m.entity_number)
        FOR XML PATH('')), 1, 1, '' ) AS specializations,

I then take the query values and assign them to my model:

while (reader.Read())
{
    ...
    member.specializations = reader["specializations"];
    ...
}

What is the proper syntax to take that string and assign it to member.specializations, the string[]?

D Stanley · Accepted Answer · 2016-09-22T13:51:10.783

0

Just like you'd split any other string:

member.specializations = reader["specializations"].ToString()
                                                  .Split(';');

edited Sep 22 '16 at 13:51

answered Sep 21 '16 at 22:49

D Stanley

149,601
11
178
240

I thought so too, but I'm getting 'object' does not contain a definition for 'Split'... – Connie DeCinko Sep 21 '16 at 22:59
1

@ConnieDeCinko You are missing a `.ToString()` – Shnugo Sep 21 '16 at 23:00
Ok, got it to work. Had to add the .ToString() and then changed to use a different delimiter character as my semicolon was conflicting with the code for ampersand! – Connie DeCinko Sep 21 '16 at 23:07

Save delimited string from SQL query as string array

1 Answers1