I have three tables:
- Table1(id, name, no)
- Table2(id, table1id, no)
- Table3(id, table2id, no).
I have an object suitable for the structure of these tables and I want to save them in the database. While recording, I want to use the sequence of the first table in my second table. I will pull the sequence of my first table from the database. I will save tables 2 and 3 in the same way. I want to save these transactions in my oracle database using sqlkata, dapper in .net environment.
I tried pulling the sequence value and setting it each time.