Hi Team,
I run code
LLBL version 5.5
using (DataAccessAdapter adapter = ...)
{
FES.MortgageEzy.Shared.Database.Linq.LinqMetaData linq = new FES.MortgageEzy.Shared.Database.Linq.LinqMetaData(adapter);
return linq.Loans.IncludeFields(l => l.ApplicationID)
.Where(l => l.Status.Any(st => st.ConfigLoanStatus.MStatusID == 22) && l.Date_Settled == null)
.Select(l => l.ApplicationID.ToString()).ToList();
}
It raised exception with message below
{"An exception was caught during the execution of a retrieval query: The multi-part identifier \"LPLA_1.ApplicationID\" could not be bound.\r\nThe multi-part identifier \"LPLA_1.Date_Settled\" could not be bound.\r\nThe multi-part identifier \"LPLA_1.ApplicationID\" could not be bound.. Check InnerException, QueryExecuted and Parameters of this exception to examine the cause of this exception."}
I check the sql query from profiler
exec sp_executesql N'SELECT CONVERT(NVARCHAR(10), [LPLA_1].[ApplicationID]) AS [LPFA_1] FROM [SoEzyDB].[dbo].[Loans] [LPA_L1] WHERE ( ( ( ( ( EXISTS (SELECT [LPA_L3].[ValuationId] FROM ([SoEzyDB].[dbo].[ConfigLoanStatus] [LPA_L2] RIGHT JOIN [SoEzyDB].[dbo].[Status] [LPA_L3] ON [LPA_L2].[ConfigLoanStatusId]=[LPA_L3].[ConfigStatusID]) WHERE ( [LPLA_1].[ApplicationID] = [LPA_L3].[ApplicationID] AND ( [LPA_L2].[MStatusID] = @p1))) AND ( [LPLA_1].[Date_Settled] IS NULL))))))',N'@p1 int',@p1=22
go
- The query is wrong
- "SELECT CONVERT(NVARCHAR(10), [LPLA_1].[ApplicationID]",
- [LPLA_1] is not alias of table Loans, it is [LPA_L1]
- FROM [SoEzyDB].[dbo].[Loans] [LPA_L1]
Please me the way to fix this issue.
Thank you,