Click here to Skip to main content
15,895,011 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
i have created server client windows app with c# on my pc and my lan server machine with database and tables .



now i am creating .exe file of app

if i install this .exe to user's machine(client) and the server machine of client autometically create database and tables which is required to store data ?

or i have to manually create database and tables in user's server machine ?

i have 64 tables in one database .
so is there any chance to create database and table autometically in server machine ?

if yes please show me the process for doing this task.

What I have tried:

i am not checked yet that database and tables created or not

i am confused on that this is my first project.
Posted
Updated 8-Jul-16 3:17am
v2
Comments
Dave Kreskowiak 5-Jul-16 9:44am    
That depends on how you've written your database code. Did you use some ORM library, like Entity Framework, or did you write all of your database interaction code yourself?
Member 12592153 5-Jul-16 12:03pm    
no i didnt use any ORM library

1 solution

Follwo the follwing steps

1. Generate the Database script and run it on client PC.

2. Generate the setup run it on the server and change the connection string.

3. Run the application.
 
Share this answer
 
Comments
Member 12592153 11-Jul-16 7:45am    
thanx for helping Ehsan
but can u tell me how to genrate database script
and which connection string should i change ?

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900