Select data from local database

Question

I'm trying to get my data that was stored in local database. I'm using for that something like this:

// Connect to the database and instantiate data context.
tablesDB = new TablesDataContext(TablesDataContext.DBConnectionString);    

// Define the query to gather all of the items.
var CategoriesTablesInDB = from CategoryItem todo in tablesDB.CategoriesTable
                                           select todo;

// Execute the query and place the results into a collection.
CategoriesTable = new ObservableCollection<CategoryItem>(CategoriesTablesInDB);

But my CategoriesTable have count = 0 after doing this, and CategoriesTablesInDB have it's sql query inside. I'm new to Windows Phone and I don't if it's the right way to do that. Is it something with my query is wrong, or I'm not doing it properly?

yes. what i mean is you're trying to add items in `ObservableCollection` :) — spajce, Jan 15 '13 at 13:25
@spajce Well... I'm not trying to add items exactly.. I don't have list or anything. I'm trying to execute query which return me items. So I don't think going through all the elements is possible. — dziwna, Jan 15 '13 at 13:37
I manage to solve that problem. Everything was right I just had empty database. — dziwna, Jan 17 '13 at 10:43

score 0 · Answer 1 · answered Jan 15 '13 at 13:07

0

Sadly, can't help you with exact answer. But if you are just getting started you could also try store data in SQLite instead of native local database. It helps you build cross-platform applications in future and has a wide community support.

answered Jan 15 '13 at 13:07

gleb.kudr

1,518
12
16

Select data from local database

1 Answers1