Windows Phone 7.1 和 Windows Phone 8 上的 Sqlite [英] Sqlite on both Windows Phone 7.1 and Windows Phone 8

问题描述

我正在为 Windows Phone 7.1(7.5) - 8(必须适用于两者)开发一个应用程序，其中需要数据库连接.这个应用程序已经在 Iphone 和 Android 上实现了，所以我必须使用那里的数据库文件来使所有应用程序的数据库结构都相同.Sqlite 用作数据库.适用于 Windows Phone 的所有 Sqlite 客户端都已过时，不再受支持.

I'm developing an app for Windows Phone 7.1(7.5) - 8 (Must work for both) , in which database connectivity is required. This Application is already realized for Iphone and Android, so I have to use there Database file to the database structure was the same for all applications. Sqlite is used as the database . All Sqlite Clients for Windows Phone are out of date and not supported any more.

• http://dotnetslackers.com/articles/silverlight/Windows-Phone-7-Native-Database-Programming-via-Sqlite-Client-for-Windows-Phone.aspx
• http://wp7sqlite.codeplex.com/
• http://www.wirebear.com/blog/2010/11/12/using-sqlite-in-your-wp7-app/
• http://sqlitewindowsphone.codeplex.com/releases

官方客户端仅适用于windows phone 8http://www.sqlite.org/download.html并且不适用于 Windows Phone 7.1

Official client is only for windows phone 8 http://www.sqlite.org/download.html and is not working with windows phone 7.1

如果有人能给我任何建议，我可以在这种情况下做什么，这将非常有帮助.

Will be really helpfull if someone can give me any suggestions what i can do with this situation.

• 仅针对 Windows Phone 8 开发并使用官方 Sqlite 客户端
• 将旧库用于 sqlite 并尝试在 Windows Phone 8 上使用它们
• 使用 SQL CE 作为数据库

(PS.:情况更加复杂，因为 Windows RT 不支持 SQL CE，只支持 Sqlite，这让我很抓狂.)

(PS. : The situation is further complicated by the fact that Windows RT is not support SQL CE and only Sqlite and it makes me crazy.)

推荐答案

如 dotnetslackers 链接 并且它在 WP 8 中工作正常(我在 WP8 模拟器中进行了测试).

I have used sqlite in my app for windows phone 7 as described in the dotnetslackers link and its working fine in WP 8 ( I tested in WP8 emulator).

我认为说Windows Phone 的所有 Sqlite 客户端都已过时且不再受支持"没有任何意义.你自己试过吗?

I don't see any point for saying "All Sqlite Clients for Windows Phone are out of date and not supported any more". Did you try yourself ?

另外此链接说Windows RT、Windows 8 现在支持 SQLiteMetro 应用程序，Windows Phone 8 将支持本地应用程序存储."

Also this link says "SQLite is now supported on Windows RT, Windows 8 Metro Apps and will be supported on Windows Phone 8 for local application storage."

这里还有一个链接，我没有测试.

And here is one more link, which I didn't test.

我建议您尝试 dotnetslackers 链接 如果您遇到任何问题，请在此处发帖.祝你好运！！

I suggest you to try the dotnetslackers link and post here if you face any problem. Good luck !!

这篇关于Windows Phone 7.1 和 Windows Phone 8 上的 Sqlite的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！