a little clumsy, yet effective:...var result = from a in new DataContext().Actions
where a.UserId == someGuidValue
let IsEvent = a as Event != null
select new { a.CreatedOn, IsEvent, a.Summary };
List<Action> list = result.AsEnumerable()
.Select(o => o.IsEvent ?
...
Projecting onto a POCO (or anonymous) type is simple:...var q = from d in Model.Discussions
select new DiscussionPresentation
{
Subject = d.Subject,
MessageCount = d.Messages.Count(),
};
...Inspecting the produced SQL reveals that the...Count()...
by the database server....It should be noted that EF 1...
zzz-5 to zzz:...To include a collection, a collection, and a reference two levels down: ... query.Include(e => e.Level1Collection.Select(l1 => l1.Level2Collection.Select(l2 => l2.Level3Reference))).
...So try in your case...Country country = _db.Countries
.Include(c=>c.Cities.Select(
cc => cc.People.Select(
...
For more information, see this ...link.... The secret, in essence, is to employ. To limit the columns you desire, use Select() and anonymous type. First Select() actually performs the following in the illustration below:...var results = context.Products
.Include("ProductSubcategory")
.Where(p => p.Name.Contains(searchTerm)
...
Considering DavidG's remark...Only when a select statement has produced values, does ExecuteSqlCommand return those values....You must utilize the to get the return value of a stored procedure (as in the example in the question)....EXEC @ReturnValue = [StoredProc] @param1 ......
the process outlined in ...this SO response....
I believe you should use this....SingleOrDefault...var result= db.yourtable
.SingleOrDefault(c=>c.Name== "Some Name");
...When you use SingleOrDefault, you explicitly declare that the search should return just one result at most.
