gistfile1.cs

        public static IList<OurServiceProduct>  GetServiceProducts()
        {
            var products = new List<OurServiceProduct>();
            var client = new RightNowSyncPortClient();
            client.ClientCredentials.UserName.UserName = "####";
            client.ClientCredentials.UserName.Password = "####";
            var clientInfoHeader = new ClientInfoHeader { AppID = "Basic Query CSV" };
            const string queryString = "SELECT ID,Name FROM SERVICEPRODUCT";

            try
            {
                CSVTableSet queryCSV = client.QueryCSV(clientInfoHeader, queryString, 10000);
                CSVTable[] csvTables = queryCSV.CSVTables;
                
                foreach (CSVTable table in csvTables)
                {
                    foreach (var row in table.Rows)
                    {
                        using(var x = new TextFieldParser(new StringReader(row)))
                        {
                            x.TextFieldType = FieldType.Delimited;
                            x.Delimiters = new string[]{","};
                            x.HasFieldsEnclosedInQuotes = true;
                            var rowColumns = x.ReadFields();
                            products.Add(new OurServiceProduct
                                                 {Id = Convert.ToInt32(rowColumns[0]), Name = rowColumns[1]});
                        }
                    }
                }
            }

            return products;
        }