In this course, you will learn how to interact with databases using C# & ADO.NET
- 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.
- 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.