Introduction to the selection of Windows Phone 7 Local Database

Introduction

I recently selected a Windows Phone 7 Local Database and recorded my experience. For database selection, consider the following:Performance,Stability,Footprint(Occupied file and memory size ),Cost(License type ),Ease of use(Access method, whether to provide management tools, etc ). The following describes some of the database implementations I have learned in Windows Phone and their advantages and disadvantages.

Windows Phone 7 database

Http://winphone7db.codeplex.com/

Windows Phone 7 database is a database based on isolated storage (independent storage). It is released in codeplex open-source database. It can be freely used in open-source or commercial projects using the MS open-source license, the advantage is that it is free, and footprint is very small and supports LINQ. The disadvantage is that it is too new, with no commercial experience, unclear stability, no management tools, and SQL is not supported.

Perst embedded database for Microsoft Windows Phone 7

Http://www.mcobject.com/perst_eval
Perst is an open-source object database (object-oriented embedded database system) that provides. NET and Java implementations. . Net supports Silverlight and Windows Phone 7. This is a dual license, GPL and commercial. GPL is used in open-source projects for free, and a license is required for commercial use. Support for multiple platforms:. net,. NET Compact framewrok, Silverlight, and Windows Phone. Support for LINQ and jsql, a wide range of documents and ExamplesProgram. Footprint is not big or small, 499 K.

Db4o

Http://developer.db4o.com/
Db4o is an old object-based database, which is implemented in Java and. Net versions. Db4o for Silverlight can be used for Windows Phone. Db4o documentation and examples are rich. It supports mono,. net,. NET Compact framework, Silverlight, and other platforms and is the most mature product. It also supports native queries and has powerful functions. Db4o adopts dual-license, gplv2 and commercial, and is open-source for free. It must be purchased for commercial use. Because of its powerful functions, footprint is also very large. The size of optical db4objects. db4o. dll is 688 K, and the size of other components is about 1 MB.

Siaqodb

Http://siaqodb.com/
Siaqodb is a non-open source object database that can run in. net 3.5 +, Mono 2.4 +, Silverlight 3/4, and Windows Phone. LINQ is the only supported interface and does not support SQL. It only supports a higher version and has no compatibility issues. footprint is very small and only 128 kb. It is very suitable for use on Windows Phone. In addition, siaqodb contains Windows Phone 7 example programs for convenient development and comprehensive documentation, as well as query tools, which are very easy to use. I think it is a better choice. The only consideration is non-open-source, with only a commercial license, $180 individual license. You are still considering whether to purchase ing.

SQLite for Windows Phone 7

Http://sviluppomobile.blogspot.com/2010/03/sqlite-for-wp-7-series-proof-of-concept.html

SQLite's well-known embedded database is basically the de facto standard for smartphone devices. SQLite for Windows Phone 7 is modified from C # SQLite and the storage medium is changed to isolated storage. In fact, I used SQLite in the beginning, because of its ease of use, portability, a lot of business experience, a wealth of management tools, and completely free to use, no license restrictions. However, SQLite is large, with 514 kb, and does not support LINQ or even ADO. net only supports the original SQLite API, which is inconvenient for development. For example, the read result set cannot be placed in dataset or datareader.

 

Effiproz database for Windows Phone 7

Http://www.effiproz.com/product_wp.aspx

Http://effiproz.codeplex.com/

Effiproz database is another open-source RDBMS database that supports Windows Phone, stored procedures, triggers, and other functions. It supports ADO. NET and even Entity Framework, and features are exceptionally powerful. Support dual-license, open-source use of Ms open-source license, commercial use of a single user $400. However, the footprint of this database is very large, with a size of 1361 K. I lost my interest in using this large footprint. At the same time, the open-source version is not updated much, and the new function modules are all implemented on the commercial version.

 

I'm reading Windows Phone 7 databaseSource codeWindows Phone 7 database supports exporting XML files from xap to the isolated storage database. If the performance is OK, I chose Windows Phone 7 database, but I am worried that the database is too new. I will modify the source code to implement the function. Whether to purchase siaqodb is also considered. This database is good, but it is not open-source.

 

 

Series Article

If you are interested in Windows Phone development, read my series of articles. This article is suitable for developers with. Net experience. Get started with Silverlight for Windows Phone development.

From zero to hero from Silverlight for Windows Phone 7 Development Series by James Lin