StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POASP.NET - Advanced Where-Clause in LinqDataSource
primarykey
Id
3991424
data
AcceptedAnswerId
3992321
AnswerCount
2
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2010-10-21T20:02:40.263
FavoriteCount
2
LastActivityDate
2014-12-11T17:16:58.040
LastEditDate
2010-10-21T20:21:17.177
LastEditorUserId
114547
OwnerUserId
114547
ParentId
0
PostTypeId
1
Score
4
ViewCount
6208
LastEditorDisplayName
text
Body
I have two tables: <ol> <li>Orders </li> <li>OrderProducts - An order can have 1 to many orderProducts records associated with it.</li> </ol> What I am trying to do (unsuccessfully) is to implement a GridView search using a LinqDataSource wherein the search returns Order results where any of the OrderProduct.Manufacturer columns contain a search query. I was hoping the following would work, however it seems lambda expressions do not work within a Where clause of a LinqDataSource (in VB): <pre><code> <asp:LinqDataSource ID="dsOrders" runat="server" ContextTypeName="myDataContext" TableName="orders" Where="orderProducts.Any(Function(op) op.Manufacturer.Contains(@searchTerm))"> <WhereParameters> <asp:ControlParameter Name="searchTerm" ControlID="txtSearchTerm" DefaultValue="" /> </WhereParameters> </asp:LinqDataSource> </code></pre> In C# it would look like: <pre><code> <asp:LinqDataSource ID="dsOrders" runat="server" ContextTypeName="myDataContext" TableName="orders" Where="orderProducts.Any(op => op.Manufacturer.Contains(@searchTerm))"> <WhereParameters> <asp:ControlParameter Name="searchTerm" ControlID="txtSearchTerm" DefaultValue="" /> </WhereParameters> </asp:LinqDataSource> </code></pre> The error I am getting is: <blockquote> No property or field 'op' exists in type 'orderProduct' </blockquote> Any clues as to how to get this working within the LinqDataSource definition, or will I have to handle and set up a custom OnSelecting event?
Tags
<c#><asp.net><vb.net><linq><linq-to-sql>
Title
ASP.NET - Advanced Where-Clause in LinqDataSource
singulars
PostAcceptedAnswerId
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USKeith
UserOwnerUserId
1. USKeith
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 POASP.NET - Advanced Where-Clause in LinqDataSource
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
2. VO
 singulars
 PostPostId
 POASP.NET - Advanced Where-Clause in LinqDataSource
 UserUserId
 USDoozer Blake
 VoteTypeVoteTypeId
 VTFavorite
3. VO
 singulars
 PostPostId
 POASP.NET - Advanced Where-Clause in LinqDataSource
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. This table or related slice is empty.

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.