ORM mapper for windows 7 phone

Question

I thinking of using SQLite with win7 phone for development of my app. I looking for an ORM mapper which will work with Windows 7 phone and SQLite.

Answer 1

So far I've found following ORM's that support WP7:

• Vici CoolStorage
• mentioned already OpenNETCF.ORM Framework
• Mono.Data.Sqlite.Orm

Hope it helps somebody.

Answer 2

I created a lightweight, extensible ORM for the Compact Framework. While my reference implementation uses SQL Compact, I know one developer who got it working with SQLite on WinPhone in less than a day by simply following the SQL Compact version as a template. I've been meaning to do that port myself, I've just not found the time.

It's probably worth noting at this point that he also abandoned it because SQLite (not the ORM framework) was very, very slow.

Answer 3

If you are not convinced of using SQLite, you should give Db4o a try. It is an object oriented database, so you won't need an ORM tool (assuming that you just want object mapping). Also, it supports linq queries.