public void AddUsersToRoom(long roomId, List <long> userIdList)
{
using (var connection = new SqlConnection(_connectionString))
using (var cmd = connection.CreateCommand())
{
connection.Open();
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandText = AddUsersToRoomCmd;
cmd.Parameters.AddWithValue("@roomId", roomId);
cmd.Parameters.Add(TableUtil.CreateTableLong("@userList", userIdList));
cmd.ExecuteNonQuery();
}
}
