Should I Use an ORM only when dealing with Data Model objects?

I am new to ORM, and we started developing a new system using NHibernate as the ORM.

What is a good design for a container, assignment and items

————- 1 * ————– * 1 ——– | Container |——–| Assignment |———–| User | ————- ————– ——– ^ ^ | | ———- ————- | | | | ———- ———- ———- ————— | Flight | | Dinner | | Booking| | Reservation | ———- ———- ———- ————— This problem is one that I’ve stumbled upon in […]

Is it bad practise to create instances from a SQL-query?

I’m researching ways to create a OO-model/repository-layer using PHP’s PDO. My idea was to create model classes that represent a domain object and a repository class for each model that has the responsibility of:

What is the equivalent of Entity Framework in the world of Oracle shops? [closed]

It’s difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center. Closed 11 years ago. Within the world of developers/firms specializing in building/deploying […]

Mapping a legacy database to ORM using wrapper classes

I want to use an ORM with a legacy database, but I don’t want to expose some of the underlying data types. For example, some of the columns are nullable doubles or floats and I want my domain model to use non nullable decimals.

Using a DAO to abstract our ORM from the rest of the application

We’re using MySQL with Sequelize.js as the ORM.

Using a DAO to abstract our ORM from the rest of the application

We’re using MySQL with Sequelize.js as the ORM.

What is a good rule-of-thumb for naming link-tables?

In the same way that a publication table might relate to a person table via subscriptions, or a company table might relate to a person table via employee, I’m wondering if there is a descriptive way to relate a company table to a company_type table.

Getting related foreign keys from parent entities

I’m thinking about a design issue which affects my project’s data base. Supposing there are three diferent tables:

raw aql query in framework with Active Record pattern based ORM

I use yii framework that implements Active Record pattern as ORM base. It has CActiveRecord class that is a table wrapper class with attributes reflecting table columns. So each object of this class represents a database row.