C# Programming | Sql Execution Injectable Service смотреть онлайн

?? Is there a better way to execute SQL commands and queries rather than using standard .NET ADO? Yes! Let's walk through it!

?ISqlExecutor and Dapper

(https://github.com/Jcouls29/SparcpointUniversity)

⚠️⚠️ In this video we cover an injectable SQL Executor that allows a clien to easily execute SQL Statements from any repository class, as needed without a lot of setup or service registration. We offer some techniques on how to inject the service efficiently while encapsulating the logic for the injection. As a bonus we walk through adding an additional extension method to decorate any implemented ISqlExecutor with a transaction.⚠️⚠️

?Contact Information
- http://www.sparcpoint.com/contact/contact-us
- [email protected]

In this Video:
? Visual Studio 2019 Community - https://visualstudio.microsoft.com/downloads/
? Dapper - https://github.com/DapperLib/Dapper
?Microsoft SQL Server - https://www.microsoft.com/en-us/sql-server/sql-server-downloads
?Sql Server Management Studio (SSMS) - https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15

Source Code:
?https://github.com/Jcouls29/SparcpointUniversity

Useful:
? Sparcpoint - http://www.sparcpoint.com
? Sparcpoint Blog - https://www.sparcpoint.com/blog/blog
? Github - https://github.com/Jcouls29
? YouTube Symbols - https://unicode-table.com/en/sets/symbols-for-youtube/#sub-menu-link-9
? .NET Core Runtime - https://github.com/dotnet/runtime
? .NET Core Runtime Style Guide - https://github.com/dotnet/runtime/blob/main/docs/coding-guidelines/coding-style.md

00:00 - Introduction and Main Points
01:43 - Legacy Style SQL Execution and Query
07:55 - ISqlExecutor Interface
10:47 - SqlServerSqlExecutor Implementation
22:34 - Introducing Dapper
29:22 - Extension Method for IServiceCollection
36:17 - Bonus: Adding Transaction Functionality (Decorator Pattern)
45:35 - Conclusion

⚠️⚠️⚠️#SoftwareArchitecture #CSharp #Coding ⚠️⚠️⚠️