I have the following linq query, all i am interested in is the Employee name. I want to return the scalar value of EmpName and return it to a variable strEmployeeName. dsEmp is an ado.net dataset which caches the entire Employee table before the method is called.
dim StrEmployeeName as String
dim IEmp as IEnumerable(Of DataRow)
IEmp = _
From e In dsEmp.Tables(0).AsEnumerable() _
Where e.Field(Of String)("EmpID") = 123 _
strEmployeeName = ?