Author's posts

May 10

How to Call Stored Procedure using Unit of Work and Entity Framework

In my last post we learned how to call stored procedure using Repository Pattern and Entity Framework. In ExecuteReader function we saw how to map selected rows to plain(without complex) domain object.  Class DataReaderMapper used reflection concept to map properties. However this approach will use only for repository and not for ViewModel or DTO’s or …

Continue reading »

May 06

A reference guide to access data in .Net

Data access layer is one one of important aspect in any application. I have written many posts on data access later using ADO.NET, DBProviderFactories, generic repository and Entity Framework. So in this post I am consolidating all  posts in one place. I will update this section whenever I publish new post related to data access. …

Continue reading »

May 01

Tech News: Microsoft has released in .NET Framework 4.7.2

Microsoft has announced the release of the .NET Framework 4.7.2 it is included in windows 10 April 2018 Update. It is also available on windows 7+ and windows server 2008 R2+ You can download .NET Framework 4.7.2 using Web Installer or Offline Installer What’s new in .NET Framework 4.7.2? ASP.NET Changes Support for SameSite cookie in ASP.NET in Page, Custom …

Continue reading »

Apr 30

Microsoft Certification Roadmap for Developers

SQL Server 2012/2014 Development

Using Microsoft Certifications you can get hired, demonstrate clear business impact and advance your skill sets and take your career to the next level. Microsoft has segregated these certifications broadly in six major categories, Today I am going to guide you the Microsoft Certification paths (marked in above figure) for web/database developer who develops web …

Continue reading »

Dec 25

How to call stored procedure using repository pattern and unit of work

Yesterday I received one complain about performance issue of entity framework for bigger LINQ queries using repository pattern. Client had asked me my opinion about using entity framework and moving complex logic to stored procedures. However, developers were not aware of calling stored procedures using repository pattern hence they had created edmx file and called …

Continue reading »