Get item from database result by using entity framework linq

Question

I have a schedule object that is returned from the database. It contains information from a few tables. One of the tables is called ScheduleData and has four columns. It has this format:

Id  |  ScheduleId |  Name  |  Value

I need the value of the fourth column where the Name is Mine and the ScheduleId is 5

I have tried this, but it doesn't work:

string val = from s in schedule.ScheduleData where s.Name.Equals("Mine") && s.ScheduleId == 5 select s.Value;

Selman Genç · Accepted Answer · 2014-05-23 13:13:38Z

2

Use First method or FirstOrDefault method.The query returns an IEnumerable<T>, you can't assign it to string.

string val = (from s in schedule.ScheduleData 
             where s.Name == "Mine" && s.ScheduleId == 5 
             select s.Value).First();

edited May 23, 2014 at 13:13

answered May 23, 2014 at 13:01

Selman Genç

102k15 gold badges126 silver badges193 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Apostrofix Over a year ago

I tried it, but it gives me "InvalidOperationException". It says "Sequence contains no elements".

Selman Genç Over a year ago

then use FirstOrDefault and check for null. the error indicates, you have no item in your database that matches with your criteria

Collectives™ on Stack Overflow

Get item from database result by using entity framework linq

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related