We can Update Database Records with ADO.NET in any ASP.NET Core application quite easily. Let's add Update Records feature in our project. With this feature we will have the power to update any previously created records in the database.
Is ADO.NET fast? ADO.NET is very fast as it works with the databases directly. ORMs like Entity Framework Core and Dapper are created as a layer above ADO.NET and so they are slower by a few milliseconds when compared with ADO.NET.
(more…)
In this tutorial we will Read Records with ADO.NET and display these records in the form of a table. The records will be read from the Inventory table of the database. We will use SqlDataReader object for implementing this operation.
(more…)
In this tutorial we will Create Database Records with ADO.NET in an ASP.NET Core application. Creating Records is the first thing we do when making CRUD Operations. Here we will Create an Inventory form on the ASP.NET Core app. From this form we will be able to create a new inventory records in the SQL Server database.
On the last ADO.NET tutorial we went through ADO.NET, it's components and how to use it when doing database operations. You can check this tutorial from Learn ADO.NET by building CRUD Operations in ASP.NET Core.
Page Contents
The ASP.NET CORE framework defines a number of namespaces to interact with a Relational Database System like Microsoft SQL Server, Oracle, MySQL, etc. Collectively, these namespaces are known as ADO.NET.
(more…)
Let's start with the Advanced filter Topics - Filters with Dependencies, Global Filters, Order of Execution of Filters & Changing Filter Order. We covered Filters from start on previous tutorial called Filters in ASP.NET Core – Beginner to Expert level, if you haven't checked it make sure to do so.
(more…)
Filters in ASP.NET Core are used to run code before or after certain stages in the request processing pipeline. There are many built-in filters for authorization, logging, caching, exception handling and so on. Filters also help to avoid code-duplication in our projects.
What is difference between middleware and filters in .NET Core? Middlewares operate on each and every request coming to a .NET Core app on the other hand Filters operated only on request coming to MVC pipeline. Middlewares do not have access to HttpContext but filters have. We can run filters on specified actions and controllers (cannot do this on Middlewares) unless we register the filter globally in the program class.
(more…)
When you want to remove an element from the DOM use jQuery Remove Method. The .remove() will remove elements along with its children.
(more…)
What is Model Validation in ASP.NET Core? Model Validation is a technique to provide rules for model properties and validating these rules so that they are not broken. When rules are broken then appropriate error messages are displayed to the clients and this helps the clients to rectify the problems.
In this tutorial we are going to learn Model Validation with examples. So let us start without any delay.
(more…)
In this tutorial we will cover some of the most Advanced Model Binding Concepts with examples.
(more…)
What is model binding in ASP.NET Core? It is a process to Extract Data from HTTP Requests and provide them to the arguments of Action Method. Models contain the data that forms the business logic of the app. They are basically C# classes that contain the data from a database or other data source.
In ASP.NET Core there are 2 most important topics dealing with Models:
In this tutorial you will learn about Model Binding process in details.
(more…)