Generating both SQL Server CE database and entity model at runtime

Question

I am developing a desktop application where different users can use the application on the same machine, the application should generate a different SQL Server CE database file for each user where the databases have the same schema (structure), and then generate an entity model from that database, how should I go about doing this ?

I am new to both the Entity Framework and the SQL Server CE engine, so I am willing to consider any solution.

Arthur Vickers · Accepted Answer · 2012-10-26 16:45:58Z

1

Use Code First. With Code First you define your model in code and then the first time the application runs it will look for a database and if one doesn't exist then it can create that database for you. Your application should use a connection string for a SQL Compact database that points to a different location for each user. That way when a new user runs the application for the first time a database will be created for the user and that database will then be used subsequently for future uses of the application by the same user. Help on getting started with Code First can be found here: http://msdn.microsoft.com/en-us/data/ee712907

answered Oct 26, 2012 at 16:45

Arthur Vickers

7,53334 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Ibrahim Najjar Over a year ago

i am accepting this as a correct answer since it is the only one given, i will look further into the matter, thank you.

Collectives™ on Stack Overflow

Generating both SQL Server CE database and entity model at runtime

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related