In my Wpf VS application with SQLite, I want to use my old data sheet,
whose entries are of something like an hierarchical structure below :
Field name (F1 F2 F3 F4 F5 F6)
Cell contents (x y z * * *) about 50,000 rows, string type
The number of different cell contents of the fields F1, F2 and F3 is about
10, 15 and 20 respectively, being added or removed dynamically when application runs.
And the contents of F2 depend on the the content of F1. For example,
if x == 'fruits', then y == 'Apple' or 'Mango' 'Banana' ...
if x == 'animals', then y == 'Monkey' or 'Elephant' ...
The contents of F3 depend only on the content of F2 similarly.
So total number of ordered triple (F1, F2, F3) is about 3000.
I managed to understand little about data binding in WPF, DataGrid, SQLite, but no further
progress in creating database, I mean... what is the multiple databases, foreign keys, database relations for?
I wonder if it's ok using just 1 table created by
create table AAA (id int primary key, F1 varchar(20), F2 varchar(20), F3 varchar(20),
F4 varchar(512), F5 varchar(512), F6 varchar(512)),
which is almost the same as spreadsheet's one.
Greatly appreciated if any comments.