How to create an Internal database inside WPF application that doesn't require any outside connections?

Question

i am using C# WPF and created a WPF Desktop app , now i have problem exporting it to the client's computer, i am using SQL Server Management Studio 2014. Now the issue is that i want the Setup/installshield of the software to contain all the components of the said software so when i install it , it does not require extra Applications. i just want to have a database inside the finished application. not one that connects to an external database or any outside connections but one so all the data is readable, writeable, deletable from within the application itself. thanks

kkyr · Accepted Answer · 2020-05-19 20:14:39Z

2

You can use SQLite which can be found here.

A tutorial can be found here.

edited May 19, 2020 at 20:14

answered Oct 12, 2015 at 13:54

kkyr

3,8954 gold badges34 silver badges61 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Emmanuel DURIN · Accepted Answer · 2015-10-12 14:03:16Z

0

You can also use SQL Server Express that is limited in terms of Size ( 10Gb).

And it s easy to setup with MS installers

You'll have a connection string like :

<add name="ConnectionStringName"
    providerName="System.Data.SqlClient"
    connectionString="Data Source=(LocalDB\v11.0;AttachDbFileName=|DataDirectory|\DatabaseFileName.mdf;
   InitialCatalog=DatabaseName;
   Integrated Security=True;MultipleActiveResultSets=True" />

Regards

answered Oct 12, 2015 at 14:03

Emmanuel DURIN

4,9932 gold badges31 silver badges55 bronze badges

2 Comments

Syed Umar Over a year ago

Mister Emmanuel DURIN, can you please tell me where to use this connection string please??

Emmanuel DURIN Over a year ago

It goes in <connectionstrings> section of app.config. Look at msdn.microsoft.com/en-US/library/ms130978%28v=sql.120%29.aspx

Collectives™ on Stack Overflow

How to create an Internal database inside WPF application that doesn't require any outside connections?

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related