Hello,

I am building smart client Desktop inventory application in WinForms .NET 2.0 / C#. The application will be able to upload/download data through a web service to a website.

Originally, I was going to use VistaDB, but it is not supported by LLBLGen for the client side. So, I was wondering what DBs you guys use for this type of applications. I want to deploy the client as a single MSI without having to have an extra install for the DB (aka MSDE or SQL Server Express 2005).

Thanks,

Patrick B. M.

Sorry closed the thread. Reopening

Take a look at firebird. Firebird is free, and you can first develop it with the firebird service and then pick the .fdb file and use the firebird embedded DLL to use it without the service, so it allows you to use single app deployment without installing a db service. FIrebird supports all features you'd expect from a database.

I never understood why people want VistaDB...

There is also SqlServer Everywhere comming, its CTP already available to the public. Perhaps Frans can tell us his plans for its support. Anyway, since the relase date is not yet known it might be not a good choice at this moment.

Although it's based on SqlCE, I don't think I can use the CE DQE, I've to create a new one, (perhaps a subclass of it), because Everywhere supports more features. It's still pretty crippled though, but for sqlserver users a big step forward, if you don't want to send large graphs over remoting, or don't have to do that because you can work with a local batch of data through the day. So when it's released I'll add support for it, however I don't know when that will be

Or you can obfuscate an Access database (change the extension) like many apps do (Adobe Photoshop Elements and Enterprise Architect just to name acouple)