VB.NET Cannot Convert ISingleResult to String
<p>I am having problems storing the result of my stored procedure inside of one of my datacontext. I have created a String variable called "A_Choice" that is to be used in saving the result of the stored procedure; however, my sp returns a value as System.Data.Linq.ISingleResult(Of IT_Web_Ticket_System.GetCategoryA_IDResult). How can I convert this result to string or even store this value at all. Here the offending code: </p>

<pre><code>Using database As New ITTaskDatabaseDataContext
            A_Choice = database.GetCategoryA_ID(CategoryAComboBox.SelectedValue.ToString())
End Using
</code></pre>

<p>Also, here is some WORKING code where I use the same DataContext that does not return a value:</p>

<pre><code>Using database As New ITTaskDatabaseDataContext
            CategoryBComboBox.ItemsSource = database.GetCategoryB()
            CategoryBComboBox.DisplayMemberPath = "Name"
            CategoryBComboBox.SelectedValuePath = "ID"
End Using
</code></pre>