M
Mark Rae
Hi,
I'm writing a WinForms app in C# and need to store various items of lookup
data which will be accessible and maintainable by the user. I'm looking for
advice as to the best way to achieve this, according to the following
provisos:
1) The app must be able to "match" records according to various criteria in
a standard sort of "fetch me all the records where..." way. This doesn't
have to be SQL becuase it will all be GUI driven. E,g the user selects
various criteria via dropdowns (age, sex, area etc) and the app returns the
records which match those criteria, so the user won't care whether the app
uses SQL or another technology under the hood.
2) The schema is fairly flat with one main table containing about fifty
fields, and only a handful of related lookup tables.
3) There might be several thousand records in the main table.
4) There must be no additional licensing costs incurred with the database
software.
5) The data might be single-user standalone or accessed by multiple users at
once, so would have to be able to reside on a network share though, because
of 4) above, something like SQL Server is right out, unfortunately.
6) The data must be unreadable by anything or anyone other than my
application.
7) The data must be easily backed up and restored.
Given this, would you recommend:
a) a Jet database
b) some sort of XML file / schema structure
c) something else altogether,
Any assistance gratefully received.
Best regards,
Mark Rae
I'm writing a WinForms app in C# and need to store various items of lookup
data which will be accessible and maintainable by the user. I'm looking for
advice as to the best way to achieve this, according to the following
provisos:
1) The app must be able to "match" records according to various criteria in
a standard sort of "fetch me all the records where..." way. This doesn't
have to be SQL becuase it will all be GUI driven. E,g the user selects
various criteria via dropdowns (age, sex, area etc) and the app returns the
records which match those criteria, so the user won't care whether the app
uses SQL or another technology under the hood.
2) The schema is fairly flat with one main table containing about fifty
fields, and only a handful of related lookup tables.
3) There might be several thousand records in the main table.
4) There must be no additional licensing costs incurred with the database
software.
5) The data might be single-user standalone or accessed by multiple users at
once, so would have to be able to reside on a network share though, because
of 4) above, something like SQL Server is right out, unfortunately.
6) The data must be unreadable by anything or anyone other than my
application.
7) The data must be easily backed up and restored.
Given this, would you recommend:
a) a Jet database
b) some sort of XML file / schema structure
c) something else altogether,
Any assistance gratefully received.
Best regards,
Mark Rae