TechBubbles Microsoft Technology BLOG

SOA Enabled DAL

Introduction

Traditional applications using relational data sources such as Oracle, SQL Server and DB2 to expose their business logic to external world in a tightly coupled manner. This tightly coupled approach leads to the performance\scalability issues. This post discusses the Designing a SOA enabled DAL with example.

Traditional Service Data Access

clip_image002

Above figure shows the set of web services accessing the same relational database. Every request from the client requires data access which creates the performance issue when multiple concurrent users are trying to access the database.

Traditional applications having their own databases and when we migrate to the SOA data integrity issues will arise.

SOA Model Data Access

clip_image004

SOA model represents the loosely coupled architecture where business logic and Data access logic are no longer integrated. We are using LINQ-SQL as an interface for the SOA DAL.

SOA DAL only exposes the DTO’s[Data Transfer Objects] to the services

DTO representing the Employee looks like the following

Data Transfer Objects

clip_image006

This DAL is a provider independent and can be pluggable to different databases by reading the provider from the configuration file.

The Data provider using LINQ to SQL looks as follows

Data Provider

clip_image008

clip_image010

The DataService that exposed through service layer looks like

clip_image012

Now You can call the above service in windows or web application. We have seen how we decoupled the application from data access logic.

More information on building the SOA data access at http://msdn.microsoft.com/en-gb/magazine/dd263098.aspx.

Share this post :

About the author

Kalyan Bandarupalli

My name is kalyan, I am a software architect and builds the applications using Microsoft .NET technologies. Here I am trying to share what I feel and what I think with whoever comes along wandering to Internet home of mine.I hope that this page and its contents will speak for me and that is the reason I am not going to say anything specially about my self here.

Add Comment

TechBubbles Microsoft Technology BLOG

Follow me

Archives

Tag Cloud