|
Execute Stored Procedures using SqlCommand in ASP.NET Core |
|
In the previous article we developed a Razor Pages app that provides the UI for performing CRUD operations using the CustomerRepository. It would be worthwhile to know how stored procedures can be called using SqlCommand object. That's what we are going to cover in this article. |
|
Posted On : 26 Sep 2022 |
|
|
Create Razor Pages app that uses Customer Repository |
|
In the previous article we completed the CustomerRepository class that performs CRUD operations on the Customers table. Now it's time to use the CustomerRepository in a Razor Pages application so that we can test the CRUD operations from the browser. |
|
Posted On : 12 Sep 2022 |
|
|
Execute action queries using SqlCommand in ASP.NET Core |
|
In the previous article we used SqlDataReader to execute SELECT queries and to read data from the database. You often need to execute action queries - INSERT, UPDATE, and DELETE - on the database to perform the respective operations. As far as as SQL Server data provider is concerned you can do that with the help of SqlCommand object. That's what we are going to discuss in this article. |
|
Posted On : 16 Aug 2022 |
|
|
Use SqlDataReader to Read Data in ASP.NET Core |
|
In the previous article we learned the basics of the ADO.NET data provider for SQL Server. We also took a glance at the SQL Server data provider's object model. Now it's time to put those objects to use in a simple CRUD web application. To that end this article kicks off the development by creating a simple repository for performing the CRUD operations. |
|
Posted On : 08 Aug 2022 |
|
|
Understand ADO.NET Data Provider for SQL Server in ASP.NET Core |
|
At times you may want to skip using EF Core and delve into the underlying data provider yourself. It would be helpful for beginners to understand how EF Core might be working behind the curtains of easy to use ORM. To that end this article gives you a brief overview of the ADO.NET data provider for SQL Server. |
|
Posted On : 01 Aug 2022 |
|
|
Use SQLite In-Memory Database in ASP.NET Core |
|
In the previous article you learned to use Entity Framework Core InMemory provider to store and retrieve your application data for testing and demoing purposes. An alternative (and a recommended option) is to use SQLite database in in-memory mode. To that end this article discusses just that. |
|
Posted On : 25 Jul 2022 |
|
|
Use Entity Framework Core In-Memory Database in ASP.NET Core |
|
Most of the production cases call for storing data in some physical data store such as a SQL Server database. However, for testing and demoing purposes you may want to store data in memory rather than persistent store. That's where Entity Framework Core InMemory provider can be helpful. In this article we will examine the usage of the EF Core InMemory provider in an ASP.NET Core Razor Pages application. |
|
Posted On : 18 Jul 2022 |
|
|
Create master detail components in Blazor Server (Detail CRUD Components) |
|
In the previous part of this article series you developed ListTeamMembers.razor component. Now you need to develop the remaining components namely ShowTeamMember.razor, InsertTeamMember.razor, and UpdateTeamMember.razor. You have already these empty component files in the Shared > TeamMembers folder. The UI rendered by the ShowTeamMember component is shown below.
|
|
Posted On : 20 Jun 2022 |
|
|
Create master detail components in Blazor Server (List of Team Members) |
|
In the preceding part of this article series you created master CRUD components namely ListTeams, ShowTeam, InsertTeam, and UpdateTeam. Continuing your development you will complete the detail CRUD components in this part. By the end of this part you will be able to see master-detail behavior and CRUD operations in action. So, let's get started with the detail components.
|
|
Posted On : 06 Jun 2022 |
|
|
Create master detail components in Blazor Server (Master CRUD Components) |
|
In the previous part of this article series you developed the List component that displays a list of Teams in a table. In this part you will create ShowTeam, InsertTeam, and UpdateTeam components to perform the CRUD operations on the Teams table.
The following figure shows how the ShowTeam component displays a Team in the browser.
|
|
Posted On : 19 May 2022 |
|