Devart Forums

Hi,
I am just evaluating the Linq capabilities of your product.
I ran the following query and it runs fine:

Dim qry = From u In db.Staffs Join c In db.Cost_Centers On u.Cost_Center_Seq Equals c.Cost_Center_Seq _
Order By u.Last_Name _
Select New With {.FullName = u.Last_Name & ", " & u.First_Name & c.Cost_Center_Seq, _
u.Staff_Seq}

However, I notice that I wanted a " - " in between Last_Name and Cost_Center.

So, I simply modified the query to say :
Dim qry = From u In db.Staffs Join c In db.Cost_Centers On u.Cost_Center_Seq Equals c.Cost_Center_Seq _
Order By u.Last_Name _
Select New With {.FullName = u.Last_Name & ", " & u.First_Name & " - " & c.Cost_Center_Seq, _
u.Staff_Seq}


When I ran the query I got the following error message:

The method is not supported with specified arguments.


Any ideas?

Thanks ... Ed

Thank you for the report, we will investigate this situation.

So, does this mean it's a bug?
Geez, I've written a grand total of one query and it doesn't work.
Spooky.

This problem is fixed in the current build of dotConnects.