Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>You can solve your problem by using the following set of classes.</p> <p>First, we need to create a Contains class which will decide which items will be chosen from the source array.</p> <pre><code>class Contains { public bool Value { get; set; } public Contains(object[] items, object item) { Value = (bool)(typeof(Enumerable).GetMethods() .Where(x =&gt; x.Name.Contains("Contains")) .First() .MakeGenericMethod(typeof(object)) .Invoke(items, new object[] { items, item })); } } </code></pre> <p>Then we need to create a Where class which will be used to form a predicate based on which items will be selected. It should be clear that in our case, we are going to use the Contains class for our predicate method.</p> <pre><code>class Where { public object Value { get; set; } public Where(object[] items, object[] items2) { Value = typeof(Enumerable).GetMethods() .Where(x =&gt; x.Name.Contains("Where")) .First() .MakeGenericMethod(typeof(object)) .Invoke(items2, new object[] { items2, new Func&lt;object, bool&gt;(i =&gt; new Contains(items, i).Value) }); } } </code></pre> <p>The last step is simply to invoke the result we got from the Where class, which is actually of type Enumerable.WhereArrayIterator and not of type List, since the result of the Where Extension method is a product of deferred execution.</p> <p>Thus we need to create a non deferred object, by calling its ToList Extension Method, and get our result.</p> <pre><code>class ToList { public List&lt;object&gt; Value { get; set; } public ToList(object[] items, object[] items2) { var where = new Where(items, items2).Value; Value = (typeof(Enumerable).GetMethods() .Where(x =&gt; x.Name.Contains("ToList")) .First() .MakeGenericMethod(typeof(object)) .Invoke(where, new object[] { where })) as List&lt;object&gt;; } } </code></pre> <p>In the end, you can simply test the whole process out by using the following class.</p> <pre><code>class Program { static void Main() { var items = new object[] { 1, 2, 3, 4 }; var items2 = new object[] { 2, 3, 4, 5 }; new ToList(items, items2).Value.ForEach(x =&gt; Console.WriteLine(x)); Console.Read(); } } </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POReflection to call generic method with lambda expression parameter
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USMario Stopfer
    1. USMario Stopfer
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. COMario, thanks for your time, but your solution using Generics does not fit my requirement, because I only have the type and the property to be tested in runtime. I'll update the question and try to explain better.
      singulars
      1. PO
      1. USnatenho
    2. COI have updated the answer so that you will not have to use generic types. Instead, you will use arrays of type object to store your items.
      singulars
      1. PO
      1. USMario Stopfer
    3. COit works only for base types like int. My case uses reference types, that need a property to be evaluated with contains. For instance, I would need to test a list of "Person" against a list of int Ids and return all "Person" that has any of these Ids: `var arrayOfIds = new[] { 1, 2, 3, 4 }; //This line doesn't work because Person is not known in compile time, so I can't access the "Id" Property return listOfObjects.Where(p => arrayOfIds.Contains(p.Id));`
      singulars
      1. PO
      1. USnatenho
 

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.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload