SQLException: Insufficient result space to convert uniqueidentifier value to char.

2 posts, 0 answers
  1. Ben Collins
    Ben Collins avatar
    1 posts
    Member since:
    Feb 2010

    Posted 25 Feb 2010 Link to this post

    We use uniqueidentifier fields as primary keys in our application but our data transfer objects use strings, when I try to compare the two using .ToString() I get the following exception:

    Telerik.OpenAccess.RT.sql.SQLException: Insufficient result space to convert uniqueidentifier value to char.

    What am I doing wrong?

    Sample code:
    var person = (from p in Scope.Extent<Person>() 
                                     where p.PersonId.ToString() == id 
                                     select p).SingleOrDefault(); 
     





  2. Damyan Bogoev
    Admin
    Damyan Bogoev avatar
    581 posts

    Posted 25 Feb 2010 Link to this post

    Hi Ben Collins,

    Pushing Guid.ToString() to be executed on the server is already implemented. You can upgrade to the latest version of Telerik OpenAccess ORM (2009.3.1317) where the fix is available.
    Hope that helps.

    Sincerely yours,
    Damyan Bogoev
    the Telerik team

    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
  3. DevCraft banner
Back to Top