CODEWITHSUNDEEP
sqlwpfdatabasewindowsinstallation
44 6f 6f 20 44 6f 6f
44 6f 6f 20 44 6f 6f

Reputation: 63

What database should I use to deploy a WPF application?

What database should I use?

I am currently under the design phase of a WPF application. I have never deployed an application before and I am not sure what database I should use. I want my application to be deployable on any Window's 7 machine without the need of a special install (i.e. SQL Server). I don't want to be in the deployment phase and find out that I should have used another database. Can I simply run a SQL script on the install to generate all the tables and fields required for the software to properly run? Thanks!

Upvotes: 4

Views: 1005

Answers (3)

Ross
Ross

Reputation: 4578

If you are creating a WPF app with no plans beyond the next few years, SQL CE will be fine and will work well.

But if you are thinking about compatibility with (or a transition to) a potential Windows 8 Metro version of your app (in which SQL CE is not supported), or another OS (e.g. OS X), you should consider SQLite.

Upvotes: 0

Sergiu Cojocaru
Sergiu Cojocaru

Reputation: 687

if you do not use too complex queries, you can use sqllite Here you can find it and c# connector here

Upvotes: 0

E.J. Brennan
E.J. Brennan

Reputation: 46879

SQLCE fits the bill, (and there are probably others as well); small footprint, file-based and just one (or very few) extra DLL's to include in your app. Personally I wouldn't use it for anything other than a smal, single-user app, but if yours is single user and the amount of data is small, you could do worse.

http://weblogs.asp.net/scottgu/archive/2011/01/11/vs-2010-sp1-and-sql-ce.aspx

Upvotes: 1

Related Questions