Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>You present four code samples, the 'simple' version so that you can explain the problem and then 3 'better' solutions to fix the problem. The only version that was self-explanatory was the simple version. So, I'm thinking of the poor developer that has to come in a maintain this next year (which might be you after forgetting what you did).</p> <p>So, could you consider a different mechanism altogether for "ensuring that all of the functions for each variable are instantiated". You mentioned a willingness to use T4 to auto-generate stubs for you during compile time. What about using <a href="http://www.microsoft.com/downloads/details.aspx?FamilyID=9aeaa970-f281-4fb0-aba1-d59d7ed09772&amp;displaylang=en" rel="nofollow noreferrer">Microsoft FxCop</a> to catch any instances where you forgot to add something.</p> <p>If you're not familiar with it, <a href="http://www.microsoft.com/downloads/details.aspx?FamilyID=9aeaa970-f281-4fb0-aba1-d59d7ed09772&amp;displaylang=en" rel="nofollow noreferrer">Microsoft FxCop</a> (also embedded in some flavors of Visual Studio) scans the compiled assemblies and evaluates hundreds of framework rules against your code, from proper spelling and casing of variables to unused locals. </p> <p>While I personally agree with most of the rules that Microsoft has bundled into FxCop, I think the real beauty of it is the ability to create your own rules. I have created rules that I add to FxCop that enforces CRUD principles, such as if you have a <code>CreateXxx</code> method, you must have a <code>DeleteXxx</code> method etc. So, if you identify a class that matches the pattern you desire, you can get a list of all variables {A, B, C} and then guarantee that FuncAB(A, B) exists and that FuncAC(A, C) exists etc.</p> <p>Then, even a junior developer would be caught out by FxCop the next time he implements IBiVariableFunction and forgets a function on a pair.</p> <p>Cheers, Adrian</p>
    singulars
    1. This table or related slice is empty.
    1. POC# class design without using "Internal" or "Static"?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USAdrian
    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. 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
    1. COThanks for the reply. I had never considered using FxCop in the manner suggested, but my question is more about not having to manually generate a bunch of code than coming after the fact and having FxCop tell me that "you haven't don't this". As to the complexity of the question. The "simple" version and example #1 are identical - they only differ by the use of partial classes to distribute code over separate files. The other two examples use/abuse simple inheritance to achieve the desired outcome - not something that I would consider needs explaining in depth.
      singulars
      1. PO
      1. USPeter M
    2. COInteresting, I just re-reviewed your samples and broke one of my initial assumptions. I was originally thinking that the functions were transitive wrt their arguments. That is FuncAB(...) and FuncBA(...) would have been the same (e.g. addition instead of concatenation), I now see that isn't the case. So, without thinking the answer through, would a generic interface help? Something like IFunc<T, U> which requires Func(T, U) and Func(U, T) to exist? Probably get pretty ugly with lots of interfaces declared...
      singulars
      1. PO
      1. USAdrian
    3. COI am not sure a generic interface would do me, but I am ignoring the problem for now.
      singulars
      1. PO
      1. USPeter M
 

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