C# Console and Windows Forms Development with LINQ and ADO.NET

Video description

A one-stop resource to learn how to build a practical data-driven Windows Forms application using C#, LINQ, and SQL Server Express

About This Video

  • Become familiar with C#, Language Integrated Query (LINQ), ADO.NET, and SQL server concepts
  • Learn how to apply the principles of object-oriented programming in C#
  • Get ready to build and run amazing Windows Forms applications

In Detail

C#, the most versatile programming language in the .NET framework, allows developers to build Windows, web, and mobile applications. It has strong community support, and more than five million developers prefer C#. This course will teach you how to build a Windows Forms application using C#.

The course starts by highlighting the learning objectives and explains the installation process of Visual Studio 2019. Next, you will learn the basic and advanced concepts of C# console programming needed for application development. You will also understand how to use WinForms, ADO.Net, and Language Integrated Query (LINQ) to create WinForms applications. Moving along, you will learn to build data-driven GUI applications using Windows Forms and manage databases with SQL server management studio. Next, you will understand the concept of user management and learn how to use utility classes for keeping the code clean. Later, you will learn to develop multi-document interface (MDI) applications and learn the techniques to add a Visual Studio project to source control.

By the end of this course, you will have developed essential skills needed to build data-driven Windows Forms applications using C#, LINQ, and SQL server express.

Who this book is for

This beginner-friendly course is for anyone who wants to learn C# and wants to use LINQ and ADO.NET to develop real-world and Windows Forms applications.

Publisher resources

Download Example Code

Table of contents

  1. Chapter 1 : Introduction
    1. Course Overview
  2. Chapter 2 : Development Environment Setup
    1. Installing Visual Studio 2019 Community Edition
    2. Installing .NET Core Software Development Kit (SDK)
    3. Setting up a GitHub Account
    4. Tour of Visual Studio
  3. Chapter 3 : C# Console Programming - Basic Control Structures
    1. Writing a Simple Hello World Program
    2. Input and Output Programs
    3. C# Data Types and Conversion
    4. Operators in C#
    5. Conditional Statements
    6. Repetition Statements
    7. Methods and Return Types
  4. Chapter 4 : C# Console Programming - More Advanced Concepts
    1. String Manipulation Functions
    2. Handling Exceptions
    3. Classes and Objects
    4. Arrays, Lists, and Other Collections
  5. Chapter 5 : WinForms Applications - The Basics
    1. Creating a Simple WinForms Application (Car Rental Application)
    2. Understanding WinForms Controls, Properties, and Events
    3. Form Validation and Handling Exception
    4. Installing SQL Server Express Edition
    5. Creating a Database in an SQL Server
    6. Creating a Database Model with ADO.NET
    7. Selecting Data from the Database Using Language Integrated Query (LINQ)
    8. Submitting a Database Form
  6. Chapter 6 : Multi Document Interface (MDI) and More Database Operations
    1. Creating Additional Forms and Windows
    2. Creating an Multi Document Interface (MDI) Application
  7. Chapter 7 : Managing Database Changes and Create, Read, Update, Delete (CRUD) Operations
    1. Viewing Data in a Grid
    2. Managing Database Changes
    3. Creating and Editing Records (Using One Form)
    4. Vehicle Data Validations and Handling Exception
    5. Managing Car Rental Records
    6. Enhancing Application Flow and User Experience
  8. Chapter 8 : User Management and Login Functionality
    1. Creating a Simple Login Form
    2. Control Features Based on User Roles
    3. User Password and Active Status Reset
    4. Adding New Users and Resetting Password
  9. Chapter 9 : Adding to a Source Control
    1. Adding Project to GitHub

Product information

  • Title: C# Console and Windows Forms Development with LINQ and ADO.NET
  • Author(s): Trevoir Williams
  • Release date: December 2020
  • Publisher(s): Packt Publishing
  • ISBN: 9781801079792