Tag: Entity Framework

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

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

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

Entity Framework Interview Questions

Interview questions

Entity framework is now quite old ADO.NET approach and peoples uses this almost in every projects. I have made consolidated list of all frequently asked entity framework interview questions and generally useful for junior and senior developers. What is ORM? Which ORM did you used? Any other ORM’s do you Know? What is Entity Framework?a …

Continue reading

Difference between Entity Framework and LINQ to SQL

Couple of days back I started to do code review for Web based .Net Application. The technology stack used for that application was ASP.NET 4.0, SQL Server and LINQ to SQL for accessing data. This was my first experience on LINQ to SQL because I never worked before on LINQ to SQL. I generally preferred …

Continue reading