ADO.NET

The source code for this post has been updated to VS 2017 (master branch). There is also a VS2015 branch for Visual Studio 2015. ASP.NET Core and Entity Framework Core are getting more and more attractive nowadays and this post… Read More ›

BrowseDotNET is an open source ASP.NET MVC Web Application I created, that can help you manage your computer’s .NET solutions and code samples (programming language indepented) in one place. What does it solve? It’s common sense for developers to have… Read More ›

In this post we will see how to insert a really large amount of records in a SQL Server Table at once. I decided to write about this cause recently I found myself having difficulties while trying to deploy a… Read More ›

SqlCommand class can be used in various ways to access database data and it’s true story that many developers are somehow confused in which one to choose each time the want to execute queries in the SQL Server. In this… Read More ›

Requesting SQL Server for multiple results is a very common scenario while programming. Instead of asking for records with a single SELECT statement, you may find yourself want to retrieve multiple results in a single Query. For example, consider that… Read More ›

In nowadays, you won’t find any large scale application that doesn’t make use of some kind of Caching technique. Caching application data can boost application performance and of course improves User interface experience. In ASP.NET there are several kind of… Read More ›

SqlCommand is the alternative way to query, insert, update or delete database data. We have seen in lot’s of other posts on this blog, how to execute CRUD operations on a database using the Entity Framework and more specifically an… Read More ›

There are a few different ways to execute a Stored Procedure through a C# application, each of them following different principles. One of the most used approach is to use an SqlCommand object of type CommandType.StoredProcedure and invoke it’s ExecuteReader()… Read More ›

Retrieving and manipulating Entities with no related data using Web API and Entity Framework is quite easy and most times, by the time you create a Web API controller using a specific Model class and a DbContext instance you won’t… Read More ›

ListView control is probably the best among all data bind build-in controls in ASP.NET Framework. It is used extensively by ASP.NET Web Forms developers and is preferred between other similar controls, such as the GridView or the DataList. The reason… Read More ›