Relational model in Firebird with C#

Question

Developing a small C# project with Visual Studio, Firebird bank and ibexpert. With the tables WITHOUT RELATIONSHIP I can perform everything well. But I need to relate CLIENTE 1:N with BONUS And SAIDA. I am not able to develop the following reasoning:

I have a table called: CLIENTE with ID_CLIENTE (Primary key), ID_BONUS (FOREIGN KEY),ID_SAIDA (FOREIGN KEY), NOME and Data.

Table BONUS with ID_BONUS (Primary key), data , hour1, hora2, total. Table SAIDA with ID_SAIDA (Foreign key), data , hora1, hora2, total.

A Form1 to CLIENTE with DATAGRID and another Form2 for BONUS And SAIDA (2 DATAGRID).

I must put textbox for foreign keys on CLIENTE? And what can I call Form2, is by the primary key, from BONUS and SAIDA?

My No Relationship Code: 1 Search button on Form1 and a button that accesses Form2.

string mSQL = "Select * from CLIENTE Where ID_CLIENTE = " + id;

Answer 1

I believe you switched the balls, the foreign keys always stay on the side N.

Your tables would look something like this:

---

client table

• id_client (primary key)
• name
• date

bonus table

• id_bonus (foreign key, id_client reference)
• date
• hour1
• hour2
• total

table out

• id_output (foreign key, id_client reference)
• date
• hour1
• hour2
• total

---

Depending on your business rule, you can even ask the user to place the foreign key, but this is not recommended as it opens many loopholes for failures. Ideally when you sign up a new bonus/output, make a select primary user key from the data you already have about it in the application.

Tip: Don’t concatenate a variable with a query, always use parameterized commands.