SQL cannot be converted to LINQ: Field [A].[tab1]

[LauraHolmes]

hi all
I'm having a problem which I hope can be resolved soon. I've downloaded Linqer with activation key etc.
However.. I'm getting this error when I try and convert an SQL statement:
SQL cannot be converted to LINQ: Field .[MerchantDetailsId] not found in the current Data Context. The table Does exist..
I will paste in my SQL statement and if there are any issues that Linqer would have, please let me know as it works fine in SQL server.

SELECT
A.MerchantID, A.AddressLine1+' '+A.AddressLine2+' '+A.City +' '+A.[State]+' '+A.Zip AS [Address], CategoryCode MCC,A.DateCreated as BoardingDate, HostingProvider, ServiceProviderOthers,
CASE
WHEN A.IsActive = 0 THEN F.Datecreated ELSE NULL END AS CloseDate
FROM
AcquirerPromotionCode A
LEFT JOIN
MerchantDetails M
ON
A.MerchantDetailsID = M.MerchantDetailsID
LEFT JOIN
FileDetails FD
ON
A.MerchantId = FD.ExternalMid AND [action]='h' and Fd.responsecod='33'
left JOIN
Files F
on
F.fileid = FD.FileId;

[Mikhail Oumantsev]

I am sorry for the late response.
Please send me your designers.cs and .dbml files, then I will be able to debug the issue.

Thanks,
Mikhail.
[e-mail]