CODEWITHSUNDEEP
sqlsql-serverdatabase
fereshteh
fereshteh

Reputation: 539

how to use a desktop software without having sql server installed on system?

consider I write a desktop software in C# for example,and it reads/writes data to/from sql server,Can I run this software on a system without having sql server installed.

I saw the two links of stackoverflow,but did not get my answer.

I want to know CAN THAT BE DONE OR NOT?

if yes,how?

thanks in advance.

Upvotes: 0

Views: 249

Answers (2)

Basilevs
Basilevs

Reputation: 23958

There are many SQL engines that can be embedded in desktop application. For example SQLite, there should be one with C# interoperability.

Upvotes: 1

Joel Coehoorn
Joel Coehoorn

Reputation: 416141

Sql Server must be installed, and running, somewhere to be able to use it. However, this does not need to be on local machine. The most common scenario for Sql Server is to be installed on a dedicated server machine off in a data center somewhere, and either many clients will connect to and use the same database, or one or a few web servers will connect potentially many times per second with different requests. It's not really intended for desktop use.

If you want to build a desktop app, and you want a database to use only as a local data store, Sql Server is actually a really poor choice for this. That includes the free Sql Server Express. Don't use it for applications that will be distributed to end users, where all the data will kept on each user's local system. It is a server-class engine, and works best when it can run on dedicated hardware.

Instead, you want a desktop-class or in-process database engine, such as Sqlite, Sql Server Compact (not Express) Edition, or even MS Access.

Upvotes: 5

Related Questions