SQLite schematics in Valentina DB
Posted: Thu Jun 27, 2013 8:54 am
Hi all,
I have aSQLite database with about 10-15 tables. Some of them are referenced and dependent.
I started to write my app using DBLib which works very nicely. I assumed that I have to handle the table-relations (update several fields in several tables if necessary) myself since sqlite manager (firefox plugin) does not offer creating these relations graphcially.
Now I installed Valentina Studio yesterday and see that Valentina actually can handle diagrams.
So, can I create my 1:1 and 1:n relations in Valentina Studio for my SQLite DB and then save it within my SQLite database? Does SQLite automatically handle these relations and the respective updates/deletes/whatever when I access the DB with DBLib? Or do I need to include some Valentina code in my Stack was well? How would you do it?
Thanks,
Pascal
I have aSQLite database with about 10-15 tables. Some of them are referenced and dependent.
I started to write my app using DBLib which works very nicely. I assumed that I have to handle the table-relations (update several fields in several tables if necessary) myself since sqlite manager (firefox plugin) does not offer creating these relations graphcially.
Now I installed Valentina Studio yesterday and see that Valentina actually can handle diagrams.
So, can I create my 1:1 and 1:n relations in Valentina Studio for my SQLite DB and then save it within my SQLite database? Does SQLite automatically handle these relations and the respective updates/deletes/whatever when I access the DB with DBLib? Or do I need to include some Valentina code in my Stack was well? How would you do it?
Thanks,
Pascal