db choice with c# .net

[Washington]

I have a small application connected on MS Access db. MS Access is not safe
DB and everybody can open it irrespective on password protection.

I would like to get a little more protection with DB and question is what
kind of DB I should use (I am using VS.Net and c#. ). Chosen db must be easy
delivered (installed) on user computer within setup application.

Thanks

 

[Chris Priede]

Hi,

I would like to get a little more protection with DB and question is what
kind of DB I should use (I am using VS.Net and c#. ).

Without involving third party products, the next step up from Access would
be MSDE:

http://www.microsoft.com/sql/msde/default.mspx

If you have a very small amount of data to keep up with and that seems an
overkill, then going in the other direction would be no database at all --
you could use XML data files (which you could potentially encrypt for
greater security).

 

[Vitaly Zayko]

Can suggest two:
Firebird (an open source clone of Borland Interbase):
http://www.firebirdsql.org
and Advantage database: http://www.advantagedatabase.com
The first one is open source and free in both local and client/server
versions, The second has free local version and paid client/server
version. Both have .NET access drivers. Both fully compatible with
SQL'99. Firebird IMHO less secure because it doesn't encrypt database
content but it is OK for many tasks.

 

[Jon Skeet [C# MVP]]

Without involving third party products, the next step up from Access would
be MSDE:

http://www.microsoft.com/sql/msde/default.mspx

Or these days, go for SQL Server 2005 Express:

http://www.microsoft.com/downloads/details.aspx?familyid=220549b5-0b07-4448-8848-dcc397514b41

Jon