In this course, you will learn how to interact with databases using C# & ADO.NET

Prerequisites:

• You should have completed C# Course
• You should have basic understanding of Databases & Query Writing
• You should have Passion of Learning

Expected Time to Complete: 62 mins

Source Code is available here on github

1- Introduction to ADO.NET

We started with .NET Framework video series. Then we learned basic concepts of OOP in C#. Then we saw how we can develop windows based applications in .NET using C#.

Almost every application needs interaction with some database. .NET framework provides us “ADO.NET” technology for communication with databases. In this video series, we’ll explore basics of ADO.NET with some examples.

2- Starting With ADO.NET + SQL Server

In this video, we’ll quickly check assemblies, classes involved in ADO.NET.

3- Reading Data in ADO.NET

In this video, we’ll learn how we can read data from SQL server using

4- How to Save Update Delete

5- DTO Class, How to get Auto Generated Value/DTO Pattern

6- Parameterized Query and Executing Stored Procedures

In this video, we’ll learn what are paramterized queries. It is always better approach to use “paramterized” query instead of “concatenation” approach. We’ll also learn how to execute stored procedure using ADO.NET code.

7- Example with 3-Layer Architecture

In this video, we’ll learn how to implement n-layer architecture in .NET using an example. We’ll also learn about some common fields we should have in our tables. We’ll also see what is DTO pattern. We’ll also learn about Dispose pattern. What is opening connection in “using” block. We’ll also learn about ConfigurationManager class.

Optional: You may come later & learn these.

Prerequisites:

• You should have completed Windows Application Development Course
• You should have basic idea of MySQL

Expected Time to Complete: 40 mins

1- Disconnected ADO.NET Playing with DataTable

2- DataTable, DataGridView, RowState

3- SqlDataAdapter Example

4- Using LocalDB with Windows Forms

Microsoft SQL Server LocalDB is a smaller & Free version of SQL Server. You can download and install it separately for smaller projects. When you install latest version of Visual Studio, it is also installed with it.

5- Playing with MySQL in C#

6- Databases – Transactions ACID properties Isolation Levels