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