Tag: ADO.NET

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 »

Sep 16

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 »

May 08

How to create SQL Data Access Layer in C# using ADO.NET – Part 2

How to create SQL Data Access Layer in C# using ADO.NET – Part 2 1.   Introduction In my previous post we discussed about the implementation of SQL Data access layer using C#. We created SQLHelper class to create CRUD functions to return ADO.NET objects like DataTable, DataSet, DataReader and Scalar values. Later on we created …

Continue reading »

May 06

How to create SQL Data Access Layer in C# using ADO.NET – Part 1

How to create SQL Data Access Layer in C# using ADO.NET – Part 1 1.   Introduction In my previous post we discussed about the implementation of generic data access layer using factory pattern and using DbProviderFactory. This article would be useful for those developers who use SQL Server as a database and C# as a …

Continue reading »