CSIS 123 - Cryptography and Dapper with SQL Server

5 Credits
This code-focused course will show students how to implement Micro ORM data access layer by using Dapper with SQL Server. The student will learn the basics of Dapper including how to implement the Create, Read, Update, and Delete operations, as well as learn how to communicate stored procedures from Dapper. Meanwhile, the student will learn the cryptographic systems and the process of hashing a password with salt by using C# while using the Dapper with SQL Server to store, modify, and verify the password.

Course Outcomes

Use appsettings.json within console app and WebAPI.
Use Data Definition Language Statements to perform the basic table creation.
Use Data Manipulation Language statements to Insert, Update, and Delete.
Use Stored Procedures from Dapper in C#.
Learn how the Cyber Security in C# with Dapper and SQL Server.
Hash a password with Salt by using RandomNumberGenerator() in C#.