Search code examples
asp.netdatabaseentity-framework-5servicestackormlite-servicestack

Is OrmLite truly database agnostic?

I am new to Service Stack and OrmLite, and was exploring ORMLite as an alternative to Entity Framework. 2 questions I have about this: - The reason EF appeals to me is the ability to separate the database operations and the business data model into separate layers - EF can run with whatever you specify in the connection string of the config file. ORMLite seems to have different flavors for different databases, and that concerns me because I don't want to have to make code changes repeatedly.

Am I understanding things correctly? Please clarify

Thanks

Suraj

Solution

  • OrmLite does support multiple database providers through the use of DialectProvider's.

    Basically whenever some RDBMS's deviate from the norm and require special attention, than this functionality is factored out into a Dialect provider so it can provide bespoke functionality and the default behavior be overridden.