Databases
StackOverflow2013
Postsdbo
POGet collection of class instance with property combinations
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POGet collection of class instance with property combinations
    primarykey
    data
    text
    <p>I'm stuck with the following problem.</p> <p>Consider the following simple attribute.</p> <pre><code>[AttributeUsage(AttributeTargets.Property)] public class CombinationsAttribute : Attribute { public object[] PossibleValues { get; private set; } public CombinationsAttribute(params object[] values) { this.PossibleValues = values; } } </code></pre> <p>Following is the attribute usage example - just some class with some dummy properties, the value array going into the attribute is always of the property type. </p> <pre><code>public class MyClass { [Combinations(1, 2, 3, 4, 5)] public int IntProperty1 { get; set; } [Combinations(10, 15, 20, 25, 30)] public int IntProperty2 { get; set; } [Combinations("X", "Y", "Z")] public string StringProperty { get; set; } } </code></pre> <p>I want to get all instances (5 * 5 * 3 in this example) for all the combinations. How can I do that writing as little code as possible (LINQ favoured)?</p> <p><strong>EDIT: I don't know the class (MyClass) - there are many classes with public properties having CombinationsAttribute for which I need to compute all their possible combinations. .</strong> These classes always have parameterless constructors.</p> <p>Expected result example (pseudo c# for visualization):</p> <pre><code>List&lt;MyClass&gt; Combinations = GetCombinationMagicFunction(typeof(MyClass)); List[0] = MyClass { IntProperty1 = 1, IntProperty2 = 10, StringProperty = "X" } List[1] = MyClass { IntProperty1 = 1, IntProperty2 = 10, StringProperty = "Y" } List[2] = MyClass { IntProperty1 = 1, IntProperty2 = 10, StringProperty = "Z" } List[2] = MyClass { IntProperty1 = 1, IntProperty2 = 15, StringProperty = "X" } ... List[74] = MyClass { IntProperty1 = 5, IntProperty2 = 30, StringProperty = "Z" } </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USJohn Saunders
    1. USMirek
    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. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POGet collection of class instance with property combinations
      1. USBecuzz
      1. VTFavorite
    1. CO"the value array going into the attribute is always of the property type" and yet you have `[Combinations("X", "Y", "Z")] public int StringProperty`...
      singulars
      1. POGet collection of class instance with property combinations
      1. USTrevor Pilley
    2. COI repaired that, thank you
      singulars
      1. POGet collection of class instance with property combinations
      1. USMirek
 

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