10. CRUD with Dapper in a .NET 6 using SQL Server in Hindi

Dapper is a simple object mapper for .NET. It is available as Nuget Package. It performs well because it doesn’t translate queries that we write in .NET to SQL. It is SQL-Injection safe because we can use parameterized queries. It supports multiple database providers. It extends ADO.NET’s IDbConnection and provides useful extension methods to query our database. It supports both synchronous and asynchronous methods.

Execute : Use this to execute a command one or numerous times and return the number of changed rows.

Query : This can execute the query and map the result.

QueryFirst : This executes the query and maps the first result.

QueryFirstOrDefault : This executes the query and maps the first result, or a default value if there is no result.

QuerySingle : This executes the query and maps the result. It throws an exception if there is no record.

QuerySingleOrDefault : This executes the query and maps the result. If there is no record, it will default a value. It will throw an exception if there is more than one element in the result.

QueryMultiple : This executes multiple queries within the same command and maps the results.

Quizz Today is an Online classes for Computer courses like DCA, ADCA, Web Designing, ASP.NET, Spoken English, ASP.NET Core, MVC, sql, jQuery, html, css, react, angular etc.


#dotnet6
#mvc
#mvc5
#dotnetprogramming
#dotnet6
#dotnetprojectcenters
#dotnetconf
#dotnetmaui
#dotnetdeveloper
#dotnet7
#dotnetcore
#dotnetproject
#dotnetwithjquery
#jquery
#jquerytutorial
#jquerydotnet
#tempdata



Our Other Playlist :

Blazor tutorial for beginners in Hindi
   • Blazor WebAssembly Tutorials - Gettin...  

QR code in ASP.NET Core in Hindi
   • How to make QR Code using .net core i...  

Windows Presentation Foundation - WPF in Hindi
   • 01 Introduction to WPF  

JavaScript Tutorial In Hindi
   • 01 Introduction of JavaScript in Hindi  

Advance ASP.NET Core 6.0 in Hindi
   • 01.Learn ASP.NET Core 6.0 - ASP.NET C...  

Asp.Net Core Web API Tutorial in Hindi
   • Web API Course Benefits and Pre Requi...  

Asp.Net Core 6.0 tutorial in Hindi
   • Introduction of  NET Core 6 0  

HTML Tutorial for beginners in Hindi
   • What is HTML