C# Project with Sql 2005 database

[JustRun]

Well, Hope someone answer me this time.

I have a SQL 2005 Database attached to my project with this connection string:

Data Source=.\SQLEXPRESS;AttachDbFilename=D:\CSharp\Store\Database\Store.mdf;Integrated Security=True
 

The problem is: when I release the project to setup.exe, it ask for the database,

I need a solution that doesn't require me to give the database to the client.

Please answer me

[cloud255]

Well if you want to maintain control of the DB, you will have to implement a client server application. Where the client machine connects to your server which will in turn handle DB actions...
Or you could place the database on a separate SQL server and provide the remote server name in the connection string, this will remove the need for a server side application but will reduce the security and flexibility of your overall solution.

[JustRun]

yeah, but what i mean is to let the setup folder contains the database as a non-readable file even the client has a SqlServer, he aill not be able to open it.
and the program only will be able to work with

Is this logical ? or it can't be proccessed?

[cloud255]

Well I've never done something like that before. If the file cannot be opened by SQL server you will not be able to run queries against the database, so I can't see why you would want to do something like that...

Also be careful here as the data generally belongs to your customer and not the developer, keeping the user from accessing their data (or forcing them to use your application to access their data) is probably illegal in most countries. You will have to check the laws regulating that in your region to be certain.

[JustRun]

You are right, it's not legal to force the customer and thanks for clarifying the SQL query point

Thank you

[Plater]

If you make your database take a specific username/password, then only applications that know the username/password (such as your own) can open it.