Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Sure; you can do that in many ways; starting with reflection (note, this is slowish - OK for moderate amounts of data though):</p> <pre><code>var props = objectType.GetProperties(); foreach(object obj in data) { foreach(var prop in props) { object value = prop.GetValue(obj, null); // against prop.Name } } </code></pre> <p>However; for larger volumes of data it would be worth making this more efficient; for example here I use the <code>Expression</code> API to pre-compile a delegate that looks writes each property - the advantage here is that no reflection is done on a per-row basis (this should be significantly faster for large volumes of data):</p> <pre><code>static void Main() { var data = new[] { new { Foo = 123, Bar = "abc" }, new { Foo = 456, Bar = "def" }, new { Foo = 789, Bar = "ghi" }, }; string s = Write(data); } static Expression StringBuilderAppend(Expression instance, Expression arg) { var method = typeof(StringBuilder).GetMethod("Append", new Type[] { arg.Type }); return Expression.Call(instance, method, arg); } static string Write&lt;T&gt;(IEnumerable&lt;T&gt; data) { var props = typeof(T).GetProperties(); var sb = Expression.Parameter(typeof(StringBuilder)); var obj = Expression.Parameter(typeof(T)); Expression body = sb; foreach(var prop in props) { body = StringBuilderAppend(body, Expression.Property(obj, prop)); body = StringBuilderAppend(body, Expression.Constant("=")); body = StringBuilderAppend(body, Expression.Constant(prop.Name)); body = StringBuilderAppend(body, Expression.Constant("; ")); } body = Expression.Call(body, "AppendLine", Type.EmptyTypes); var lambda = Expression.Lambda&lt;Func&lt;StringBuilder, T, StringBuilder&gt;&gt;(body, sb, obj); var func = lambda.Compile(); var result = new StringBuilder(); foreach (T row in data) { func(result, row); } return result.ToString(); } </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POHow can you loop over the properties of a class?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USMarc Gravell
    1. USMarc Gravell
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POHow can you loop over the properties of a class?
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COthanks for the answer, but got a doubt reagarding accessing properties of another class, like: if i have `List<Booking>` where Booking is a class, and `Cab`as another class and i reference it as a property in the Booking Class. how shud i parse thru the `foreach` to fetch the properties of the Cab class as well...Thanks
      singulars
      1. PO
      1. USSandeep
    2. CO@sandy what have you tried?
      singulars
      1. PO
      1. USMarc Gravell
    3. COryt now i can get each property of the `Booking` class, as `foreach(var porp in obj2Insert) { //using prop.GetValue() to return the result and store it. }` But, this traverses thru the whole properties of Booking Entity, which i dnt require..! This is where i'm struck...!
      singulars
      1. PO
      1. USSandeep
 

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