CODEWITHSUNDEEP
sqldatabasesql-server-ce
Ahmed Kato
Ahmed Kato

Reputation: 1707

Using SDF database file for multiple users

Can I use an SDF file as a database for a small website where multiple users can access it in the same time? Or is SDF just for a single user?

Upvotes: 1

Views: 1958

Answers (1)

Leniel Maccaferri
Leniel Maccaferri

Reputation: 102408

No problem at all! The .SDF is a SQL Server Compact database file.

Like Microsoft SQL Server, SQL CE supports transactions, referential integrity constraints, locking as well as multiple connections to the database store.

SQL CE runtime mediates concurrent multi-user access to the .sdf file.

You can have multiple users accessing your application at the same time and making use of the same database file.

As SQL CE is a limited version of the full SQL Server, you have some limitations. Take a look at the Support section.

Upvotes: 2

Related Questions