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

SqlHierarchyId returning as null

3 Answers 61 Views
Databases and Data Types
This is a migrated thread and some comments may be shown as answers.
This question is locked. New answers and comments are not allowed.
DerekAlfonso
Top achievements
Rank 1
DerekAlfonso asked on 08 Jun 2012, 02:08 PM
Hello,

With version 2011.3.1129.2 running the following query successfully returns our objects with their proper SqlHierarchyIds:
ctx.BusinessAreaStructureDetails.ToList()

As soon as the project was upgraded 2012.1.427.1 the same query returns {Null} for each SqlHierarchyId.

Any help would be greatly appreciated, thanks!

3 Answers, 1 is accepted

Sort by
0
Accepted
Thomas
Telerik team
answered on 12 Jun 2012, 10:48 AM
Please make sure that the SqlHierarchyId fields have a proper mapping and check if they are eagerly loaded.
I checked this and I do not see a reason why it should fail on your side.
If the issue persists, please contact us again via Support, so that an .rlinq is attacheable.

All the best,
Thomas
the Telerik team
Follow @OpenAccessORM Twitter channel to be the first one to get the latest updates on new releases, tips and tricks and sneak peeks at our product labs!
0
DerekAlfonso
Top achievements
Rank 1
answered on 13 Jun 2012, 12:42 PM
Hi Thomas,

Switching the property's Load Behavior to either 'Eager' or 'Lazy' works.  Any thoughts on why 'Default' does not?

Thanks for the quick response and all your help!
0
Thomas
Telerik team
answered on 14 Jun 2012, 09:05 AM
Hi Bill,

very good question. I fear something is not correct with the default handling of this _struct_ that is not a known base CLR struct, but we will need more time to investigate this. Switching to eager could just correct an inconsistent default assumption there, I guess.

Kind regards,
Thomas
the Telerik team
Follow @OpenAccessORM Twitter channel to be the first one to get the latest updates on new releases, tips and tricks and sneak peeks at our product labs!
Tags
Databases and Data Types
Asked by
DerekAlfonso
Top achievements
Rank 1
Answers by
Thomas
Telerik team
DerekAlfonso
Top achievements
Rank 1
Share this question
or