How to create a Local Database in windows phone 8 app?

Question

Hi i am new to windows phone 8 development,

I am developing a app which needs to store a large amount of data in local database of the app.

1) Can i know what is the most reliable option to create and store data in local database ?

2) What are the various options available for creating a local database in windows phone 8 application ?

i request to please let me know.

Thanks in advance

score 2 · Answer 1 · edited Jan 28 '13 at 08:58

2

I can not answer which is the most reliable, but if you want to use a built-in database you should use LINQ to SQL. See Local database for Windows Phone.

edited Jan 28 '13 at 08:58

nkchandra

5,585
2
30
45

answered Jan 28 '13 at 08:57

kls

591
3
13

2

I don't think SQLCE is available for native WP8 apps. – Derek Beattie Jan 28 '13 at 18:48
1

You are right that SQL CE does not support Windows Phone 8. However, there is LINQ to SQL support in Windows Phone 8 using a local database that runs in the same process as the app and stores its data in the app folder. It is not possible to use Transact-SQL to this local database. – kls Jan 29 '13 at 10:39

Derek Beattie · Accepted Answer · 2013-02-10T03:02:53.520

1

Use SQLite

Working with SQLite in Windows Phone 8: a sqlite-net version for mobile

sqlite-net-wp

There is also Sterling, I don't think there is a WP8 build but it wouldn't be difficult to create one.

edited Feb 10 '13 at 03:02

answered Jan 28 '13 at 08:03

Derek Beattie

9,429
4
30
44

score 1 · Answer 3 · answered Sep 05 '13 at 10:32

1

maybe you should try iboxdb.net, there have a test on pc storing a large amount of data, it can run on windows phone 8 , and includes a net2.0 version that can run on android with mono

answered Sep 05 '13 at 10:32

Bruce

61
1

How to create a Local Database in windows phone 8 app?

3 Answers3