CODEWITHSUNDEEP
c#.netsqllinqlinq-to-sql
Saleh
Saleh

Reputation: 3032

Error While Convert SQL query to LINQ With LINQER

I can convert this query with linqer.

select * 
from v#gharardad 
inner join (select FK#GharardadeAsli, Max(PK#Shenase) as PK#Shenase, Max(TarikheSabt) as TarikheSabt 
            from TBL#Gharardad 
            where FK#GharardadeAsli is not null 
            group by FK#GharardadeAsli
            ) sub on sub.PK#Shenase = v#gharardad.[Shenase]

Error: >SQL cannot be converted to LINQ: Field [sub].[PK#Shenase] not found in the current Data Context.

If there is no way to pass this error so can you tell me its LINQ equal?

Upvotes: 0

Views: 1229

Answers (1)

Albin Sunnanbo
Albin Sunnanbo

Reputation: 47038

The # char seems to be translated to _ by the LINQ designer.

Try to create temporary views where you replace all # with _. Then run the query in Linqer again and it will probably work.

Upvotes: 3

Related Questions