AdvWorksDemo2

** -- Read Me -- https://en.wikipedia.org/wiki/README **

Welcome, this read me file is for the next step after basic use of data tools in Visual Studio 2022. This is a quick video series where you can learn how to connect, modify and create data in SQL Server in VS.

Assumption are that you have installed:

SQL Server Visual Studio 2022

This is a beginer video where we walk through some code and get some data to display.

Microsoft.Data.SqlClient: https://learn.microsoft.com/en-us/sql/connect/ado-net/introduction-microsoft-data-sqlclient-namespace?view=sql-server-ver16

https://learn.microsoft.com/en-us/sql/relational-databases/stored-procedures/specify-parameters?view=sql-server-ver16

Try/Catch https://learn.microsoft.com/en-us/dotnet/csharp/language-reference/statements/exception-handling-statements

Expand your skills:

1. Add try /catch to the sql insert statement.
2. Create a new class that gets and displays the audit data. Try to add it via a method first, then create a new class and call it to do the select.

https://learn.microsoft.com/en-us/sql/t-sql/language-elements/try-catch-transact-sql?view=sql-server-ver16

https://learn.microsoft.com/en-us/sql/relational-databases/stored-procedures/create-a-stored-procedure?view=sql-server-ver16