Creating SQL Server database files on the fly using C #

Question

Can I create database files that are independent of any SQL Server engine on the fly? The fact is that we want to create one database file for each user in our application, and we want this database to be stored in the user directory, but we do not want to connect to it through SQL Server. Prety is very similar to an sdf file, but instead of an application-specific one, is user-specific.

So what we want to do is that every time a user is created in the application, generates his own folder and generates a database schema, which will be filled later.

Answer 1

, , . , ( SQL Server).

Answer 2

, SQL Server Compact. .

Answer 3

, "Access" Jet engine. .

sqlite, IMHO , # .

Answer 4

SQL Server Express / Compact with smo to programmatically create your db.