My Wish Lists Login / Join

Master C# and SQL by Building Applications

By: Programming Resources

Write A Review

eText | 19 October 2020 | Edition Number 1

At a Glance

Format
PDF

eText

$221.09

or 4 interest-free payments of $55.27 with

Instant online reading in your Booktopia eTextbook Library *

Why choose an eTextbook?

Instant Access *

Purchase and read your book immediately

Read Aloud

Listen and follow along as Bookshelf reads to you

Study Tools

Built-in study tools like highlights and more

* eTextbooks are not downloadable to your eReader or an app and can be accessed via web browsers only. You must be connected to the internet and have no technical issues with your device or browser that could prevent the eTextbook from operating.

Take your software development skills to the next level by leveraging the collective power of C# and SQL together to build real-world applications

Key Features

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

Book Description

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

What you will learn

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

Who this book is for

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.