I have a linq query and I need to change the Name1 field to concatenate firs and last name and truncate it if it is longer then 29 characters.
This works fine and produces the concatenated and truncated Name1 values:
q = From o In db.NCS_Orders Select New GetOrdersInfo With { .Name1 = UserDefinedFunctions.GetNa
Now if I add this after the query I get ...Method 'System.Data.SqlTypes.SqlS
For Each z In x
Dim n1 As String = z.Name1
Next
Here is the method I am calling:
Partial Public Class UserDefinedFunctions
<Microsoft.SqlServer.Serve
Public Shared Function GetName1(ByVal lastname As SqlString, ByVal firstname As SqlString) As SqlString
Dim name As String = lastname + "," + firstname
If name.Length > 29 Then
name = name.Substring(0, 29) & "..."
End If
Return name
End Function
End Class
Why. How do I set Name1 with some sort of value that has a translation to sql. Do I return a lambda value??
Thanks!
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Thank you for your response,
The error I get occurs at the For Each statement so changing the action inside the loop will not resolve this. I am under the impression that this is possible but I admit I cannot find the exact solution. I have found where a UDF returns a type Expressions.Expression and I have found where using a Delegate is used to envolk a UDF. Does anyone have another view on this?
Thank you!
The error is in For each because the LINQ query is not executed before you try to access its result. So the line where you have DECLARED the query does not execute the query. The for each loop causes the query execution and hence the error. Try implementing my suggestion and you will know. Or put this line just after the query.
Messagebox.Show(q.Count)
Hello CodeCruiser,
Question then, why does this not change the values held in q:
For Each x In q
x.Name1 = GetTaxpayerName(x.LastName
x.OrderStatus = GetStatus(x.OrderStatusID)
Next
I moved the UDFs from the main query to this For loop just after the query. I was hoping this would allow me to set values after q was executed but it did not change the values in Name1 or OrderStatus.
Thanks!
Business Accounts
Answer for Membership
by: CodeCruiserPosted on 2009-08-13 at 04:11:28ID: 25086992
That is a limitation of LINQ. It does not support such features yet. You even can not use a property in the class, which is not mapped to a column in database, in a LINQ query! What is suggest is to change the code where you call the name1 and apply the function there. For example,
For Each z In x
Dim n1 As String = UserDefinedFunctions.GetNa
Next