I am looking for a means of database interaction in which the database will be stored on a user's machine but with no actual server software running. I have read there is some way to create databases in SQL express and then take the files for use in your application but I can't seem to find any articles on it; could someone try to point me in the right direction or contribute any information you think may be of use?
Search for sql server private deployment on the msdn website.
If your looking for sql server ce you have to do the following
You have to add a section to your config file
<Add name="Microsoft SQL Server Compact Data Provider"
description=".NET Framework Data Provider for Microsoft SQL Server Compact"
type="System.Data.SqlServerCe.SqlCeProviderFactory, System.Data.SqlServerCe, Version=184.108.40.206, Culture=neutral, PublicKeyToken=89845dcd8080cc91"/>
And then add the following files to your project.
8.System.Data.SqlServerCe.Entity.dll and add a reference to this dll
The build action should be Content
Copy To Output should be Copy if newer.
There will no longer be a need for sql server ce as a prerequiste for the app.