C# ADO.NET Database Programming

To develop an actual DB linkage program
You will learn advanced ADO.NET techniques.

Database Programming with C#

This course provides comprehensive information necessary for those who are actually working on a program or have completed a prerequisite course to develop a database-linked program. Since it is explained while developing an actual project, beginners can learn a lot of advanced techniques in a short period of time. Of course, there may be parts that you do not understand, but if you ask questions using the lecture Q&A bulletin board, I will answer them sincerely.

The main content of the course is ADO.NET. Also, database design, writing stored procedures, etc. are all included in the course. And the part of using ADO.NET in C# program to connect to the database server, and the development of the database connection library that we will use are also included. WinForms were adopted because we need to check the development results, so we do not cover WinForms program from the beginning to the end.

📕 Course Introduction

This is for those who have taken or are familiar with database SQL, database design, and C# programming basics. Since the lectures mentioned above only explain their respective fields, it will be necessary to have an opportunity to cover the entirety of how the database works, how SQL is created, how it is expressed in the program, and how the program communicates with the database server. Therefore, this project is structured in a way that you select a practical project and develop it yourself. However, due to time constraints, I will not explain the basic contents in detail. Please refer to the basic prerequisite course for these contents.

📚 Past lectures

C# Programming Fundamentals
Tips for writing practical programs

Database - SQL
Learning DB from scratch

RDBMS Modeling
Understanding relational DB concepts

🙌 Tools covered here

• VisualStudio 2017 or VisualStudio 2019
• Microsoft SQL Server 2017

🙋🏻‍♂️ Expected questions related to the lecture

Q. Can non-majors also take the course?
A. Anyone who understands the subject can listen to it sufficiently.

Q. Why should I learn ADO.NET?
A. ADO.NET is a framework for database connection. These days, there are almost no programs that do not handle databases. It is therefore essential. ADO.NET provides a standard interface that connects to all types of databases, not just SQL Server, so it has a wide range of uses.

Q. Please tell us what prompted you to start this course.
A. This course is a continuation of the database-related courses and the basics of C# programming that have been offered so far. We plan to continue developing necessary courses related to C# in a series format in the future.