Conversion Faliure

[Hassan Gulzar]

I have this quick query but since my table is named User (SQL keyword), Linqer (a SQL to LINQ converter) fails to convert the SQL query.

Here is the query:

SELECT TOP (100) PERCENT
 dbo.[User].OID,
 dbo.[User].FirstName + ' ' + dbo.[User].LastName AS [User Name],
 COUNT(dbo.AssignedCounty.OID) AS [Counties Assigned],
 dbo.UserType.Name AS [User Type]
FROM
 dbo.UserType
 INNER JOIN dbo.[User] ON dbo.UserType.OID = dbo.[User].UserTypeID
 LEFT OUTER JOIN dbo.AssignedCounty ON dbo.[User].OID = dbo.AssignedCounty.UserID
GROUP BY
 dbo.[User].OID,
 dbo.[User].FirstName + ' ' + dbo.[User].LastName,
 dbo.UserType.Name,
 dbo.[USER].IsActive
HAVING
 (dbo.[User].IsActive = 1)
ORDER BY
 [User Name]

Can anyone guide me on how to work my way around this? I need the LINQ.

[Mikhail Oumantsev]

Can you send your dbml and designer files to [e-mail] ?
SQL doesn't look to be complicated, and I don't think table name [User] is an issue. Having your files, I will be able to debug and improve Linqer.
I will also post the LINQ you ask.

Thanks.

[Mikhail Oumantsev]

I didn't get your connection files.
More than likely, you use older version of Linqer.
The issue may be related to using dbo. prefix in the table name.
dbo prefix is ignored in Linqer 3.5.