CODEWITHSUNDEEP
c#sql-serverwindowswinforms
Abhijith
Abhijith

Reputation: 21

Database connectivity in windows form application

I have created a Billing Software using windows forms and sql server 2012.
Now i'm very confused over many things regarding database connectivity. After making exe file, for installing in client machine i have to install sql server in client machine and configure the database then install my application. My doubt is.. is this how this procedure works? I downloaded some billing software from internet and how they work without configuring a database? and which is the best practice? should i install sql server in client machine ?

Upvotes: 1

Views: 1018

Answers (2)

Takarii
Takarii

Reputation: 1648

If you just want a single standalone database per instance of the application - specific to the computer installed on - then you have a few options.

SQLite - https://sqlite.org/

SQL Server Express LocalDB (this is the 2016 version) -https://msdn.microsoft.com/en-us/library/hh510202.aspx

Both of these run stand alone databases that can be embedded into your program using visual studio. There are others, but these are the ones I'm familiar with.

Syntax for SQLite has some differences to its syntax (mostly package specific) however SQL Server Express LocalDB runs the same T-SQL as the standard SQL Server package

Upvotes: 1

Ralf Bönning
Ralf Bönning

Reputation: 15455

You do not have to install SQL Server on the client machine. The clients connect via network to the central database using some database client drivers.

Assuming that you are using ADO.NET then you have configure the clients somehow to use the right connection string, where server name, database name etc. is contained.

Upvotes: 1

Related Questions