Hi All,
I have generated code from designer pro v3.5 for new table and the old generated code was working perfectly but the new code caused problems in my existing code and when I undo changes for non needed entities I still have the problem.
the last query that made problem was
"SELECT [DB].[dbo].[UserRole].[Id], [DB].[dbo].[UserRole].[RoleID] AS [RoleId],
[DB].[dbo].[UserRole].[UserId] FROM [DB].[dbo].[UserRole]
ORDER BY [DB].[dbo].[WithdrawalType].[Order] ASC
"
although withdrawaltype is another table and it is not related to the new generated table !!
and the error was
"The multi-part identifier "DB.dbo.WithdrawalType.Order" could not be bound."
any ideas to begin with, I donot know how to begin ?
Thanks,
Generator