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 ›
ADO.NET
ADO.NET
BrowseDotNET: Manage your .NET Solutions and code snippets
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 ›
Insert millions of records in SQL Server table at once
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 ›
SqlCommands: What to choose between SqlDataAdapter, ExecuteScalar and ExecuteNonQuery
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 ›
Batch queries, Multiple Result Sets and Parameterized Queries in ADO.NET
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 ›
Caching SQL Server data in ASP.NET
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: The Entity Framework alternative to access databases
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 ›
Map CRUD Stored Procedures to Entities with Entity Framework
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 ›
Related entities and live search with Web API and Entity Framework
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 in ASP.NET 4.5
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 ›