Resources No resource found - 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. This article is for the developer who is looking to learn .NET Core MVC with ADO.NET for their project.
- 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. In this article you will learn how to integrate existing databases with login using ADO.NET Database First Approach in ASP.NET MVC 5.
- WebAPI: Restful CRUD Operations in WebAPI Using ADO.NET Objects and SQL ServerFeb 16, 2016. In this article, I will share my thoughts of how to implement Restful operations in the WebAPI using ADO.Net objects and SQL Server.
- 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. In this article you will learn about implementing Repository pattern and Dependency Injection in ADO.NET using Generics in C#.
- 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 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.
- 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.
- 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.
- Writing ADO.NET ApplicationsOct 07, 2009. In this article I will explain you basic steps required to write an ADO.NET Application.
- Understanding ADO.NET ComponentsOct 07, 2009. In this article I will explain about ADO.NET Components.
- 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.
- JWT Authentication Using Refresh Token Series - 1 [Login Feature] In .NET Core 6.0-ADO.NET-SQLJan 10, 2024. In this series of articles, we'll focus on a hands-on, practical implementation of JWT authentication with refresh tokens in .NET Core 6.0 using ADO.NET and SQL, emphasizing real-world scenarios and code examples for a deeper understanding of the underlying concepts.
- Mastering PostgreSQL CRUD Operations in .NET 8 with ADO.NETJan 01, 2024. Mastering PostgreSQL CRUD Operations in .NET 8 with ADO.NET: Best Practices and Code Examples
- Dapper vs Entity Framework Core vs ADO.NET: Which One Should You Choose?Apr 19, 2023. Dapper vs Entity Framework Core vs ADO.NET: Which One Should You Choose?
- Create Database Connection Using ADO.NETOct 21, 2022. In this article, you will learn how to create Database Connection using ADO.NET - C#.
- DataTable And DataTableCollection Class In ADO.NETMar 17, 2021. In this article, you will learn about DataTable and DataTableCollection Class in ADO.NET.
- Properties, Methods And Events Of DataSet Class In ADO.NETMar 11, 2021. In this article, you will learn Properties, Methods and Events of DataSet Class in ADO.NET
- Data Classes On ADO.NETMar 10, 2021. In this article, you will learn about Data Classes on ADO.NET.
- Role Of ADO.NETMar 08, 2021. In this article, you will learn about role of ADO.NET.
- Database Operations in ASP.NET Core Web API Using ADO.NETApr 09, 2020. In this article, you will perform database operations in ASP.NET Core Web API using ADO.NET.
- Combine ADO.NET, EF Core And Dapper In Same Blazor App Nov 22, 2019. In this post, we will see how to use ADO.NET, EF Core and Dapper in same Blazor app to connect with SQL server database.
- Create Update Read Delete Operation In MVC With ADO.NETOct 04, 2019. In this article, you will learn how to perform create, update, read, and delete operations in MVC with ADO.NET.
- Creating A .NET Core 2.1 Class Library Project Using ADO.NETSep 04, 2019. In this article, you will learn how to create a .NET Core 2.1 class library project using ADO.NET.
- CRUD Operation With ASP.NET Core 2.1 MVC Using ADO.NETAug 06, 2019. In this article you will learn about CRUD Operation with ASP.NET Core 2.1 MVC using ADO.NET.
- CRUD Operations Using ASP.NET Core And ADO.NETFeb 20, 2019. In this article, we will be creating a simple student record management system and performing CRUD operations on it.
- CRUD Operation In ASP.NET Core 2.0 With Razor Pages Using ADO.NETJul 30, 2018. In this article, we will learn CRUD Operation In ASP.NET Core 2.0 With Razor Pages Using ADO.NET Step by Step.