When we have database with 2 tables like: ProcesAndOperation.Processes, dbo.Processes and we want take records from ProcesAndOperation.Processes, with order by ProcesAndOperation.Processes.Id desc, we will catch error. It will be caused by the sql query "select ProcesAndOperation.Processes.Id, ProcesAndOperation.Processes.Comments from ProcesAndOperation.Processes order by dbo.Processes.Id desc". Problem is in method GetName() - it takes only table name Processes without database schema. This fix is working for me.
When we have database with 2 tables like: ProcesAndOperation.Processes, dbo.Processes and we want take records from ProcesAndOperation.Processes, with order by ProcesAndOperation.Processes.Id desc, we will catch error. It will be caused by the sql query "select ProcesAndOperation.Processes.Id, ProcesAndOperation.Processes.Comments from ProcesAndOperation.Processes order by dbo.Processes.Id desc". Problem is in method GetName() - it takes only table name Processes without database schema. This fix is working for me.