Hi, i`m having the error message
could not load an entity: [API.Issue#8087][SQL: SELECT issue0_.ID as ID1_14_, issue0_.ProjectID as ProjectID1_14_, issue0_.Summary as Summary1_14_, issue0_.Description as Descript4_1_14_, issue0_.CategoryID as CategoryID1_14_, issue0_.PriorityID as PriorityID1_14_, issue0_.CreationDate as Creation7_1_14_, issue0_.CreatedBy as CreatedBy1_14_, issue0_.ExpectedResolutionDate as Expected9_1_14_, issue0_.ResolutionID as Resolut10_1_14_, issue0_.Closed as Closed1_14_, issue0_.ClosedDate as ClosedDate1_14_, issue0_.ClosedBy as ClosedBy1_14_, issue0_.ClosedReason as ClosedR14_1_14_, issue0_.StatusID as StatusID1_14_, issue0_.AssignedTo as AssignedTo1_14_, issue0_.Reference1 as Reference17_1_14_, issue0_.Reference2 as Reference18_1_14_, issue0_.Reference3 as Reference19_1_14_, issue0_.Reference4 as Reference20_1_14_, issue0_.Reference5 as Reference21_1_14_, issue0_.SourceIssueID as SourceI22_1_14_, issue0_.ProjectPriority as Project23_1_14_, project1_.ID as ID8_0_, project1_.Name as Name8_0_, project1_.BasecampURL as Basecamp3_8_0_, project1_.Basecamp as Basecamp8_0_, category2_.ID as ID0_1_, category2_.Name as Name0_1_, category2_.ProjectID as ProjectID0_1_, project3_.ID as ID8_2_, project3_.Name as Name8_2_, project3_.BasecampURL as Basecamp3_8_2_, project3_.Basecamp as Basecamp8_2_, priority4_.ID as ID17_3_, priority4_.Name as Name17_3_, priority4_.ProjectID as ProjectID17_3_, project5_.ID as ID8_4_, project5_.Name as Name8_4_, project5_.BasecampURL as Basecamp3_8_4_, project5_.Basecamp as Basecamp8_4_, user6_.ID as ID9_5_, user6_.Name as Name9_5_, user6_.Password as Password9_5_, user6_.RoleID as RoleID9_5_, user6_.LastLoginDate as LastLogi5_9_5_, user6_.Deleted as Deleted9_5_, user6_.DeletionDate as Deletion7_9_5_, user6_.CustomerID as CustomerID9_5_, user6_.Email as Email9_5_, user6_.MyProjectsViewAll as MyProje10_9_5_, customer7_.ID as ID7_6_, customer7_.Name as Name7_6_, resolution8_.ID as ID2_7_, resolution8_.Name as Name2_7_, resolution8_.ProjectID as ProjectID2_7_, project9_.ID as ID8_8_, project9_.Name as Name8_8_, project9_.BasecampURL as Basecamp3_8_8_, project9_.Basecamp as Basecamp8_8_, user10_.ID as ID9_9_, user10_.Name as Name9_9_, user10_.Password as Password9_9_, user10_.RoleID as RoleID9_9_, user10_.LastLoginDate as LastLogi5_9_9_, user10_.Deleted as Deleted9_9_, user10_.DeletionDate as Deletion7_9_9_, user10_.CustomerID as CustomerID9_9_, user10_.Email as Email9_9_, user10_.MyProjectsViewAll as MyProje10_9_9_, status11_.ID as ID10_10_, status11_.Name as Name10_10_, status11_.ProjectID as ProjectID10_10_, project12_.ID as ID8_11_, project12_.Name as Name8_11_, project12_.BasecampURL as Basecamp3_8_11_, project12_.Basecamp as Basecamp8_11_, user13_.ID as ID9_12_, user13_.Name as Name9_12_, user13_.Password as Password9_12_, user13_.RoleID as RoleID9_12_, user13_.LastLoginDate as LastLogi5_9_12_, user13_.Deleted as Deleted9_12_, user13_.DeletionDate as Deletion7_9_12_, user13_.CustomerID as CustomerID9_12_, user13_.Email as Email9_12_, user13_.MyProjectsViewAll as MyProje10_9_12_, issue14_.ID as ID1_13_, issue14_.ProjectID as ProjectID1_13_, issue14_.Summary as Summary1_13_, issue14_.Description as Descript4_1_13_, issue14_.CategoryID as CategoryID1_13_, issue14_.PriorityID as PriorityID1_13_, issue14_.CreationDate as Creation7_1_13_, issue14_.CreatedBy as CreatedBy1_13_, issue14_.ExpectedResolutionDate as Expected9_1_13_, issue14_.ResolutionID as Resolut10_1_13_, issue14_.Closed as Closed1_13_, issue14_.ClosedDate as ClosedDate1_13_, issue14_.ClosedBy as ClosedBy1_13_, issue14_.ClosedReason as ClosedR14_1_13_, issue14_.StatusID as StatusID1_13_, issue14_.AssignedTo as AssignedTo1_13_, issue14_.Reference1 as Reference17_1_13_, issue14_.Reference2 as Reference18_1_13_, issue14_.Reference3 as Reference19_1_13_, issue14_.Reference4 as Reference20_1_13_, issue14_.Reference5 as Reference21_1_13_, issue14_.SourceIssueID as SourceI22_1_13_, issue14_.ProjectPriority as Project23_1_13_ FROM Issue issue0_ left outer join Project project1_ on issue0_.ProjectID=project1_.ID left outer join Category category2_ on issue0_.CategoryID=category2_.ID left outer join Project project3_ on category2_.ProjectID=project3_.ID left outer join Priority priority4_ on issue0_.PriorityID=priority4_.ID left outer join Project project5_ on priority4_.ProjectID=project5_.ID inner join [User] user6_ on issue0_.CreatedBy=user6_.ID left outer join Customer customer7_ on user6_.CustomerID=customer7_.ID left outer join Resolution resolution8_ on issue0_.ResolutionID=resolution8_.ID left outer join Project project9_ on resolution8_.ProjectID=project9_.ID left outer join [User] user10_ on issue0_.ClosedBy=user10_.ID left outer join Status status11_ on issue0_.StatusID=status11_.ID left outer join Project project12_ on status11_.ProjectID=project12_.ID left outer join [User] user13_ on issue0_.AssignedTo=user13_.ID left outer join Issue issue14_ on issue0_.SourceIssueID=issue14_.ID WHERE issue0_.ID=?]
orignalIssue = GetPrivateSession().Load<Issue>(ID); where
static Session GetPrivateSession()
{
return new Session(sessionFactory.OpenSession());
}
I have run the above sql and it`s working fine on my sqlServer management studion. What can be the reason behind and how can I solve it?
What has TransactionScope solved?