« Library Functionality in ERP | Main | Library Functionality for a Service Unit »

Microsoft Data Access Technologies - SWOT Analysis

 While architecting Data Access Layer for Microsoft .NET application opens up several options such as ADO.NET, LINQ to SQL, Entity Framework, and WCF Data Services amongst the key ones. Tough to choose the right one for the job as each one is designed for niche scenario and has Strengths, and Weaknesses. Herewith we have evaluated and benchmarked for performance each one of these technologies and compiled a report that you may want to leverage in your decision making.

Some of the other interesting papers from our team can be downloaded from here.

TrackBack

TrackBack URL for this entry:
http://www.infosysblogs.com/apps/mt-tb.cgi/3845

Comments

Sudhansu, very nice paper with statistics that will help Architects to choose and justify selection of any particular data access technology. But I have one doubt: Is WCF Data Services a data access technology on its own? IMHO, it is just an enabler to expose your data as resources (WCF'ying your data) and internally uses another data access technology (like EF, LINQ to SQL).

BTW, we recently created one WCF Data service and finally discarded it after integrating testing in favor of creating and calling a stored procedure using ADO .NET due to performance issues.

Hi Laxman
Thanks for your comment, good to hear from you.
Yes indeed WCF Data Services intrun uses Entity Framework or other LINQ providers as you have mentioned (also check architecture diagram in paper).
However, WCF Data Services have a role to play in niche scenarios like REST enabling, exposing Database entities as services,RSS, ATOM feeds, etc.
To achieve such objectives alone with Entity Framework or ADO.NET would involve significant amount of custom implementation to deliver REST,ATOM feeds, etc. You would appreciate that anything on web will have to be delivered over http.

WCF Data Services uses Http internally and hence understandably it will be less performant than others which uses TCP or others. The same is proved through the performance benchmakring report captured in Appendix.
Hope this helps.

Post a comment

(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)

Please key in the two words you see in the box to validate your identity as an authentic user and reduce spam.

Subscribe to this blog's feed

Follow us on

Blogger Profiles

Infosys on Twitter