Resources   No resource found

• Database Connection Pooling Explained with ExamplesJun 03, 2026. Learn Database Connection Pooling with practical examples. Understand how connection pools improve performance, scalability, and database efficiency.
• Choosing Your Data Access Strategy in .NET: ADO.NET vs. Dapper vs. Entity FrameworkMar 05, 2026. Unlock optimal .NET data access! Compare ADO.NET, Dapper, and Entity Framework Core for performance, productivity, and control. Choose the right tool for the job!
• Choosing Your Data Access Strategy in .NET: ADO.NET vs. Dapper vs. Entity FrameworkFeb 27, 2026. Unlock peak .NET data access! Compare ADO.NET, Dapper, and Entity Framework Core for Oracle. Maximize performance, productivity, and control. Choose the right tool!
• Different Types of Database Providers in ASP.NET CoreFeb 27, 2026. Explore the different types of database providers in ASP.NET Core including EF Core, SQL Server, PostgreSQL, MySQL, SQLite, MongoDB, Cosmos DB, Dapper, and ADO.NET. Learn how to choose the right provider with real-world coding examples and best practices for scalable, high-performance applications.
• Dealing with DB Null: Solving the Object cannot be cast from DB Null to other types Error in C#Feb 23, 2026. Safely handle DBNull values in C# when querying databases like Oracle or SQL Server. Prevent InvalidCastExceptions with practical examples and extension methods.
• How Does ADO.NET Work with SQL Server?Feb 16, 2026. Explore how ADO.NET interacts with SQL Server for efficient data access in .NET applications. Learn about its architecture, components, and relevance in 2026 for enterprise software development. Discover connection strategies, command execution, and transaction management.
• Blazor with PostgreSQL using ADO.NET (Enterprise-Ready Guide)Feb 05, 2026. Connect Blazor apps (Server/WebAssembly) to PostgreSQL using ADO.NET (Npgsql). Ideal for high-performance, enterprise systems needing full SQL control and stored procedures.
• How Do I Return the ID of a Newly-Inserted Row in Access SQL?Jan 14, 2026. Learn how to retrieve the auto-generated ID of a newly inserted row in Access SQL! Explore methods like @@IDENTITY, DAO, and ADO with practical examples and VBA code.
• Bind Dropdown with jQuery AJAX & WebMethod in ASP.NETAug 01, 2025. This ASP.NET WebMethod fetches unique applicant names and their UCC IDs from a SQL database and returns them as a list of ListItem objects, ideal for populating dropdowns via AJAX in web forms.
• Mastering Connection Pooling with Dapper in ASP.NET Core Web APIJun 27, 2025. In modern web development, one of the key challenges when working with databases is efficiently managing database connections.
• Advanced C# Database Tricks into a Practical SolutionMay 02, 2025. This project demonstrates an advanced C# database architecture combining EF Core, Dapper, and ADO.NET to achieve optimal performance, flexibility, and maintainability—complete with clean architecture, logging, and benchmarks.
• Mitigate OWASP A02 2021-Cryptographic Failures Web Security TipsFeb 04, 2025. ADO.NET offers low-level access to databases using SQL commands, while EF is an Object-Relational Mapping (ORM) tool that simplifies database operations by mapping objects to database tables, offering higher-level abstractions.
• 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.
• Modern ADO .Net with SQLite in VB and C#Jan 22, 2025. This article demonstrates how to connect SQLite with ADO .NET in C# and VB, showcasing database operations such as creating tables, inserting records, and reading data. It uses the Microsoft.Data.Sqlite package in .NET Core environments.
• Learn to Shrink a Microsoft SQL Server Database Programatically Aug 20, 2024. Shrinking a SQL Server database reduces file size by reclaiming unused space in data and log files. This can optimize disk usage, especially in storage-constrained environments. However, it can cause data fragmentation and impact performance. Use commands like DBCC SHRINKDATABASE cautiously in C#.
• 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.
• 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.
• 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.
• 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
• 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.
• 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.
• 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.
• 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 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.
• 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.
• 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.
• 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.
• 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.
• Using DataAdapters and DataSets in .NETJul 22, 2024. In .NET, working with databases often involves handling disconnected data scenarios where data is fetched, manipulated, and then updated back to the database. Two essential components for managing such scenarios are DataAdapter and DataSet.
• Integrating an Online Payment Gateway in ASP.NET using ADO.NETJul 10, 2024. Integrating an online payment gateway in ASP.NET using ADO.NET involves setting up a payment gateway account, creating an HTML form to collect payment details, redirecting to the payment gateway for processing, handling the payment response, and updating the database. Ensure security, validate responses, and test thoroughly.
• How To Connect Database in ASP.NET MVC using C# with ADO.NETJun 17, 2024. Learn how to integrate SQL Server with your MVC application, configure connection strings, and perform CRUD operations. Ideal for developers seeking to enhance their data access techniques in ASP.NET.
• Dynamic Mapping Database result to Entity TMay 20, 2024. This article provides logic for Mapping the SQL Result to C# Class. This code snippet demonstrates the dynamic mapping of SQL result columns to C# properties, converting SNAKE_CASE SQL column names to PascalCase C# properties using MapToList for DbDataReader to object mapping.
• Difference between ADO.NET, ORM and DapperMay 20, 2024. This article explores ADO.NET, ORM, and Dapper in the .NET ecosystem, detailing their history, evolution, and best practices and providing C# code examples for effective data access management.
• Database Connectivity in Visual Studio May 03, 2024. Visual Studio facilitates robust database connectivity through technologies like ADO.NET and Entity Framework. Developers can seamlessly integrate with SQL Server, MySQL, Oracle, and more using connection strings and data source management tools.
• Becoming Proficient in C# and ASP.NET: A Roadmap to MasteryApr 08, 2024. From traditional ASP.NET Web Forms to the sleek ASP.NET MVC, and from robust backend solutions using ADO.NET and SQL Server to dynamic front-end interactions with jQuery, AJAX, and more, developers have a plethora of tools at their disposal to create powerful web experiences.
• Seamless Database Integration with C#Mar 26, 2024. Efficiently integrating databases with C# applications is crucial for managing data seamlessly. Explore various approaches like ADO.NET, Entity Framework Core, and Dapper along with best practices for successful integration.
• 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.
• 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
• 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.
• A Comprehensive Guide to .NET Development for BeginnersJun 12, 2023. Discover the essentials of .NET development in this comprehensive guide. Learn about the .NET Framework, C# programming, ASP.NET web development, ADO.NET for databases, building desktop applications, and the innovative ASP.NET Core. Ideal for beginners looking to start their journey in .NET development.
• 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#.
• 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.
• Implement In-Memory Cache In The .NET Core APIJun 20, 2022. In this article, you will learn how to implement In-Memory Cache in the NET Core API.
• Scanning Markdown Files For Stylistic ErrorsNov 15, 2021. In this article, you will learn about scanning Markdown files for stylistic errors.
• WCF (4), RIA ServicesApr 14, 2021. This discuss a WCF related service, RIA service.
• 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.
• How To Create Web Service In ASP.NET Web Forms With ExampleJan 13, 2021. This article gives an explanation about how to create web service in asp.net web forms and return the response in JSON and XML formate. Here I also explain how to retrieve data from the SQL server database using web service as well as also show you how you can retrieve data from the SQL server database.
• 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.
• CRUD Operation In C# Windows Application Using Store ProcedureNov 16, 2020. This guide explores implementing CRUD operations in a C# Windows Forms application using stored procedures. Learn to connect to SQL Server, execute stored procedures, and handle data efficiently.
• Client-Server WASM-Application In C#, TypeScript And Transact-SQLJul 21, 2020. In this article, we describe a Blazor-WASM sample application. Although the article is associated with Web-development, it is not about the classical web. It is related to general Client-Server programming in conventional languages but in connection with existing Web-reality to which some experimental things are applied.
• Simple CRUD Operation In ASP.NET MVC Jun 16, 2020. In this article, we will see how to perform a CRUD Operation in ASP.NET MVC using the ADO.NET Entity Model. For this project, I am using MS SQL Server Database and Visual Studio 2013.
• Filter Records By Passing Multiple Parameters In Stored Procedure Using MVCMay 27, 2020. Here we can filter records using by passing various input parameters to stored procedure and Dynamic Sql in MVC.
• 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. Discover the power of combining ADO.NET, EF Core, and Dapper within a single Blazor application. Seamlessly integrate these data access technologies to leverage the strengths of each, enhancing performance, flexibility, and scalability.
• 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.
• 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.
• All The Steps For Query Execution In Entity FrameworkMay 13, 2019. In this article, we will be exploring the life cycle of query execution in Entity Framework.
• Introducing SQL+ .NETMar 23, 2019. SQL with .NET is a new approach to database development in the service layer. Let's get acquainted with it.
• 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.
• CRUD Operations In ASP.NET Core Web API Using ADO.NETJun 29, 2018. In today’s article, we will see how to perform simple CRUD operations in ASP.NET Core Web API using ADO.NET.
• CRUD Operations With ASP.NET Core Using Angular 5 And ADO.NETJan 02, 2018. Here, I am going to explain how to create an MVC web application in ASP.NET Core 2.0 with Angular 5.
• CRUD Operation With ASP.NET Core MVC Using Visual Studio Code And ADO.NETNov 23, 2017. In this article we are going to create a web application using ASP Core MVC with the help of Visual Studio Code and ADO.NET.
• CRUD Operation With ASP.NET Core MVC Web App Using ADO.NETOct 05, 2017. In this article, I am going to explain how to create a MVC web application in ASP.NET Core 2.0 using ADO.NET.
• Razor Page Web Application With ASP.NET Core Using ADO.NETOct 03, 2017. In this article, I am going to explain how to create a web application in ASP.NET core using Razor pages and 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#.
• Working With MS Access And Displaying Data Using Data GridApr 04, 2017. Working With MS Access and displaying data using Data Grid.
• .NET MVC5 - Entity Framework Simple Code First Database ApproachApr 03, 2017. This article is about Entity Framework Code First approach
• Introduction To ADO.NETMar 20, 2017. In the article, we will learn the usage of ADO.NET technology used with ASP.NET.
• 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.
• Exploring SqlConnection In ADO.NETSep 01, 2016. In this article, you will learn SqlConnection class in ADO.NET and connection to a SQL Server using ADO.NET and C#.
• Top 10 Most Popular Articles Of ADO.NETAug 19, 2016. We have compiled a list of top 10 most popular ADO.NET articles.
• Creating Cascading DropDownList In MVC Using Entity Framework And ADO.NETJul 16, 2016. In this article, you will learn how to create cascading drop down lists in MVC, using Entity framework.
• 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.
• Manual CRUD Operation In MVC Using ADO.NETJun 02, 2016. In this article you will learn about working with CRUD Operations In MVC using ADO.NET manually.
• 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.
• Connection Oriented Architecture In ADO.NETFeb 07, 2016. In this article I am writing about connection oriented architecture in ADO.NET.
• Connectionless Architecture In ADO.NETFeb 07, 2016. In this article I am writing about connectionless architecture in ADO .NET.
• 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.
• Evolution Of Microsoft Data Access TechnologiesDec 31, 2015. This article beams on how Microsoft data access technologies evolved over the period of time.
• CRUD Operations In ASP.NET MVC Using ADO.NETDec 28, 2015. CRUD (Create, Read, Update, Delete) operations in an ASP.NET MVC application using raw ADO.NET. It provides a step-by-step guide from creating a database table in SQL Server 2008 to developing MVC components (Controller, Model, Views) in Visual Studio 2015, demonstrating data access and manipulation.
• 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.
• Different Ways To Access DataBase In ADO.NETDec 03, 2015. In this article, I will demonstrate you how to access database in ADO.NET.
• ADO.NET Interview Questions And AnswersNov 23, 2015. This article lists top ADO.NET Interview questions and answers.
• SqlTransaction In C#Nov 03, 2015. Transactions in databases ensure data integrity using ACID properties: Atomicity ensures all steps complete successfully or rollback completely, Consistency ensures transitions maintain data rules, Isolation prevents interference between transactions, and Durability ensures committed changes persist.
• Important ADO.NET Interview QuestionsOct 24, 2015. In this article we will discuss about the most asked ADO.NET interview questions and answers.
• ADO.NET Technique With ASP.NETOct 13, 2015. In this article, I will explain ADO.NET concepts that include DataTable, DataSet, DataReader and DataAdapter.
• CRUD Operation Using ASP.NET MVC, JSON, ADO.NET, Stored ProcedureOct 06, 2015. In this post we will learn basic CRUD operations using ASP.NET MVC, JSON, ADO.NET, and Stored Procedure with a sample MVC Application.
• Overview Of ADO.NETSep 22, 2015. In this article I am giving brief explanation about ADO.NET and Data bound control.
• CRUD Operations In ASP.NET MVC 5 Using ADO.NETSep 06, 2015. Learn how to implement CRUD operations in ASP.NET MVC 5 using ADO.NET. This tutorial covers database connectivity, SQL Server integration, controller actions for Create, Read, Update, and Delete operations, along with model validations and data annotations.