Databases
StackOverflow2013
Postsdbo
POCreating Database Relationship programmatically
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POCreating Database Relationship programmatically
    text
    copied!<p>I have two separate databases that have data that coincides with another. However they are not relational.</p> <p>I'm trying pro-grammatically create a relationship to build some statistics in C#. <strong>I'm looking for the number of actions in a case and its assets associated.</strong></p> <p><strong>From one database I can see what asset belongs to what case</strong>:</p> <pre><code>| 7AU45448 | cases/unchanged/ | 7AI61361 | cases/unchanged/ | 8C52A5A1 | cases/unchanged/ | 8643Y053 | cases/unchanged/ | 8643Y052 | cases/unchanged/ | 8643Y051 | cases/unchanged/ | 8643Y050 | cases/unchanged/ | B4F043RB | cases/ups01/ | B4F043R7 | cases/ups01/ | B4F043R5 | cases/ups01/ | B4F043QZ | cases/ups01/ | B4F043QY | cases/ups01/ | B4F043RA | cases/ups01/ | B4F043R1 | cases/ups01/ | B4F043R8 | cases/ups01/ | B4F043R9 | cases/ups01/ | B4F043QX | cases/ups01/ | B4F043R3 | cases/ups01/ | B4F043QW | cases/ups01/ | B4F043R4 | cases/ups01/ | B4F043RC | cases/ups01/ | B4F043R2 | cases/ups01/ | B4F043R0 | cases/ups01/ | B4F043RD | cases/ups01/ | B4F043R6 | cases/ups01/ </code></pre> <p><strong>The other database is for logs, and holds no information on the case itself. Only the asset and detail are inside.</strong> </p> <p>The information in this database is like:</p> <pre><code>7AU45448 | Processed file 7AU45448 | Download file 7AU45448 | View file </code></pre> <p>I can easily do a action count per asset on the database but not on the case. This is why I need the relationship.</p> <p>If anyone has and Ideas or suggestions please let me know!</p> <p>Thanks in Advance!</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

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