From the course: Advanced SQL for Application Development

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Limitations of ORM and cautionary advice

Limitations of ORM and cautionary advice

From the course: Advanced SQL for Application Development

Start my 1-month free trial

Limitations of ORM and cautionary advice

“

- [Lecturer] Now Object Relational Mapping systems work really well when you have relatively straightforward, not too complicated data models and you really want to work in a more object oriented fashion and keep your application code consistent. So you're not switching say between an ORM, oriented development model and a more SQL relational specific. Now that said, there are however limitations of ORMs that you should keep in mind when deciding if you want to use them. Now, there are several times where an ORM may not be a good fit. For example, when you're working with a complex data model that might require a lot of different joints, or if the data model is becoming more complex over time, then the complexity of the code that ORM has to generate will become more complex, and you may be risking some either performance issues or other issues that make using an ORM less of a good fit than just using SQL directly.…

Contents