How to Use Dapper in ASP.NET Core Web API

[@bonkeselemani503]

Prefere Dapper than EF, the freedom with Dapper 👌 😎

[@deepanjannag]

Excellent work! Very clear and easy to understand.

[@coding-gemini]

Very nicely explained thanks. Can you please post a video using dapper contrib which does not need us to write a sql

[@adlaimaschiach]

Very Nice ! what about stored procedures ?

[@berkayozkay1647]

Thank you for share this tutorial.

[@nikunj17484]

Superb, please upload with blazor + dapper example.

[@samirfighter1213]

thnx

[@2005Azm]

Wonderful!

[@Meke86109]

Sql server developer or express.. Which i have to use. Bro

[@TechWithPat]

You can use both, Express is free though.

[@Meke86109]

@@TechWithPat hi bro.. Can u create a video for how to login sql server and create admin, password, to create sql database and where we can find the data source of those database

[@Uzair_Anwar2299]

How you can use store procedure with dapper??

[@joaogabrielv.m328]

You could do that way (console app example):
// BookRepository
public static void GetBooks()
{
using var connection = new MySqlConnection("yourConnectionString");
var getBooksQuery = connection.Query("sp_select_all_books", commandType: CommandType.StoredProcedure);
foreach (var book in getBooksQuery)
{
Console.WriteLine($"Book Author: {book.Author}
Book Title: {book.Title}\Book Description: {book.Description}
");
}
}