Investigate local storage

[gwilson2151]

• [x] ⚒ Tear out EF
• [x] 🏫 Identify candidates
• [x] 👷 Try out candidates in a sandbox
• [x] :tophat: Make final decision

Currently thinking SQLite + Dapper (or some other micro ORM).

[gwilson2151]

Micro ORM candidates are Dapper & NPoco.

[gwilson2151]

Dapper

Pros

• Close to System.Data API.
• Mostly just write SQL.

  Cons

• Why not just use System.Data?
• Some verbosity required when doing actual operations. Ex: Getting Id of newly created entity not so clean.

NPoco

Pros

• Nice fluent API

  Cons

• Boilerplate
• Mapping without attributes a pain
• Factory a pain
• Database abstraction a pain

[gwilson2151]

I think it's gonna be Dapper. 🎉