Forum Xamarin Cross Platform with Xamarin

Best sqlite orm

Hi !

I am looking for an sqlite orm that supports lazy loading and linq.
I also need it to be fast as I deal with a lots of records.

I have found sqlite.net and sqlite.net extensions but it does not support lazyloading... :(

Best Answer

Answers

  • stvansolanostvansolano UMInsider, University ✭✭✭

    Hello @WerckAyrton you could give a try to the recently introduced Realm for Xamarin and check its lazy loading features.

    There are some opened discussions about Realm in the Xamarin Forums with our friend @AndyDent who can help with that :)

  • AndyDentAndyDent AUMember ✭✭

    Thanks @stvansolano - yes I'm very happy to answer any questions including how Realm works. We have tried very hard to make it as simple and idiomatic as possible including a lot of effort on the LINQ support.

    Yes, our loading is lazy - you can read more about that in the Queries section of the docs.

    If you're interested in how we currently implement LINQ, all that source is part of our release on Github. Specifically, see the linq folder.

  • WerckAyrtonWerckAyrton FRUniversity ✭✭
    edited May 2016

    Thanks, I am really glad to see that realm come to xamarin. Sqlite.net is nice but lack of performance for my needs.

    Can I convert my model that use Lis to IList to ease the migration?

Sign In or Register to comment.