The issue is with RetrievalProcedure.cs generation...
We have few stored procedures created in the DB. Few with schema 'dbo' and few with schema 'Security'.
Now whenever we re-generate LLBL, the RetrievalProcedures.cs generates all the stored procedures with Schema [Security] as prefix. Thus the stored procedures with schema dbo are also set as [Security]. [StoredProcedureName] which is wrong.
This is annoying as every time LLBL is generated, one has to take care of changing this code from [Security] to [dbo].
As you can see int the attached file. There are two strored procedures.
1) GetAgedDebtor and 2) GetCustomerTransactionHistory
GetAgedDebtor has schema 'dbo' in DB
and GetCustomerTransactionHistory has schema 'Security' in DB.
But both the stored procedures are prefixed with [Security]. GetAgedDebtor should be prefixed with [dbo] and not [Security].
Pls see how could this be resolved.