StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
6067256
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2011-05-20T03:47:30.593
FavoriteCount
0
LastActivityDate
2016-12-08T21:09:37.063
LastEditDate
2016-12-08T21:09:37.063
LastEditorUserId
41956
OwnerUserId
404888
ParentId
4549012
PostTypeId
2
Score
0
ViewCount
0
LastEditorDisplayName
text
Body
Disclaimer, I haven't got any compiled working code. 2 problems. First problem probably lies in: <pre><code>ParameterExpression billMapSetParameter = Expression.Parameter(typeof(billing_map_set_lu), "p"); </code></pre> That's not a parameter you need in: <pre><code>Expression.Lambda<Func<billmaps_lu, bool>>(Expression.Call(method, Expression.Property(**billMapSetParameter**, typeof(billing_map_set_lu).GetProperty("billmaps_lu")), myWhereClause1), billMaps) </code></pre> Change the billMapSetParameter to the billMaps ParamterExpression, then you should be good to go. You are calling the PropertyExpression to obtain your billMapSet for you from the ParameterExpression. 2nd problem: (Not sure, but my gut feeling) You may need to pass the Where clause as a ConstantExpression with type Expression<.Func<>>. .Any method takes two parameters, of which, the second is an Expression<.Func<>> (Or just a Func<>? can't remember). <pre><code>var whereExpression = Expression.Lambda<.Func<.billmaps_lu, bool>>(myWhereClause1, bms); var ce = Expression.Constant(whereExpression) </code></pre> Then pass back ce into originally where you "myWhereClause1" is. Cross finger it works Edit- Scrap that, SHOW MI ZEH CODEZ <pre><code>public class Foo { public List<string> Strings { get; set; } } class Program { static void Main(string[] args) { Func<Foo, bool> func = a => a.Strings.Any(b => b == "asdf"); // b => b == "asdf"; var bParameter = Expression.Parameter(typeof (string)); var asdfConstant = Expression.Constant("asdf"); var compare = Expression.Equal(bParameter, asdfConstant); var compareExpression = Expression.Lambda<Func<string, bool>>(compare, bParameter); var ceCompareExpression = Expression.Constant(compareExpression.Compile()); // a => a.Strings.Any(compareExpression) var parameter = Expression.Parameter(typeof (Foo)); var foosProperty = Expression.Property(parameter, typeof (Foo).GetProperty("Strings")); MethodInfo method = typeof(Enumerable).GetMethods().Where(m => m.Name == "Any" && m.GetParameters().Length == 2).Single().MakeGenericMethod(typeof(string)); var anyMethod = Expression.Call(method, foosProperty, ceCompareExpression); var lambdaExpression = Expression.Lambda<Func<Foo, bool>>(anyMethod, parameter); // Test. var foo = new Foo {Strings = new List<string> {"asdf", "fdsas"}}; Console.WriteLine(string.Format("original func result: {0}", func(foo))); Console.Write(string.Format("constructed func result: {0}", lambdaExpression.Compile()(foo))); Console.ReadKey(); } } </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POCalling the .Any Extension Method with Entity Framework using Expression Trees
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USabatishchev
UserOwnerUserId
1. USSleeper Smith
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POCalling the .Any Extension Method with Entity Framework using Expression Trees
 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
CommentsPostId
1. COThank you @Sleeper Smith! I had pretty much given up on this one and did a work around not using the expression trees, but I will try your answer when we refactor the code, which is coming up so it is very timely that you answered now. Thanks again!
 singulars
 PostPostId
 PO
 UserUserId
 USRCrabtree

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.