StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
5020449
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2011-02-16T18:19:51.130
FavoriteCount
0
LastActivityDate
2011-02-18T15:13:06.810
LastEditDate
2011-02-18T15:13:06.810
LastEditorUserId
8155
OwnerUserId
8155
ParentId
5008839
PostTypeId
2
Score
5
ViewCount
0
LastEditorDisplayName
text
Body
First - logically you want Any, not All. Second, this is a poor way to build up a query filter. All of those operations are sent into the database, while the information to determine which filters should be applied is already local. The explicit joins are also bad (association properties could be used instead). <pre><code>IQueryable<WidgetHistory> query = db.widgetHistories .Where(ph => ph.contact_dt.Value.Date >= startDate && ph.contact_dt.Value.Date <= endDate); if (!string.IsNullOrEmpty(baanCatFam)) { query = query.Where(ph => ph.baan_cat_family_code == baanCatFam); } if (!string.IsNullOrEmpty(baanCat)) { query = query.Where(ph => ph.baan_cat_code == baanCat); } if (!string.IsNullOrEmpty(baanSubCat)) { query = query.Where(ph => ph.baan_sub_cat_code == baanSubCat); } //TODO sku filtering here. List<MappedItem> widgetItems = from ph in query let c1 = ph.widgetAssignedCode.CCRCode group c1 by c1.code_desc into g select new MappedItem { ItemDescription = g.Key.ToUpper(), ItemCount = g.Count() }).OrderByDescending(m => m.ItemCount) .ToList(); </code></pre> Third: the answer to your question. <blockquote> what causes this error </blockquote> LinqToSql's query provider cannot translate your local collection into sql. There's only a limitted set of scenarios where it can translate... <code>.Where(ph => idList.Contains(ph.Id))</code> is translated into an IN clause with 1 parameter per int in idList. To get around this limitation, you need to convert the local collection into an expression. Start by tranforming each item in the collection into a filtering expression: <pre><code>List<Expression<Func<WidgetHistory, bool>>> skuFilters = skuList.Select<string, Expression<Func<WidgetHistory, bool>>>(skuItem => ph => ph.ProductMod.StartsWith(skuItem) ).ToList(); </code></pre> Next, a helper method: <pre><code>public static Expression<Func<T, bool>> OrTheseFiltersTogether<T>( this IEnumerable<Expression<Func<T, bool>>> filters) { Expression<Func<T, bool>> firstFilter = filters.FirstOrDefault(); if (firstFilter == null) { Expression<Func<T, bool>> alwaysTrue = x => true; return alwaysTrue; } var body = firstFilter.Body; var param = firstFilter.Parameters.ToArray(); foreach (var nextFilter in filters.Skip(1)) { var nextBody = Expression.Invoke(nextFilter, param); body = Expression.OrElse(body, nextBody); } Expression<Func<T, bool>> result = Expression.Lambda<Func<T, bool>>(body, param); return result; } </code></pre> And now putting it all together: <pre><code>if (skuFilters.Any()) //this part goes into where it says "TODO" { Expression<Func<WidgetHistory, bool>> theSkuFilter = skuFilters.OrTheseFiltersTogether() query = query.Where(theSkuFilter); } </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POLocal sequence cannot be used in LINQ to SQL implementation
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USAmy B
UserOwnerUserId
1. USAmy B
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POLocal sequence cannot be used in LINQ to SQL implementation
 singulars
 PostTypePostTypeId
 PTQuestion
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTAcceptedByOriginator
3. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. CO@Ddavid, you rock!
 singulars
 PostPostId
 PO
 UserUserId
 USAndy Evans

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.