ADO.NET

Content
People

Sort By Search Results

Real-World ADO.NET Use Cases: Case Studies and Best PracticesJul 24, 2024. ADO.NET remains a robust data access technology within the .NET framework, even as newer technologies emerge. Its ability to manage data interactions efficiently makes it suitable for a variety of real-world applications.
Handling Exceptions in ADO.NET Best Practices for Error Handling Jul 24, 2024. When working with ADO.NET for data access in .NET applications, effective exception handling is crucial to ensure the stability and reliability of your applications. This article will explore common exceptions in ADO.NET and provide best practices for robust error handling and logging.
Efficient Data Retrieval with ADO.NET SqlDataReader Jul 23, 2024. SqlDataReader in ADO.NET provides fast, forward-only data retrieval from SQL Server databases. It reads data as a stream, minimizing memory usage, and making it ideal for large datasets. Unlike SqlDataAdapter, it offers high performance for read-only scenarios and is efficient in handling big data with minimal overhead.
Advanced ADO.NET Features for Complex Data and Async OperationsJul 23, 2024. ADO.NET remains essential for database interactions in . NET. Advanced features include handling complex types with SQL Server's UDTs and XML data, managing binary data with VarBinary, and leveraging asynchronous operations for improved performance.
Understanding ADO.NET Data ProvidersJul 22, 2024. In the realm of .NET application development, ADO.NET (ActiveX Data Objects for .NET) serves as a bridge between your application and various data sources. A key component of ADO.NET is its data providers, which are specialized classes designed to interact with specific types of databases.
Setting Up Your First ADO.NET ProjectJul 22, 2024. ADO.NET is a set of classes that expose data access services for .NET Framework programmers. It provides a rich set of components for creating distributed, data-sharing applications. This guide will walk you through setting up your first ADO.NET project, connecting to a database, and executing simple queries.
Optimizing ADO.NET Code for Efficient Data Management StrategiesJan 12, 2024. In this article, we will learn about ADO.NET performance with strategic data retrieval techniques. Explore stored procedures, pagination, selective column retrieval, caching, batch processing, optimized data types, and connection pooling for efficient database interactions and responsive user experiences.
Benefits of using MongoDB with ADO.NET in ApplicationsAug 21, 2023. In this article, you will learn what are the benefits of using MongoDB with ADO.NET in applications.
Syncing Cache In ADO.NET Using NCache In .NET 6 With SQL ServerAug 23, 2022. In this article, you will learn about syncing Cache In ADO.NET Using NCache In .NET 6 With SQL Server.
Simple Insert And Select (CRUD) Operation Using .NET Core MVC With ADO.NET And Entity Framework CoreNov 28, 2020. Learn to perform basic CRUD operations in .NET Core MVC using both ADO.NET and Entity Framework Core. Build a robust data access layer for seamless integration with your web application.
Repository Pattern with ADO.Net in MVC Oct 30, 2019. This article will explain repository design pattern with ADO.Net in MVC from database without using entity framework.
How To Insert Data To Database Using Model In ASP.NET Core 2.1 MVC Using ADO.NET - Part OneJul 25, 2019. In this article, you will learn how to insert data into database using a model in ASP.NET Core 2.1 MVC using ADO.NET.
Entity Framework CRUD Operation Performed With SQL Stored Procedure Using ADO.NET Entity Data ModelJul 31, 2017. You can see my pervious article for Entity framework with Ado.Net data Model connection and how to create a new entity framework project and sql database connection maintained with created entity framework project. Also you can see how to create a class in entity framework based on data table.
Entity Framework With ADO.NET Entity Data ModelJul 28, 2017. In this article, we will learn how to use Entity Framework with ADO.NET Data Model in Visual Studio using C#.
Create an ADO.NET Data Base In Xamarin Android App Using Visual Studio 2015Nov 18, 2016. In this article, you will learn how to create an ADO.NET data base in Xamarin Android app, using Visual Studio 2015.
Data Access With ADO.NET In Micro Focus Visual COBOLJun 24, 2016. In this article, you will learn about data access with ADO.NET in Micro Focus Visual COBOL.
ASP.NET MVC 5: Integrating Existing Database With Login Using ADO.NET Database First ApproachMar 19, 2016. Learn how to integrate an existing database with login functionality in ASP.NET MVC 5 using the ADO.NET Database First approach. This guide covers setting up the Entity Framework, configuring the data access layer, implementing user authentication, and managing database connections for a seamless user experience.
WebAPI: Restful CRUD Operations in WebAPI Using ADO.NET Objects and SQL ServerFeb 16, 2016. Discover how to implement RESTful CRUD operations in WebAPI using ADO.NET and SQL Server. This guide covers setting up a WebAPI project, integrating ADO.NET for database connectivity, and performing Create, Read, Update, and Delete operations.
Connecting Databases Using ADO.NET In VB.NETJan 22, 2016. In this article you will learn how to connect databases using ADO.NET in VB.NET.
Implementing Repository Pattern And Dependency Injection In ADO.NET Using Generics In C#Dec 13, 2015. Learn how to implement design patterns in an object-oriented paradigm to create generic solutions. This guide covers a practical example where a web application interacts with a database using the repository pattern and dependency injection. It includes code snippets for a repository class, user repository, and service layer integration.
Important ADO.NET Interview QuestionsOct 24, 2015. In this article we will discuss about the most asked ADO.NET interview questions and answers.
Overview of ADO.NET ArchitectureFeb 25, 2015. In this article you will learn about the architecture of ADO.NET including the Connection, Command, Data Reader, DataAdapter and DataTable classes.
How to Connect ADO.NET Entity Framework With MVC in Simple StepsAug 04, 2014. This article shows how to work with MVC and the ADO.NET Entity Framework together.
Use ADO.NET Entity Data Model in ASP.Net ScaffoldingJan 17, 2014. This article describes how to use the ADO.NET Entity Data Model to generate the entity and use the context in ASP.NET Scaffolding.
Improve Performance and Scalability of ADO.NET CodeOct 22, 2013. This article expects that you have enough hands on experience in ADO.NET and good understanding of ADO.NET architecture.
Fetch, Insert, Update, Delete Data with “Database First Model Approach” using ADO.NET Entity Framework 3.5 and Visual Studio 2008.Jan 21, 2013. In this article you will learn how to Fetch, Insert, Update and Delete Data using the Database First Model Approach and the ADO.NET Entity Framework 3.5 and Visual Studio 2008.
Viewing and Writing XML Data using ADO.NET DataSets in VB.NETNov 10, 2012. This article presents step-by-step how to bind, read and view XML data and generate graphical reports with the build-in Crystal Reports engine. The article puts special emphasize on XML standardization and interoperability issues experienced during the project, and presents workarounds for existing limitations.
Introduction to ADO.NET Sync ServicesSep 21, 2012. This article, using a very basic example in VB .Net, shows how easily you can use ADO .Net Sync services in applications for occasionally-connected architectures.
Windows Azure - SQL Azure - Using ADO.NET Entity Framework - Data OperationsOct 23, 2011. In this article we are going to explore data operations using ADO.NET Entity Framework over our SQL Azure database.
Windows Azure - SQL Azure - Using ADO.NET Entity Framework - Creating DataModelOct 23, 2011. ADO.NET Entity Framework is an ORM (Object Relational Mapping) framework from Microsoft. In this article we have explored the scope of using ADO.NET Entity Framework on SQL Azure.
Generic Data Access Layer using ADO.NET Entity FrameworkSep 19, 2011. In this article, we will learn how to create a Generic data access layer with a WCF Layer. I use the Entity Framework to create a Data Model for our database.
Generic Data Access Layer using ADO.NET Entity Framework : Part 2Sep 19, 2011. In this article, we will take a deeper look at what the Entity Framework provides us and how we can modify it to achieve a Generic Data Access Layer.
Calling an stored procedure using ADO.NET Entity ModelApr 15, 2011.
Jump Start to ADO.Net Entity Framework Jan 20, 2011. Microsoft has introduced a framework for easy data abstraction called Entity Framework (AEF). AEF does wonders in support of LINQ to Entity and here in this post we will have a detailed demonstration.
Code Only Design using ADO.NET Entity Framework 4.0 Jul 21, 2010. This code snippet implements Code Only Design in ADO.NET Entity Framework 4.0, connecting to a SQL Server database, configuring entities, and binding data to a GridView with exception handling.
Model-First Design using ADO.NET Entity Framework 4.0 Jul 19, 2010. In this article we are going to see the second most importment part of the ADO.NET entity framework 4.0.
Silverlight RIA Service using ADO.NET Entity Data Model: Part IIJun 03, 2010. This article demonstrates how to use RIA services with ADO.NET Entity Data Model and how to use page navigation in Silverlight.
Working with Oracle Databases using ADO.NET Mar 23, 2010.
Accessing Excel Databases using ADO.NET Mar 23, 2010. In this article I will explain about Accessing Excel Databases using ADO.NET.
Working with Sybase Databases using ADO.NET Mar 21, 2010. In this article I will explain about working with Sybase Databases using ADO.NET.
Accessing a Text File using ADO.NET Mar 19, 2010. In this article I will explain about Accessing a Text File using ADO.NET.
Accessing Text File Databases in ADO.NET Mar 18, 2010. In this article I will explain about Accessing Text File Databases in ADO.NET.
The ODBC.NET Data Provider in ADO.NET Mar 17, 2010. In this article I will explain about the ODBC.NET Data Provider in ADO.NET.
Using ADOX with ADO.NET Mar 11, 2010. In this article I will explain using ADOX with ADO.NET.
Using the ADO Recordset in ADO.NET Mar 08, 2010. In this article I will explain Creating Your First ADO.NET Web Application.
Working with DataView and DataViewManager Events in ADO.NET Mar 02, 2010. In this article I will explain working with DataView and DataViewManager Events in ADO.NET.
Working with XmlDataDocument Events in ADO.NET Mar 01, 2010. In this article I will explain working with XmlDataDocument Events in ADO.NET.
Working with DataTable Events in ADO.NET Feb 25, 2010. In this article I will explain working with DataTable Events in ADO.NET.
ADO.NET Data Model and ADO.NET Data Service in Silverlight 3Feb 17, 2010. In this article we would see how we can use ADO.NET Entity Data Model as the ORM in Silverlight 3 Application, and ADO.NET Data Service to fetch the data.
Adding Editor, and Deleting data in Web Forms using ADO.NET Feb 11, 2010. In this article I will explain Adding Editor, and Deleting data in Web Forms using ADO.NET.
Web Services with ADO.NET Feb 09, 2010. In this article I will explain Web Services with ADO.NET.
Paging in DataGrid Control using ADO.NET Feb 02, 2010. In this article I will explain Paging in DataGrid Control in using ADO.NET.
Create a Data Adapter in ADO.NET Jan 28, 2010. In this article I will explain how to Create a Data Adapter in ADO.NET.
Viewing Data in a DataGrid Control in ADO.NET Jan 25, 2010. In this article I will explain Viewing Data in a DataGrid Control in ADO.NET.
Creating Your First ADO.NET Web ApplicationJan 21, 2010. In this article I will explain Creating Your First ADO.NET Web Application.
Using ADO.NET Data ProvidersDec 18, 2009. In this article I will explain about using ADO.NET Data Providers.
Adding Typed DataSets in ADO.NET Dec 13, 2009. In this article I will explain about Adding Typed DataSets in ADO.NET.
Using ADO.NET Entity Data Model in WPFNov 06, 2009. This article will show you how to fetch and show data from database using ADO.NET Entity Data Model in WPF.
Simple ADO.NET program with Visual Studio .NET IDEOct 12, 2009. In this article I will explain about a simple ADO.NET program with VS using windows forms.
Building ASP.NET MVC Web Applications using ADO.NET Entity Data ModelOct 09, 2009. This is a step by step tutorial on how to build ASP.NET MVC Web Applications using ADO.NET Entity Data Model and Visual Studio.
Understanding ADO.NET ComponentsOct 07, 2009. In this article I will explain about ADO.NET Components.
Writing ADO.NET ApplicationsOct 07, 2009. In this article I will explain you basic steps required to write an ADO.NET Application.
Overview of ADO.NET Namespaces and ClassesOct 06, 2009. In this article I will explain about ADO.NET namespaces and classes.
Inserting records in a database using stored procedure and ADO.NET technologyAug 13, 2009. In this article I will explain you how to use CommandType stored procedure to insert records in a database in a disconnected manner.
Rows.Count, Column.Count and IEnumerator using ADO.NET with C# and Database ServerJul 29, 2009. In this article I will explain you how to make a SQL database connection and show information in data grid. Count the number of rows and columns in the table and show the records in text boxes using IEnumerator interface.
Silverlight 2 Web Service Part IV - Making database calls through a ADO.NET Data ServiceJun 10, 2009. This tutorial is meant to shed some light upon how you can call a database from a ADO.NET Data Service. This is the fourth turtorial in a series of tutorials on how to access remote data with a Service. In this tutorial we will read, insert, update and delete data in an SQL Server database. The data is displayed ad edited in a DataGrid control but can easily be modified to work for other types of controls.
Getting started with ADO.NET Entity Framework in .NET 3.5 - Part IIIOct 13, 2008. This article show us how to do conditional query and paging in ADO.NET Entity Framework.
Getting started with ADO.NET Entity Framework in .NET 3.5 - Part IIOct 06, 2008. This article contains a very simple ADO.NET Entity Framework application to update and delete the data to the database using ADO Entity Framework.
Getting started with ADO.NET Entity Framework in .NET 3.5Sep 30, 2008. This article contains a very simple ADO.NET Entity Framework application to display and add the data to the database using ADO Entity Framework.
Building and consuming parameterized queries from ADO.Net to DLINQAug 29, 2008. In this article, I will represent different techniques to build and make use of parameterized queries. The first way is the classical one, and I mean by that the ADO.Net technique. Then I’ll expose the second one using the new technology, namely DLINQ.
Silverlight 2 use ADO.NET Data Services to access dataJul 19, 2008. In this article will show how to perform CRUD (Create, Retrieve, Update, Delete) operations in Silverlight 2 using ADO.NET Data Services.
Using ADO.NET concurrent model in Oracle databaseDec 07, 2006. The most popular instrument to access database data for .NET applications is ADO.NET. This set of components contains three main classes those are used to manipulate and store data: DataReader, DataSet and DataAdapter.
Bulk Copy Operations in ADO.NET 2.0Oct 23, 2006. Bulk copying of data from one data source to another data source is a new feature added to ADO.NET 2.0. Bulk copy classes provides the fastest way to transfer set of data from once source to the other.
Maintaining Transactions in Enterprise applications using ADO.NET Transactions Aug 07, 2006. This article explains usage of System.Transactions to update tables of two different databases with two different data providers (SqlClient and OleDB) in Atomic(ACID) way.
Managing Distributed Transactions with ADO.NET 2.0 using TransactionScopeApr 15, 2006. This article describes how to manage distributed transactions that can span multiple data sources in a Microsoft .NET application.
Abstract Factory Design Pattern in ADO.NET 2.0Feb 17, 2006. This article will discuss the Abstract Factory Design Pattern and its real-world applications in .Net Framework 2.0.
Reincarnation of DataTable in ADO.NET 2.0Jan 09, 2006. The DataTable in ADO.NET 2.0 is a much improved and powerful than previous versions of ADO.NET. In this article, I will talk about new improvements and features added to the DataTable and how to use them in your applications.
Building Generic Data Access Class using ADO.Net 2.0Jan 03, 2006. In this article we are going to explore some new features of the generic data access supported by ADO.Net 2, and also we will have a look at generic collections and generic interfaces.
New Dataset Features In ADO.Net 2.0Aug 22, 2005. ADO.NET class libraries are used for accessing data from a wide range of data sources. One of the best features in ADO.Net is DataSet.Even though it was an exciting feature, performance was a concern with DataSet. Lets look some changes made to DataSet in ADO.Net in this article.
Top 10 New Features in ADO.NET 2.0Aug 19, 2005. This article summarizes the new and updated features of ADO.NET 2.0, which ships with .NET Framework 2.0. In my following articles I will discuss these features in more details with sample examples.
Introduction to ADO.NET 2.0 Data Source ControlsAug 19, 2005. ADO.NET 2.0 provides new data source and data-bound server controls, which allow developers to write full-fledged data-driven applications without writing even a single line of code. This article is an introduction to these new data source controls.
Getting Data Providers Details in ADO.NET 2.0Aug 19, 2005. In ADO.NET 2.0, there is a new addition of DB provider factory classes, which allow developers to get the information about the data providers available (installed) on a machine.
Working with ADO.NET 2.0 XMLDataSource ControlAug 19, 2005. XML Data Source (XmlDataSource) control is a new control added to ADO.NET data source controls available in ASP.NET 2.0. In this article, I will discuss how to create and use XmlDataSource control in your Web applications.
Understanding ADO.Net Provider Factory in .Net 2.0Aug 08, 2005. This article describes the ADO.NET Provider Factory in .NET 2.0
How to Insert a Date Into DateTime Column Using ADO.NET & C#Feb 04, 2005. In this article, we will show how to insert a date into a date column using ADO.NET and C#.
Retrieving Schema Information Using ADO.NET and C#Jul 06, 2004. In this article, I will describe the ways to retrieve the database schema information using System.Data.SqlClient class and the System.Data.OleDb class.
Using OLEDB in ADO.NET with COBOLApr 16, 2003. The SqlClient class was created by Microsoft and is used primarily to access a SQL Server database.
Concurrency Control in ADO.NET using Threads and MonitorsDec 31, 2002. The concurrency controls system refers to the lowest level in architecture of a DBMS. It is relative to the input/output operations, which carry out the transfer of blocks from the secondary memory to the main memory and vice versa.
Viewing and Writing XML Data using ADO.NET DataSetsNov 01, 2002. Based on a real world project this article shows how to handle XML data in .NET using C# DataSets and DataViews.
Connecting to a Text file using ADO.NET Apr 20, 2001. A simple step by step tutorial shows you how to connect to a text file using ADO.NET and C#..
ADO Vs ADO.NET Web ServiceMar 22, 2001. In this example I'd like to demonstrate one of the most interesting features of the .NET runtime - the concept of Webservices.
ADO.NET vs Entity Framework: Understanding the DifferencesFeb 03, 2025. This article compares ADO.NET and Entity Framework (EF), two popular data access technologies in .NET. It explores their differences in performance, data manipulation, and development approaches like code-first vs database-first, helping developers choose the right tool for their application needs.
Security Best Practices in ADO.NETJul 23, 2024. ADO.NET is a powerful data access technology in the .NET framework, enabling developers to interact with databases. This article explores best practices for protecting sensitive data, preventing SQL injection, implementing secure authentication and authorization, and securing database connections.
LINQ to ADO.NET: Enhancing Data Access with Modern QueryingJul 23, 2024. In the evolving world of .NET, querying databases has traditionally been done using ADO.NET, which provides a robust set of classes for data access. However, the introduction of Language Integrated Query (LINQ) has revolutionized the way developers interact with data.
Transactions in ADO.NET: Ensuring Data IntegrityJul 23, 2024. In database management, transactions are essential to ensure data integrity and consistency. A transaction is a sequence of operations performed as a single logical unit of work
Performance Optimization in ADO.NET: Tips and TechniquesJul 23, 2024. Optimize ADO.NET performance by leveraging connection pooling to reduce overhead, using efficient command execution strategies such as stored procedures and batch processing, and retrieving data effectively by selecting only necessary columns and implementing paging.
Getting Started with ADO.NETJul 22, 2024. ADO.NET (ActiveX Data Objects . NET) is a set of classes in the .NET Framework that provides access to data sources such as SQL Server, Oracle, and other databases. It is a part of the larger .NET ecosystem, enabling developers to interact with data in a structured and efficient manner.
Working with Stored Procedures in ADO.NETJul 22, 2024. Stored procedures are a powerful feature in database management systems that allow you to encapsulate complex logic and operations on the server side. When using ADO.NET in a .NET application, stored procedures can be leveraged to interact with the database efficiently.
Executing Commands with ADO.NETJul 22, 2024. Explore how to use ADO.NET’s SqlCommand class for executing SQL queries and stored procedures in .NET applications. This guide covers setting up SqlConnection, using methods like ExecuteNonQuery, ExecuteScalar, and ExecuteReader, and preventing SQL injection with parameterized queries.
Working with Connection Objects in ADO.NETJul 22, 2024. ADO.NET is a set of classes that expose data access services for .NET Framework programmers. A primary feature of ADO.NET is the ability to work with disconnected data. However, working directly with databases is often necessary, and this is where connection objects come into play.

1 - 100 of 255

OUR TRAINING