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...