Simple Database to Project

  • Thread starter Thread starter NachoShaw
  • Start date Start date
N

NachoShaw

Guest
Hey

Im ok with databases, was an Access Database user before VB.Net. There are various methods of adding databases to projects, some large, some Access, etc etc but im looking to add a simple database solution to hold a set of rudimentary settings. I dont really want to start including any runtimes for Access or install SQL express for the other users, im looking more for a simple 1 stop database that i can connect to without anything super special needing to be installed.

What would be a good solution to use?

  • Dataset.xsd - ive never used this type before. can it store data or is it only for when the project is running?
  • Service-based - this should give me a local .mdf file. can i access this without needing SQL server being installed? Also, can it be secured?
  • XML - i dont know much about XML at all. Having just spent a lot of time working through a complicated XML data set, id rather bypass this option in its entirety

for local project specific temporary data, i am creating my tables on the fly which works great but obviously they are lost when i close my application but something simple along those lines would be great if anyone could suggest a good straight forward method? It will be storing data for look up and record updating

I appreciate any advice that can be given :)


Thanks


Nacho


Im a self taught VB.Net guy who writes code for Autodesk Inventor. I may not know the terminology but i try so please be patient. Im not a kid so please dont treat me like one :)

Continue reading...
 
Back
Top