local database for each user in application

Question

In my c# windows application, I had a requirement to create a local database where the c# application's set up is installed. The data of login user through that computer must be stored in that local database.There is a sqldatabase which consist of all user's data.I need to import single user's data to their local machine database(MS Access) from sqlserver database..How can I fulfill my requirement?

Answer 1

SQLite works well for this and has plenty of documentation and .NET wrapper libraries to help get you up and running quickly.