Build comma seperated string from the struct in C#

Posted by acadia on Stack Overflow See other posts from Stack Overflow or by acadia
Published on 2010-06-15T13:28:26Z Indexed on 2010/06/15 13:32 UTC
Read the original article Hit count: 153

Filed under:

Hello, I have the following struct in C# class

public struct Employee
        {
            public const string EMPID = "EMP_ID";
            public const string FName = "FIRST_NAME";
            public const string LNAME = "LAST_NAME";
            public const string DEPTID = "DEPT_ID";

        }

Is there an easy way to build a string as follows

const string mainquery="INSERT INTO EMP(EMP_ID,FIRST_NAME,LAST_NAME,DEPT_ID) VALUES(:EMP_ID,:FIRST_NAME,:LAST_NAME,:DEPT_ID)"

Instead of doing as follows and then concatenating it.

const string EMP_COLS=
                EMPLOYEE.EMPID + "," +
                EMPLOYEE.FNAME + "," +
        EMPLOYEE.LNAME + "," +
                EMPLOYEE.DEPTID;

            const string EMP_Values=
                EMPLOYEE.EMPID + ":" +
                EMPLOYEE.FNAME + ":" +
        EMPLOYEE.LNAME + ":" +
                EMPLOYEE.DEPTID;

© Stack Overflow or respective owner

Related posts about c#