best way to include database in a wpf program?

Question

I am new to c# programming and WPF technology. I have an idea of developing an engineering program. my program needs lot of data to work, so I need to include a database with my app. I have written the logic part but at this step I don't know how to add my data to program. should I simply create arrays of them in a class? or there is a better way to do this? I have heard about SQL, but I don't know how that relates to C# programming. also, I need my program to run on any PC without requiring the user to install any extra database program.

Chose embed DB (like SQL COmpact or SQLLite), then learn howto work with chosen DB. — tym32167
– tym32167, Commented Nov 29, 2016 at 19:06

William Xifaras · Accepted Answer · 2016-11-29 19:07:44Z

1

I would look into using SQLite. You will also need the System.Data.SQLite ADO.NET provider to work with it within your WPF application.

And the provider is available via. NuGet:

https://system.data.sqlite.org/index.html/doc/trunk/www/faq.wiki#q5

answered Nov 29, 2016 at 19:07

William Xifaras

5,3622 gold badges22 silver badges22 bronze badges

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

Comments

Timo Reymann · Accepted Answer · 2016-11-29 19:11:16Z

0

If you need an embedded object database try LiteDB (litedb.org)

So you use 100% C# managed code and need no knowledge about SQL. You just need to add the DLL to your program.

answered Nov 29, 2016 at 19:11

Timo Reymann

9037 silver badges20 bronze badges

Collectives™ on Stack Overflow

best way to include database in a wpf program?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related