troubleshooting Question

How Can I resolve a LINQ Query Syntax

Avatar of Olukayode Oluwole
Olukayode OluwoleFlag for Canada asked on
LINQ QuerySQL
5 Comments1 Solution150 ViewsLast Modified:
I have 2 Lists
1 Staff  List
2 Staff Variations List

I want be able to select a staff  and limit the entries in the variations List
to records for this staff  only. (see atached screen for the 2 Lists)

I have been able to select the staff and have shown the selected staff no N003  in the debugger

In trying to pass the value N003  to the LINQ  Query   I am having a syntax error

I have tried  to use Intellisense as far as possible but  somehow I have this syntax error
highlighted

Please  see  attached word file that gives a step by step activity  and all debugger values
including the syntax error  in the LINQ Query

I will appreciate any  input into how to get the LINQ Query  syntax right

Thanks

Oluwole
VariationsScreen08022019.PNG
SCRIPT-SELECT-STAFF-AND-LIMIT-STAFF.docx
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros