Posting in C# with Commit & Rollback - Blazor Purchase Orders - Part 28
A C# project using Blazor to create a simple Purchase Order System, incorporating Syncfusion controls and using Dapper to link to a SQL database.
In this video I show how to post a purchase order so that header and details are posted as a single transaction, incorporating commit and rollback. We will be modifying our existing code to use a datatable to pass any number of order lines as a single object, and then incorporating order header and lines into a single transaction. We will also look at SQL UDT or user defined tables to pass a data set from C# to a SQL stored procedure.
00:00 - Introduction
01:13 - Review of current method of posting an order
02:35 - Purchase Order Lines and Data Tables
10:40 - Combining Order Header and Lines into a single service
16:10 - Using Transaction with Commit & Rollback
22:30 - Forcing an error to demonstrate Rollback
26:21 - Data Sets and SQL User Defined Tables
29:14 - Transaction: trans - to be added to the call to SQL Stored Procedure
33:00 - Postscript and updating SQL database in Azure
References:
Blazorcode.uk: https://blazorcode.uk/purchaseorders/...
Code: https://blazorcode.uk/purchaseorders/...
Microsoft Data Tables: https://docs.microsoft.com/en-us/dotn...
Tim Corey: Advanced Dapper in C#: • Advanced Dapper in C# - SQL Transacti...
Syncfusion: https://www.syncfusion.com/products/c...
Watch video Posting in C# with Commit & Rollback - Blazor Purchase Orders - Part 28 online without registration, duration hours minute second in high quality. This video was added by user Christopher Bell 29 July 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 781 once and liked it 18 people.