Using Dapper ORM with ComponentOne Blazor

Using Dapper ORM with ComponentOne Blazor

Using Dapper ORM with ComponentOne Blazor. How to integrate Dapper with ComponentOne Blazor FlexGrid to perform CRUD operations. ComponentOne Blazor Edition is a set of blazor UI controls provided by ComponentOne.

What is Dapper?

Micro-ORMs are lightweight object-relational mappers (ORM), and Dapper, also known as the King of Micro ORM, is the most popular micro-ORM. It is a simple object mapping tool that lets you work with data using business objects in a .NET application without writing code to map query results from ADO.NET data readers to instances of objects. It is an open-source, lightweight ORM developed by the Stack Overflow team and is very fast compared to other ORMs primarily because of its lightweight. It provides support for both static and dynamic object binding using SQL Query, transactions, and stored procedures.

How Dapper Works

  1. Install Dapper using Nuget Package Manager.

  2. Create the POCO classes for database tables.

  3. Create an IDbConnection Object.

  4. Write a SQL query to perform either of the CRUD operations.

  5. Passe Query as Parameter in the Execute Method to fetch the desired results.

    ComponentOne Blazor Edition is a set of blazor UI controls provided by ComponentOne. For details, refer to  demos and  documentation.

This article will demonstrate how to perform CRUD operations on FlexGrid control from the ComponentOne Blazor Edition using Dapper.

Now, let's integrate the above steps to create a Blazor application that would use Dapper to perform CRUD operations in FlexGrid.

web .net blazor

Bootstrap 5 Complete Course with Examples

Bootstrap 5 Tutorial - Bootstrap 5 Crash Course for Beginners

Nest.JS Tutorial for Beginners

Hello Vue 3: A First Look at Vue 3 and the Composition API

Building a simple Applications with Vue 3

Deno Crash Course: Explore Deno and Create a full REST API with Deno

How to Build a Real-time Chat App with Deno and WebSockets

Convert HTML to Markdown Online

HTML entity encoder decoder Online

Blazor for ASP.NET Web Forms Developers PDF

In this blog post, I will share the Free e-book: Blazor for ASP.NET Web Forms Developers PDF. This book is great for ASP.NET Web Forms developers looking for guidelines. As well as strategies for migrating their existing apps to a modern, open-source, and cross-platform web framework.

Free e-book: Blazor for ASP.NET Web Forms Developers

Releasing new e-book: Blazor for ASP.NET Web Forms Developers. It covers guidelines and strategies for migrating existing apps to a modern web framework.

jQuery Ajax CRUD in ASP.NET Core MVC with Modal Popup

In this article, we’ll discuss how to use jQuery Ajax for ASP.NET Core MVC CRUD Operations using Bootstrap Modal. With jQuery Ajax, we can make HTTP request to controller action methods without reloading the entire page, like a single page application.

Blazor : Calling REST API ASP NET Core Blazor | WEB API

LIKE | COMMENT | SHARE | SUBSCRIBE How to call and consume a REST API from ASP.NET Core Blazor application. Blog : https://aspdotnetexplorer.blogspot.com/sea...

Asp.Net Web API Introduction

LIKE | COMMENT | SHARE | SUBSCRIBE API stands for Application Programming Interface. API is some kind of interface which has a set of functions that allow pr...