Resources No resource found - 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. This article is for the developer who is looking to learn .NET Core MVC with ADO.NET for their project.
- 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. 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.
- 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 MVC Project Step By Step From Scratch- Part OneNov 27, 2016. In this article, you will learn to create an MVC project step by step from scratch.
- 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. 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.
- Connectionless Architecture In ADO.NETFeb 07, 2016. In this article I am writing about connectionless architecture in ADO .NET.
- Connection Oriented Architecture In ADO.NETFeb 07, 2016. In this article I am writing about connection oriented 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. This article going to discuss how we can perform CRUD operations using ADO.NET in ASP.NET MVC.
- 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#.
- 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. SqlTransaction class of ADO.NET is used to execute transactions. Learn how to use the SqlTransaction in C# and SQL.
- 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. In this article we will learn insert, update, delete and view operations using ADO.NET in MVC.
- ADO.Net Connectivity Using Stored Procedure and Output ParametersMay 10, 2015. This articles explains how to insert data into a SQL database using a Stored Procedure with Output Parameters. Some Bootstrapping is also used to create a good looking HTML.
- SQL Server Database Connection In C# Using ADO.NETApr 25, 2015. ADO.NET provides classes to connect to databases in .NET using C#. This article describes how to create a connection in .NET and use SqlConnection in C#.
- Passing DataTable to StoredProcedure as Parameter in C#Mar 28, 2015. This article describes how to pass a DataTable to a Stored Procedure as a parameter using ADO.NET in C#.
- Retrieve, Insert, Update & Delete in MVC Using ADO.NETFeb 28, 2015. In this article we will see how to retrieve, add and manipulate records using an ADO.NET Entity Model.
- 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.
- Basics of ADO.NETJan 07, 2015. In this article is a basic introduction to ADO.NET, a technology in .NET used to connect with any type of database.
- ADO.NET OverviewDec 09, 2014. In this article we examine the connected layer and learn about the significant role of data providers that are essentially concrete implementations of several namespaces, interfaces and base classes.
- Web Grid in MVC 4 Application Using ADONov 12, 2014. In this article I am showing how to show data in a Web Grid in a MVC 4 application using ADO.NET Entity Data Model.
- ADO.Net Entity Framework DemoSep 27, 2014. This article introduces the Entity Framework for Entity Framework beginners that have already worked with ADO.Net.
- 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.
- Performing Bulk Copy in ADO.NETJul 31, 2014. This article explains how to insert a large amount of data using the SqlBulkCopy class. The bulk copy operation in .Net is a very fast way to copy a large amount of data somewhere to SQL Server.
- Working With SQL NotificationJul 28, 2014. This article explains how SQL Notification can be enabled in SQL Server to build an application that uses notification.
- Establishing Relation and Constraints in a DataTable Using C#Jul 22, 2014. This article explains how to create a relationship between two DataTables and constraints in ADO.Net using C#.
- Introduction To LINQJun 20, 2014. In this article we will learn LINQ. The article explains what LINQ is, why to use LINQ and how to use LINQ.
- ADO.NET Disconnected ArchitectureFeb 27, 2014. This article explains the Disconnected Architecture in ADO.NET.
- Introduction To ADO.NET: Part 2Feb 24, 2014. This article explains the basic details of ADO.NET Part 2.
- Introduction To ADO.NETFeb 20, 2014. In this article I explain the basic details of ADO.NET.
- Database Connectivity in .NET FrameworkFeb 18, 2014. This article explains how to create a connection string or database connectivity in .NET framework (for example, between MS SQL Server and Visual Studio).
- 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.
- Creating ASP.NET MVC APP With WCF ServiceDec 27, 2013. In this article you will learn how to create ASP.NET MVC APP with WCF Service using ADO.NET Entity Data Model.
- Generate Script Of Database in SQL Server 2008Dec 04, 2013. In this article we learn how to generate a database script for database backup purposes and how to correspondingly restore a database using the script we created. We also regenerate an entire database using a database script.
- Using ADO .NET Entity Framework 5.0Nov 14, 2013. This article will introduce you to the ADO.NET Entity Framework 5.0 data model, also known as the Entity Data Model (EDM).
- 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.
- Database Programming With ADO.NETOct 15, 2013. This article defines database programming With ADO.NET. Learn ADO.NET Architecture, Connected Architecture, Disconnected Architecture, Connection Object, Data Reader Object, Data Adapter Object, DataSet Object, DataReader vs DataSet, DataView Object.
- Introducing Data Binding With Windows FormAug 21, 2013.
- Introduction to ADO.NetAug 19, 2013. This article introduces the ADO.Net object model. In addition it explains how to create and manage connections to a database.
- Implement Joins in EntityFramewok Using DB Context and LINQAug 12, 2013. In this article I am sharing how to use joins in Entity Framework with a DB context and a LINQ query.
- Retrieve Data From Database in ASP.Net Web APIJul 29, 2013. This article explains how to retrieve data from the database in the ASP. NET Web API.
- 5 tips to improve performance of C# code: Part 4Jul 21, 2013. In this article, I will show a few ADO.NET tips to improve performance. A connection object is one of the most resource consuming objects in ADO.NET. So we need to manage this object very carefully.
- Connecting the MVC Application Using EntityFramework DB-First Approach: Part 3Jul 13, 2013. The article is an attempt to overcome the confusion related to how to use EntityFramework with MVC application in a very simple way.
- Introducing New Features in Visual Studio 2013: Part 2Jul 03, 2013. In this article i am introducing some extra new features in Visual Studio 2013.
- Passing Connection String Dynamically While Using a Model First ApproachMay 30, 2013. In this article you will learn how to pass connection string dynamically while using a Model First approach.
- How to Create OData Service in ASP.NETApr 30, 2013. In this article, you will learn how to create OData Service in asp.net.
- Working With Command Object in ADO.NETApr 24, 2013. In this article, we will learn how to work with the Command Object in ADO .NET and the Execute Methods in the Command Object.
- How to Use WCF RIA Service in LightSwitch 2012Apr 04, 2013. In this article you will learn how to make a WCF RIA Service and how to consume that using Visual Studio LightSwitch 2012.
- Learn .NET in 60 Days - Part 2 (13 Labs)Mar 02, 2013. This article is part 2 of Learn .NET in 60 Days series. It will provide further details.