LINQ to SQL: Selecting Name (string) by id (smallint)

Question

I need to retrieve an id's name (assessment name)

 public int GetAssessmentNo(int AssessmentNo)
        {
            int AssNo = (from a in contxt.View_Assessment
                         where a.id == AssessmentNo
                         select a.AssessmentName);
            return AssNo;
        }

Cannot implicitly convert type System.Linq.IQueryable' to int

Answer 1

Your query returns a set of integers.

Use one of these: First(), Single(), FirstOrDefault(), SingleOrDefault()

public int GetAssessmentNo(int AssessmentNo)
{
    int AssNo = (from a in contxt.View_Assessment
                 where a.id == AssessmentNo
                 select a).Single().AssessmentName;
    return AssNo;
}

or:

public int GetAssessmentNo(int AssessmentNo)
{
    int AssNo = contxt.View_Assessment.Single(a => a.id == AssessmentNo).AssessmentName;
    return AssNo;
}

Answer 2

Linq defaultly returns group of things, linq doesn't know that your id is uniq.

(from a in contxt.View_Assessment where a.id == AssessmentNo select a.AssessmentName).First() or FirstOrDefault.

if you want to receive default value if no proper item is found.