Search code examples
c#ms-accessservicestackormliteormlite-servicestack

ServiceStack OrmLite with Ms Access Database First Approach

I am relatively new to servicestack. I have searched enough but couldn't find any answer. I have worked with sql database first approach with t4 templates which worked fine. But my scenario has been changed and now i have to work with Ms Access database. I tried to generate POCO with ORMLite but it didn't work.

So my question is Do ORMLite work with MS Access Database.

Or any other ORM which works with service stack to generate models/classes from database.

Solution

  • According to the ServiceStack Github page these flavours of databases are supported:

    • ServiceStack.OrmLite.SqlServer
    • ServiceStack.OrmLite.PostgreSQL
    • ServiceStack.OrmLite.MySql ServiceStack.OrmLite.Sqlite
    • ServiceStack.OrmLite.Oracle (unofficial)
    • ServiceStack.OrmLite.Firebird (unofficial)
    • ServiceStack.OrmLite.VistaDb (unofficial)

    So the answer must be: No, MSAccess is not supported.

    Regarding other ORM's, Dapper supports anything that has ADO.Net support, but to generate POCO's you need something that is not database-agnostic.