What is the maximum allowed size for a SQLite DB and can I use PetaPoco as an ORM?

Question

What is the maximum allowed size for a SQLite database in a Windows Forms application?
Can I use PetaPoco as an ORM, or can you suggest a similar ORM?

Answer 1

Concerning your max size question the limit is about 14 terabytes (http://www.sqlite.org/limits.html).

And I think you can use PetaPoco, since this lines can be found in PetaPoco.cs:

    enum DBType
    {
        SqlServer,
        SqlServerCE,
        MySql,
        PostgreSQL,
        Oracle,
        SQLite
    }

Answer 2

You can use PetaPoco. The current version 3.0.4 supports SqlLite.

Answer 3

Concerning your PetaPoco question:

No, you can't use PetaPoco because it doesn't support SQLite.
Quote from the main page:

Works with SQL Server, SQL Server CE, MySQL, PostgreSQL and Oracle.

If you don't want to usw a full-blown ORM like NHibernate (which suppports SQLite), there are other Micro-ORMs like PetaPoco:

• Dapper (made and used by the folks here at Stack Overflow)
• Massive (by Rob Conery)

Dapper is completely database agnostic, Massive explicitly supports SQLite.