CODEWITHSUNDEEP
c#mysqlsql-serverdatabasedesktop-application
Abey Mathew
Abey Mathew

Reputation: 73

How to run desktop application with database locally without installing any database Server?

I wanted to create a desktop application with database, am using Visual Studio 2013 and C# , Can anybody suggest me what server I used to create my database, in order to run my application in my client's system locally with out installing any database server in client's system [ie, with out installing MsSql server or MySql server or Acess], I want my app works properly when installing my own application's exe file ?

And Now am using MSSQL server with my application , Is there any way run this application in client's system locally with out installing MSSQL Server? [my application front end works when I install .Net FrameWork 4.5 , I need something like this for my .mdf databse in Sql Server]

somebody says about SQL Server Compact ,but i don't know how to use it

Upvotes: 7

Views: 18379

Answers (2)

RandomSeed
RandomSeed

Reputation: 29809

It is not unusual for an application to require an existing functional database server. Of course this is appropriate only if your target audience is technical enough to install the prerequisite on their own, or if the target environment is guaranteed to already meet your prerequisite.

If not, you need to fall back to an embedded database.

Upvotes: 0

beercohol
beercohol

Reputation: 2587

You can use SQL Server Compact, which can either be installed separately or deployed as part of your application.

See here: How to deploy SQL Server Compact Edition 4.0?

And here: https://msdn.microsoft.com/en-gb/library/aa983326(v=vs.110).aspx

Your DB code in your app - apart from your connection string - should not need to change as you're already using some version of SQL Server.

There is also SQLite, which is as far as I know is well regarded, but I know very little about it. http://www.sqlite.org/

Hope that helps!

Upvotes: 2

Related Questions