Debru Aklil is a senior software engineer/architect specialized on Microsoft Technology (.Net and SQL Server). He has 9+years of hands-on experience. He holds a Master’s of Science degree in Computer Science and a number of certifications.

 I created this website to share my professional experience and other related topics. In addition, this site is created to showcase my traditional resume in highly available and enhanced mode (not just a single sheet of 8×11 paper). I’ve also added a small portfolio section to show some of my professional work/projects.

In the technology section, you’ll find my personal blogs, articles, few of my recent projects and much more.

Posted in Uncategorized | Comments Off on

Entity Framework Repository Pattern

The repository and unit of work design patterns are used to create an abstraction layer between the data access layer and the business logic layer of an application. Implementing these patterns can help insulate your application from changes in the data store and provides the following design benefits:

1. TDD- facilitates automated test-driven development (TDD).
2. Hides the detailed data store mechanism/technology.
3. Code reusable and easy to use
4. Improve the code’s maintainability and readability
5. Dependency Injection: With repository pattern we can use Unity containers to
inject the relevant object that we want to use in the code.

Enterprise Data Repository (EDR): is a library design to be used in both web and standalone/non web application. It manages the lifecycle of the object context per http request for web application and one per thread in non-web applications.

Repository
The repository designed to more generic and simple to manipulation; to a chive this all the repository method is defend as generic type. With this design the repository will only be need to be created once as instance member and use it to manipulate different entities in the repository.

Unit of Work

Entity framework handles transaction across many operations over many different types. But in order to use multiple repository from the consuming application and able to synchronize multiple transaction across queries require a little bit of work, for instance, User Repository and Product Repository, we would not able to run queries across both, as they would be created via different instances of Object Context. One of the ideal patterns to resolve this problem will be to use unit of work patter. With Unit of Work we can coordinate the different repositories object context creation and destruction. Please click Here to download the source code

How to use it

var rep = IoC.Resolve();
Person p = new Person();
p.Name = “David Tylor”;
rep.Add(p);
var pers= rep.Search(s=> s.Name.Equals(“David Tylor”));
pers = rep.GetAll();

Posted in Entity Framework | Leave a comment

ASP.NET Membership Web Application

Full-featured ASP.NET membership management web application, it includes custom web profiles, custom membership provider and custom administration pages to support page by page access/authorization rules. Authorization management uses sitemap to access all URI in the application and set access rules for a user and/or role. It is built on top of an ASPNetDB by adding only two tables and few stored procedures. Now you have full membership administration application out of the box. Go ahead run your secure web application. Support SQL server 2008 and above.
You can download the source code for the library here.

Search Screen

Create User

Authorization/Access

Sitemap Management

Posted in ASP.NET | Leave a comment