What is your favorite ORM (None is a valid answer)?

Personally, I like Dapper because it gives me complete control over the SQL and is easy to use (well, at least for what I've been using it for).

Comments

[Kevin Peters]

Coming from C# definitely Entity Framework.
Now that I work mostly with TypeScript I would say TypeOrm

[Pacharapol Withayasakpunt]

Not a major ORM, but I really like Peewee (in Python).

Now, I am using TypeScript and I write my own. I am tempted to try Mikro-ORM, though.

Tried TypeORM, but it disappointed me.

SQL builder only, like Knex.js is also good, but as you see, I am tempted to write an ORM, if it doesn't exist.

[Rafael Ahrons]

I enjoy a lot working with Entity Framework and Dapper, now that I'm coding in python kind enjoying SQLAlchemy.

SQLAlchemy it's easy to set up and start coding, don't have a lot of configs to deal or classes, but LINQ in Entity Framework with CodeFirst damn...

[Japheth Ezekiel]

Hibernate! Because it's a suite of open source projects around domain models.

[peterkulik]

Dapper+1

[Michael Z]

eloquent is amazing.

[Rafael Acioly]

1. Eloquent from Laravel
2. Django ORM

[Sergiy Yevtushenko]

JOOQ. Perhaps because it's not a ORM in traditional sense but rather a query builder (and extremely convenient one).

[fullstackcoder]

From the .Net/C# perspective I go with dapper and petapoco for simpler stuff but entity framework for the heavy ones.

[Steven Torrence]

I haven't used many ORMs but I really like Active Record with Rails!