Dapper Recipes

The Dapper Recipes are for developers who want to quickly learn how to use the Dapper in C# by examples. Each recipe is designed to focus on solving specific problems or tasks.

Quick start:

Download and install the AdventureWorks2022 sample database https://github.com/Microsoft/sql-server-samples/releases/download/adventureworks/AdventureWorks2022.bak
Modify the SQL Server connection string in AppSettings.cs to match with your SQL Server name.
Open a C# Jupyter notebook .ipynb file with Visual Studio Code and run it.

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Repository files navigation

Dapper Recipes

Table of Contents

1. Introduction

2. Basic CRUD Operations

3. Advanced Features

4. Performance and Best Practices

About

Releases

Packages

Languages

Name		Name	Last commit message	Last commit date
Latest commit History 35 Commits
AppSettings.cs		AppSettings.cs
How-to-connect-to-a-database.ipynb		How-to-connect-to-a-database.ipynb
How-to-execute-queries-and-commands.ipynb		How-to-execute-queries-and-commands.ipynb
How-to-filter-and-sort-data.ipynb		How-to-filter-and-sort-data.ipynb
How-to-handle-errors-and-exceptions.ipynb		How-to-handle-errors-and-exceptions.ipynb
How-to-handle-transactions-and-concurrency.ipynb		How-to-handle-transactions-and-concurrency.ipynb
How-to-insert,-update,-and-delete-a-single-record.ipynb		How-to-insert,-update,-and-delete-a-single-record.ipynb
How-to-insert,-update,-and-delete-multiple-records-with-Dapper.Contrib.Extensions.ipynb		How-to-insert,-update,-and-delete-multiple-records-with-Dapper.Contrib.Extensions.ipynb
How-to-insert,-update,-and-delete-multiple-records.ipynb		How-to-insert,-update,-and-delete-multiple-records.ipynb
How-to-map-query-results-to-objects.ipynb		How-to-map-query-results-to-objects.ipynb
How-to-measure-and-improve-Dapper-performance.ipynb		How-to-measure-and-improve-Dapper-performance.ipynb
How-to-perform-bulk-insert,-update,-and-delete-operations.ipynb		How-to-perform-bulk-insert,-update,-and-delete-operations.ipynb
How-to-run-multiple-queries-simultaneously-and-bind-the-result.ipynb		How-to-run-multiple-queries-simultaneously-and-bind-the-result.ipynb
How-to-set-up-the-development-environment.ipynb		How-to-set-up-the-development-environment.ipynb
How-to-use-caching-and-buffering.ipynb		How-to-use-caching-and-buffering.ipynb
How-to-use-custom-SQL.ipynb		How-to-use-custom-SQL.ipynb
How-to-use-multi-mapping-and-multiple-results.ipynb		How-to-use-multi-mapping-and-multiple-results.ipynb
How-to-use-parameters-and-dynamic-parameters.ipynb		How-to-use-parameters-and-dynamic-parameters.ipynb
How-to-use-stored-procedures.ipynb		How-to-use-stored-procedures.ipynb
How-to-use-temporary-tables.ipynb		How-to-use-temporary-tables.ipynb
How-to-write-clean-and-maintainable-code-with-Dapper.ipynb		How-to-write-clean-and-maintainable-code-with-Dapper.ipynb
What-is-Dapper-and-why-use-it.ipynb		What-is-Dapper-and-why-use-it.ipynb
readme.md		readme.md

frankwwu/Dapper-Recipes

Folders and files

Latest commit

History

Repository files navigation

Dapper Recipes

Table of Contents

1. Introduction

2. Basic CRUD Operations

3. Advanced Features

4. Performance and Best Practices

About

Resources

Stars

Watchers

Forks

Releases

Packages 0

Languages

Packages