Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Switching on types is definitely lacking in C# (<strong>UPDATE: in C#7 / VS 2017 switching on types is supported - <a href="https://stackoverflow.com/questions/298976/is-there-a-better-alternative-than-this-to-switch-on-type/299001#299001">see Zachary Yates's answer below</a></strong>). In order to do this without a large if/else if/else statement, you'll need to work with a different structure. I wrote a blog post awhile back detailing how to build a TypeSwitch structure.</p> <p><a href="http://blogs.msdn.com/jaredpar/archive/2008/05/16/switching-on-types.aspx" rel="nofollow noreferrer">http://blogs.msdn.com/jaredpar/archive/2008/05/16/switching-on-types.aspx</a></p> <p>Short version: TypeSwitch is designed to prevent redundant casting and give a syntax that is similar to a normal switch/case statement. For example, here is TypeSwitch in action on a standard Windows form event</p> <pre><code>TypeSwitch.Do( sender, TypeSwitch.Case&lt;Button&gt;(() =&gt; textBox1.Text = "Hit a Button"), TypeSwitch.Case&lt;CheckBox&gt;(x =&gt; textBox1.Text = "Checkbox is " + x.Checked), TypeSwitch.Default(() =&gt; textBox1.Text = "Not sure what is hovered over")); </code></pre> <p>The code for TypeSwitch is actually pretty small and can easily be put into your project.</p> <pre><code>static class TypeSwitch { public class CaseInfo { public bool IsDefault { get; set; } public Type Target { get; set; } public Action&lt;object&gt; Action { get; set; } } public static void Do(object source, params CaseInfo[] cases) { var type = source.GetType(); foreach (var entry in cases) { if (entry.IsDefault || entry.Target.IsAssignableFrom(type)) { entry.Action(source); break; } } } public static CaseInfo Case&lt;T&gt;(Action action) { return new CaseInfo() { Action = x =&gt; action(), Target = typeof(T) }; } public static CaseInfo Case&lt;T&gt;(Action&lt;T&gt; action) { return new CaseInfo() { Action = (x) =&gt; action((T)x), Target = typeof(T) }; } public static CaseInfo Default(Action action) { return new CaseInfo() { Action = x =&gt; action(), IsDefault = true }; } } </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POIs there a better alternative than this to 'switch on type'?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USJaredPar
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POIs there a better alternative than this to 'switch on type'?
      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. VTDownMod
    1. CO"type == entry.Target" can also be changed to "entry.Target.IsAssignableFrom(type)" to take compatible types (e.g., subclasses) into account.
      singulars
      1. PO
      1. USMark Cidade
    2. COAltered the code to use "entry.Target.IsAssignableFrom(type)" so that subclasses are supported.
      singulars
      1. PO
      1. USMatt Howells
    3. COOne thing maybe worth noting is that (from what I understand) it is required to specify the 'default' action last to ensure all other cases are checked. I believe this is not a requirement in a standard switch - not that I have ever seen anybody try to plant a 'default' anywhere other than the bottom anyway. A couple of fail safe options for this could be to order the array to ensure default is last (bit wasteful) or pop the default in a variable to be processed after the `foreach` (which would only ever happen if a match wasn't found)
      singulars
      1. PO
      1. USmusefan
 

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