How can I create the C# database setup for clients ?

Question

0.00/5 (No votes)

See more:

i have tried many times to create a c# database Setup which runs on client side but i failed if you know any video link or any other helping material then please share it with me. I will be very thankfull to you.

What I have tried:

i have tried both the videos practice but not working:
How to install C# application with database on Client machine [2017] - YouTube[^]
[C# Application] How to create c# application Setup with SQL Server DataBase - YouTube[^]

Posted 19-Jan-19 5:37am

Member 14123234

Updated 19-Jan-19 9:02am

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

RickZeeland · Answer 1 · 2019-01-19T09:03:00

I can recommend this way of installing SQL Server: Modular InnoSetup Dependency Installer[^]
It uses the Inno Setup installer to install all kinds of prerequisites without including them in your setup, instead they are only downloaded if needed.

If you prefer an allround commercial installer, I can recommend Advanced Installer: https://www.slant.co/improve/topics/5669/viewpoints/3/~way-to-package-net-web-application-for-distribution~advanced-installer[^]

Even better would be to forget about SQL Server, as bundling it with your applications and setting it up is a real pain. There are alternatives that are much simpler and lightweight like PostgreSQL or SQLite. See: PostgreSQL Tutorial - Learn PostgreSQL from Scratch[^]

If you only need a lightweight database, see: https://www.slant.co/topics/274/~best-databases-for-a-small-net-application[^]

#realJSOP · Answer 2 · 2019-01-19T07:14:00

You're using an 3rd party install builder. Go to the manufacturer's website and ask them how to use their software.

Beyond that, when I write an app that uses a database, I prefer to write the SQL that's necessary to create the database, and let the app do the work (see if sql server is installed, and if it is, create/alter the database necessary. Your installer should either prompt the user to install the necessary db tools, or do it for them (after prompting them of course.

How can I create the C# database setup for clients ?

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0