[RESOLVED] Lightweight .NET-supported database
I have a question which is kind of annoying, but I am going to ask it anyway :afrog:.
I'm looking for a database sysem to use in my software which does not have to be pre-installed on the enduser his computer.
What i'm basicly looking for is a lightweight thing, (just a couple of MBytes), which is relational and supports the simple SQL queries.
I can't think of anything really suitable: SQLServer, MySQL, Oracle, Access, XML, ...
Is there a clear solution? I can imagine this sounds like the Coke-Zero commercials: "What about great life without downsides?" But fact is that there are a lot of existing applications that use an SQL supporting database which don't require a preinstalled database system.
... and hopefully it's free ;)
Thank you in advance, I'm really curious.
Re: Lightweight .NET-supported database
There has to be some database placed on the users machine. That being said it can be done without much overhead. Use of an MS Access database does not require Acces being installed on the system (to develop against it it should be installed). Also SQL CE is a light weight SQL Server version that has only a few dlls that are required to be installed onto the users system.
Re: Lightweight .NET-supported database
Yes, I second Gary's suggestions as he beat me to it :D
To use Access in your app the end user doesnt even need Access installed and SQL CE I learned is a great lightweight db but limited on its features.
Either way, for the price, the two are probably your top choices.
There is also a light version of Oracle but I dont know much about it.
Re: Lightweight .NET-supported database
Have a central server, somewhere on the Internet, where your database sits. One for all customers. Create web services to interface with it. Get your client applications to call those web services.
Re: Lightweight .NET-supported database
While there are quite a few limitations to SQL CE... if you can work around them, that's the way to go. 7DLL's in the same folder as your app.... it just doesn't get much easier than that. But it does take some planning (as I'm finding out).
-tg
Re: Lightweight .NET-supported database
Thanks, did take me some time to install it, I guessed it would be added to my CLR straightaway, but nideed I had to add those dll-files to my directory and put the reference manually as you guys pointed out :).
Seems to work fine now. Thanks, great stuff ! :)