i am trying to do this in lambda :
Select Hint from [tablename] where Answer = 'answer';
this is what i have tried so far :
public ModelSQL.puzzlecontent GetAcrossClue(string answer)
{
return context.puzzlecontents.Where(c => c.Answer.Equals(answer)).Select( g => new {g.Hint});
}
Error says :
Cannot implicitly convert type 'System.Linq.IQueryable' to 'iStellar.ModelSQL.puzzlecontent'. An explicit conversion exists (are you missing a cast?)
Your problem is that Select returns a colection and your method returns a single instance.
Assuming that g.Hint is a ModelSQL.puzzlecontent instance, you should add FirstOrDefault at the end to retrieve a single item.
Something that I missed is that you're trying to return an anonymous type trough new { g.Hint } , that's not valid. You need to return a concrete type.
Again, Assuming that g.Hint is a ModelSQL.puzzlecontent instance, you should have
return context.puzzlecontents
.Where(c => c.Answer.Equals(answer))
.Select(g => g.Hint)
.FirstOrDefault();
g => new {g.Hint} to g => g.Hint
Hint of the answer, so you should correct the return value to string instead of ModelSQL.puzzlecontent. Otherwise we have to append FirstOrDefault() right after Where without any Select.ModelSQL.puzzlecontent? If your Hint is string, that method should return string.public var GetAcrossClue(string answer)
{
return context.puzzlecontents.Where(c => c.Answer.Equals(answer)).Select( g => new {g.Hint});
}
ignore this part, thanks claudio. It's late what can I say?
or
public ModelSQL.puzzlecontent GetAcrossClue(string answer)
{
return context.puzzlecontents.Where(c => c.Answer.Equals(answer)).Select( g => new puzzlecontent{property1 = value,property2 = etc});
}
this part'll work though ^
var. That won't even compile.
ModelSQL.puzzlecontent? This type should be made clear.puzzlecontents.new {g.Hint}you're returning an IEnumerable<> of an anonymous type (what type ever g.Hint is), this doesnt match the signature of the return type of the method (ModelSQL.puzzlecontent). You'll have to select something of type ModelSQL.puzzlecontent and use First/Single(OrDefault) on the result to match the signature of the method.