Windows Phone supports database Summary

What are the databases supported by Windows Phone and what are the advantages and disadvantages of different databases? Search for related resources on the Internet and sort them out:

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_evalperstis an open source object database (object-oriented embedded database system) with. 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 example programs. Footprint is not big or small, 499 K.

Db4o

Http://developer.db4o.com/db4o is the old object-based database, which has 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.

SQL Server CE

Windows Phone's local database SQL Server CE is a new feature of Mango update in version 7.1. Therefore, you must use Windows Phone 7.1 APIs to use the SQL Server ce database in applications.

 

See document:

Windows Phone local database overview http://msdn.microsoft.com/zh-cn/library/hh202860 (V = vs.92). aspx

Discussion on selection http://www.cnblogs.com/procoder/archive/2010/09/27/windows-phone-database.html of Windows Phone 7 Local Database

Windows Phone 7 Local Database SQL Server Ce (mango update) http://www.cnblogs.com/linzheng/archive/2011/06/08/2075593.html