I have a problem sending data from the database to a list in the Controller. I am new to C# and MVC so any help will be useful! Code follows
public static List<FilterTree> GetAllUsers()
{
FilterTreeDBContext db = new FilterTreeDBContext();
var userList = new List<FilterTree>();
var device = new FilterTree();
//This is the line where I get the error
device.ID = from a in db.FilterTree select a.ID;
userList.Add(device);
return userList;
}
Thanks & Happy Holidays!! :)
device.ID = (from a in db.FilterTree select a.ID).First();
Linq query is lazy, and executes only after you request the value
BTW don't forgot to close the context, otherwise you will leak connections
using (var db = new FilterTreeDBContext())
{
...
return userList;
}
As far as the frameworks knows that query may have more than one object so use it like this:
device.ID = (from a in db.FilterTree select a.ID).FirstOrDefault();
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With