Applied WPF 4 in Context

Object Relational Mappers

The first challenge when you're working with a set of objects that need to be persisted on a database is creating specific database code, using a particular database language like T-SQL for SQL Server that will tell the database how to persist or retrieve the objects. You may, for example, need to inform SQL Server that a specific object called Customer should be persisted in a database table called tbl_Customers, and that the property FirstName should be persisted in a field of the table called fld_first_name, and so on.

Another challenging task may be to persist or retrieve a complex graph composed of a set of objects tied together by some relationships. For example, the Customer object may have a collection of child ...