How to add IDs from DB to an Array

Sbonga Mathobela

Hi all.

I need to select employeeID from tb_StaffMembers and put them in an Array.

here is my query:

var employIds = db.tb_staffMembers.Where(x => x.RoleId == 4).ToList().Select(x=>x.EmployeeId);

The query returns three IDs (2032, 2077, 2107) of which is correct.

now i want them in an array like : int [] array = new int[]{}

Please help.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

try this

string[] strArray = "2032, 2077, 2107".Split(',');
string[] strArray = employIds.Split(',');