Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Deep-Dive into Database Programming using ADO .Net in C#
Rating: 2.7 out of 5(3 ratings)
1,043 students

Deep-Dive into Database Programming using ADO .Net in C#

ADPDOTNET
Created bySandeep Soni
Last updated 2/2026
English

What you'll learn

  • Core ADOdotNET Concepts and Architecture
  • Data Manipulation and CRUD Operations
  • Retrieving Data, Inserting Data, Updating Data, Deleting Data
  • Working with XML Data

Course content

2 sections • 24 lectures • 10h 23m total length

  • ADO.NET Evolution And Role Of Managed Providers35:58
  • Quiz
  • Installing SQL Server And Management Studio8:05
  • Quiz
  • Establishing Connection With Database And Connection Pooling41:29
  • Quiz
  • Executing Insert, Update And Delete Commands31:25

    Explore executing insert, update, and delete statements using the SqlCommand object, choosing execute non query, execute scalar, and execute reader, while managing connections and identity retrieval on the same connection.

  • Quiz
  • Fetching Data Using Select Command25:18
  • Quiz
  • How to Implement Login in Application16:40
  • Quiz
  • Multiple Active Result sets17:07
  • Quiz
  • Parameterialized Prepared Statements47:13
  • Quiz
  • Executing Stored Procedures31:56
  • Managing Database Transaction And DTC38:19
  • Asynchronous Execution Of SQL Commands20:41

    Learn how to implement asynchronous execution of SQL commands in C# with ado .net, replacing synchronous patterns using begin/end methods and async/await to keep the UI responsive.

  • Writing Managed Provider Independent Code18:50
  • Writing Utility Class With Common Code15:32
  • Summary And API Used12:24

    summarizes database programming with ado .net in c#, covering parameterized sql, crud via command objects, stored procedures, provider independent code, and transactions with transaction scope.

Requirements

  • Proficiency in ADONET: Students will gain a strong understanding of ADONET concepts and its role in database programming.
  • Hands-on Experience: Develop practical skills in connecting to databases, executing queries, and manipulating data using C#

Description

(ActiveX Data Objects for .NET) is a data access technology built into the .NET Framework that allows you to connect to various data sources, retrieve and manipulate data, and perform operations like reading, updating, inserting, and deleting records.

Key Components and Concepts:

  • Data Providers: Specialized classes that act as bridges between your C# code and specific data sources, such as SQL Server, Oracle, MySQL, or XML files.

  • Connections: Represent a communication channel between your application and the data source, enabling you to send commands and receive results.

  • Command Objects: Encapsulate SQL statements or stored procedures to be executed against the database.

  • Data Readers: Forward-only, read-only streams of data retrieved from a database, efficient for fast retrieval and processing.

  • Data Adapters: Bridge between a DataSet and a data source, used to fill a DataSet with data and reconcile changes back to the database.

  • DataSets: In-memory, disconnected representations of data, allowing for offline manipulation and data binding to UI elements.

Common Tasks Using  in C#:

  1. Connecting to a Data Source:

    • Specifying connection string details (provider name, server, database name, authentication credentials).

  2. Executing Commands:

    • Using command objects to perform SQL queries, stored procedures, or other database operations.

  3. Retrieving Data:

    • Fetching data using data readers or filling DataSets for further manipulation.

  4. Manipulating Data:

    • Updating, inserting, or deleting records within DataSets or directly through commands.

  5. Managing Transactions:

    • Ensuring data consistency and integrity by grouping operations into logical units.

Benefits of :

  • Unified Data Access Model: Consistent programming model across various data sources.

  • Disconnected Data Handling: Enables offline data manipulation and enhances scalability.

  • Strong Performance: Optimized for efficient data access and manipulation.

  • Integrated with .NET Framework: Seamlessly integrates with other .NET technologies.

Who this course is for:

  • C# Developers
  • Backend Developers
  • Database Analysts
  • Computer Science Students

Report abuse