-
Delve into the advanced concepts of SQL and C#
-
Identify the best situation to use SQL views, SQL stored procedures, and SQL user-defined data type
-
Enable smooth communication between C# code and SQL server
C# is the backbone of many popular video games, web, mobile, and desktop applications. And without SQL, the creation and management of the database will be handicapped. Imagine what can be achieved in the world of technology if both C# and SQL are merged! This video course will teach you how to bring C# and SQL together to build robust, powerful, real-world applications.
The course begins with an overview of the course objectives and explains the process of installing Visual Studio 2019, SQL Server 2019, and SSMS 18. Next, you will create a customer order viewer application in C# to understand the SQL commands, tables, database, and server in detail. Moving ahead, you will use SQL Alter, user-defined data types, stored procedures, and Dapper, to enhance the application that you created.
You will also test the application to ensure that it is working smoothly as per the requirement. Toward the end, you will create a course report emailer application in C# to email worksheets with SQL data and build WPF forms and use Dapper to make the communication between C# code and SQL server seamless.
By the end of this course, you will have developed essential C# and SQL skills needed to build real world applications.
All the code and supporting files for this course are available on GitHub at: https://github.com/PacktPublishing/Master-C-Sharp-And-SQL-By-Building-Applications
If you are a software developer who is looking to use C# and SQL together to build powerful applications, then this video course is for you. To get started with this course, it is recommended to have a basic understanding of C# and SQL server.
-
Build a full-stack application with C# and SQL
-
Use Dapper in .NET to make SQL database access even easier
-
Create forms using WPF and XAML
-
Create and manipulate Excel workbooks through Open XML and C#
-
Send emails programmatically using SmtpClient in C#
-
Find out how to use the SQL Merge statement