Writing SQL queries is something NHibernate eliminates for the developers when writing data access code. Complex data models and Hibernate (HQL) queries can often lead to slow performing generated SQL resulting in overall database access performance ... [More]

Lets look at a brief code by code comparison of how to perform different data access operations using the Linq to Sql framework compared to using the Orasis Generated data access layer from a mapping project. Download the NorthwindDataAccess project... [More]

After reviewing all the major ORM technologies out there and participating in a project that was a classic ORM nightmare, I have come to the following conclusion: ORM is a good acronym but not a good concept. But, I must give credit where credit is d... [More]

Should you choose an ORM implementation or simply allow a tool to craft your data services to your actual and immediate needs? Do you need both options in your projects? Can an ORM implementation satisfy the performance requirements, the ease of us... [More]

One of the biggest concerns I face as a developer when writing SQL queries in my application is how to make them safe so that they are not prone to SQL injection attacks and at the same time they execute efficiently. Most developers go the route of p... [More]

This video demonstrates how to create a Persist mapping to update a table using the Orasis Mapping Studio’s persist mapping and data access code generation mechanism. Once the code is generated from the Studio and the assembly is successfully bu... [More]

Learn how generate data access code the smart way using mappings and smart code generation. [More]