Simple query issue

Simple query issue

Postby edstaffin » Thu 23 Jul 2009 13:43

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
edstaffin
 
Posts: 43
Joined: Mon 13 Oct 2008 13:23

Postby AndreyR » Thu 23 Jul 2009 14:31

Thank you for the report, we will investigate this situation.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Postby edstaffin » Thu 23 Jul 2009 19:38

So, does this mean it's a bug?
Geez, I've written a grand total of one query and it doesn't work.
Spooky.
edstaffin
 
Posts: 43
Joined: Mon 13 Oct 2008 13:23

Postby AndreyR » Mon 17 Aug 2009 06:09

This problem is fixed in the current build of dotConnects.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16


Return to LinqConnect (LINQ to SQL support)