This is a migrated thread and some comments may be shown as answers.

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

1 Answer 176 Views
LINQ (LINQ specific questions)
This is a migrated thread and some comments may be shown as answers.
This question is locked. New answers and comments are not allowed.
Ben Collins
Top achievements
Rank 1
Ben Collins asked on 25 Feb 2010, 08:14 AM
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(); 
 





1 Answer, 1 is accepted

Sort by
0
Damyan Bogoev
Telerik team
answered on 25 Feb 2010, 07:23 PM
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.
Tags
LINQ (LINQ specific questions)
Asked by
Ben Collins
Top achievements
Rank 1
Answers by
Damyan Bogoev
Telerik team
Share this question
or