Recommended database back end?

[Keith]

I'm writing a desktop app that will be used on a single machine, single user (at a time).

It will need a database but the data is never likely to get beyond 100,000 records.

Any recommendations on a back end database?

I'm pretty familiar with SQL Server, so would SQL Server Express be good?

If so, how does that work? Does the SSExpress app need to be running before my app can access it? Or, does the act of accessing the data sufficient?

Thanks in advance for your help.

[Svett]

Hi Keith,

The most efficient in cost and performance for this scenario is Microsoft SQL Express. It is free and performs very well in a single user scenario. You should install it and run it before you try to connect to the server. Also, it supports data base attaching by the client on demand. You can read more about this feature in this MSDN article. You can compare the different SQL Server editions here.

All the best,
Svett
the Telerik team