Keep it Simple

// practice, the distance between dream and achievement

Tag: Tools (page 1 of 9)

SQL Command based – Data Access Layer in C#

In the last post, we have used SQL stored procedure to perform the CRUD operations. It best suits when the CRUD operations involve complex data manipulation. However, sometimes we do not have to follow this path, especially when the SQL table is simple and CRUD operations are straightforward.

The objective of this article is to explain the simplest way of designing the Data Access Layer.

Continue reading

Data Access Layer in C#

Layered architectures are generally preferred for application development because of code reuse, flexibility, performance and maintainability.

In a layered architecture the Data Access is primarily responsible of communicating with the Database, whereas the business layer focuses on business logic and rules. The presentation layer concentrates on the UI.

The objective of this article is to explain the simple but an elegant way of designing the Data Access Layer of an application.

Continue reading

Design Patterns – Publisher – Subscriber

The Publisher/Subscriber pattern is one of the variations of the Observer designer pattern introduced by the GOF in software development. In the Publisher/Subscriber pattern a publisher publishes a message and there are one or more Subscribers who capture the published message and act upon. Using this design, I have separated the domain object and monitoring system that handles the exception on domain object.

Continue reading

Which Design Pattern to use?

If you ever think of this, I appreciate you, you are in the right direction. You know, there are few questions that has no answer and this is one of that kind. Personally, one of the most compelling exercises in software engineering is exploration, just like in any other engineering field. The rule is that there is no rule to use the Design patterns. Your experience (success more than failures) will tell you when to use them purely, when to adapt them or when not to use them at all.

As a communication medium, Design patterns are awesome. The more we build software with them in mind, the better off we’ll be as a community. They can help us elegantly construct solutions which can be readily discussed with peers.

Continue reading

Older posts

© 2017 Keep it Simple

Theme by Anders NorenUp ↑