GridView doesn't show results with First() query extension

Question

I am using LINQ-to-Entities and have loaded up a Northwind Database (with LazyLoading=true).

var db = new NorthwindEntities();
var result = db.Orders.Where(x => x.CustomerID == "ANATR").First();        
DataGridView1.DataSource = result;

The above code doesn't show up any items (one in this particular case) in the DataGridView. What am I doing wrong?

(If I remove the 'First()' it works fine and gives me several items)

Does it work if you do `.Take(1)` instead? I'm wondering if it is due to the difference in what type `result` is. — Chris, Dec 22 '11 at 15:46
Yes, I am sure there is because if I remove the 'First' it shows me results — ColdFusion, Dec 22 '11 at 15:47
Chris, yes! Take(1) works, but why First doesn't return any results? — ColdFusion, Dec 22 '11 at 15:48
A grid seems an unusual choice of control for displaying a single item :) — AakashM, Dec 22 '11 at 15:49

score 4 · Answer 1 · answered Dec 22 '11 at 15:46

4

The result is not a collection, that's why, you can not list it. First is a single object.

answered Dec 22 '11 at 15:46

NetSide

Andrew Hanlon · Answer 2 · 2011-12-22T15:52:09.827

0

Your result is actually a single object not a collection of objects.

Try adding the result to an empty list.

edited Dec 22 '11 at 15:52

answered Dec 22 '11 at 15:45

Andrew Hanlon

score 0 · Answer 3 · answered Dec 22 '11 at 15:51

var db = new NorthwindEntities(); var result = db.Orders.Where(x => x.CustomerID == "ANATR").First();
DataGridView1.DataSource = result;

since result isn't a Collection this won't work you can use

var results =Enumerable.Repeat(result, 1);

To create single item in a list to do this or also

var results = new List<Order>() { result };

Will also work

And then bind to results instead of result

3 Answers3