StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
7018027
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
2
CommunityOwnedDate
CreationDate
2011-08-10T21:24:20.297
FavoriteCount
0
LastActivityDate
2016-01-07T11:11:46.753
LastEditDate
2016-01-07T11:11:46.753
LastEditorUserId
571196
OwnerUserId
638420
ParentId
7017282
PostTypeId
2
Score
4
ViewCount
0
LastEditorDisplayName
text
Body
You could use reflection <pre><code>x.GetType( ).GetProperty("MyProperty").GetValue( x, null ); </code></pre> although this might work, i wouldn't advise on doing this, why don't pass in your where clause as an expression like: <pre><code>myMethod<T>(Expression<Func<T,bool>> where) </code></pre> <h2>example after comment:</h2> consider the following type: you see there are three properties where the name is of type string and id is of type int. now if we wrap our database context in a service like this <pre><code>public class MyTypeOfXService { private DataDataContext Context; public MyTypeOfXService() { Context = new DataDataContext("example code"); } public IQueryable<MyTypeOfX> GetTypeOfX(Expression<Func<MyTypeOfX, bool>> where) { return this.Context.MyTypeOfXes.Where(where); } } </code></pre> in our get method there is an Expression parameter that takes two generics, the first is our type x and the second is a boolean. The advantage of this approach is that we can abstract all the data context creation and only express an where clause in our code see final piece of code: <pre><code>class Program { static void Main(string[] args) { var service = new MyTypeOfXService(); var queryById = service.GetTypeOfX((mytype) => mytype.Id == 1); var queryByName = service.GetTypeOfX((mytype) => mytype.Name == "MyName"); var queryByName = service.GetTypeOfX((mytype) => mytype.Name == "MyName" && mytype.Id == 1); } } </code></pre> as you can see, we can build a where clause on any property or combination of properties.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POAccess property in lambda expression from string when using LINQ
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USRefugee
UserOwnerUserId
1. USDidier Caron
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POAccess property in lambda expression from string when using LINQ
 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
 VTAcceptedByOriginator
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. COI'am using Linq To SQL so GetProperty() doesn't work. How to do this with an expression ?
 singulars
 PostPostId
 PO
 UserUserId
 USNKnusperer
2. COi'll provide you with an example, give me 15 mins.
 singulars
 PostPostId
 PO
 UserUserId
 USDidier Caron

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.