Is there any way to access database in BackgroundTask

Question

I have an project which worked with sqlite database, and one of its features is to update app tile by the data stored in the database on the specifed time, so I create a project for BackgroundTask, while, the problem is how can I get data from the database in this project?

Answer 1

Your problem is "how to connect to sqlite database"? If that's the point follow an example:

Loading a DataTable using SQLite and C#

DataTable dt = new DataTable();
	
	String insSQL = "select * from Alunos";
	String strConn = @"Data Source=C:\dados\MacorattiSQLite.db";
	
	SQLiteConnection conn = new SQLiteConnection(strConn);

	SQLiteDataAdapter da = new SQLiteDataAdapter(insSQL,strConn);
	da.Fill(dt);

A full tutorial can be found here: http://blog.tigrangasparian.com/2012/02/09/getting-started-with-sqlite-in-c-part-one/

Mark as answer if helpful.

Answer 2

Thank you, Deric. While, I am creating Windows Runtime app, your code my be for WinForm, any way, thanks very much.

Answer 3

Please, check out this https://visualstudiogallery.msdn.microsoft.com/23f6c55a-4909-4b1f-80b1-25792b11639e and this http://sqlwinrt.codeplex.com/