sumit: Coding Blog

This is my personal blog. The views expressed on these pages are mine alone and not those of my employer.

[digitalshakti-blog]

What is (N+1) situation in ORM?

Here, I will attempt to post multiple answers, links or other useful info to this question.

A: (N+1): It is a situation you get into Object Relational Mapping (ORM). You build your database (db) query in code; It is delayed execution - only when you enumerate or directly execute it, will then be sent to the db. Lots of time the records that you seek will have related records. (Categories.Products when you loop over each product -> that is an individual connection  and select statement sent to the db.  Select N + 1)….big problems that an ORM tools have.

(Please provide feedback if possible)

[digitalshakti-blog]

Prism Introduction

Prism is a Composite application framework, relies heavily on design patterns such as Dependency Injection, IoC, Command Pattern, MVVM, etc.

Prism is designed around architectural design patterns such as: separation of concerns, and loose coupling. The benefits are: Reuse (including cross platform), extensibility, flexibility, supports team development, and quality.

TODO: more description to come.