data access Resources

Share

Related resources for data access

Difference Between Delegated and App Only Access10/29/2024 9:39:47 AM. Delegated access allows an application to act on behalf of a signed-in user, requiring user authentication and permission via OAuth 2.0, while app-only access enables an app to operate independently w
Repository Design Pattern in MVC Architecture With Entity Framework9/18/2024 5:49:26 AM. In this article, we will learn the Repository Design Pattern in MVC Architecture with Entity Framework simplifies data access by creating a layer between the data and business logic.
Understanding Flutter's BuildContext8/29/2024 9:04:21 AM. BuildContext in Flutter is a key concept representing a widget's location in the widget tree. It helps navigate the tree, access inherited widgets, and manage state and theme data. Understanding B
Repository Pattern In ASP.NET Core8/29/2024 7:16:41 AM. In this article, you will learn about repository pattern in ASP.NET Core.
CRUD Operations with Repository Pattern and Web API in .NET 88/20/2024 6:57:32 AM. This guide covers creating a clean, maintainable data access layer by leveraging the Repository Pattern for managing database interactions and exposing endpoints through Web API, enhancing your .NET 8
Repository Pattern With ASP.NET MVC And Entity Framework8/5/2024 3:59:24 AM. The "Repository Pattern with ASP.NET MVC and Entity Framework" tutorial guides you through implementing a robust data access layer using the repository pattern in ASP.NET MVC applications.
Repository Pattern In ASP.NET MVC8/5/2024 3:53:48 AM. In this article, we will learn about Repository pattern which is mostly used to create enterprise applications. Repository pattern divides application’s UI, business logic and data access components i
LINQ to ADO.NET: Enhancing Data Access with Modern Querying7/23/2024 3:46:30 AM. 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 Qu
Working with Stored Procedures in ADO.NET7/22/2024 6:17:00 AM. 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
Working with Entity Framework Core7/15/2024 5:17:51 AM. Entity Framework Core (EF Core) is a powerful Object-Relational Mapping (ORM) framework provided by Microsoft for .NET applications. It simplifies data access and persistence by allowing developers to
Generic Repository with EF Core in .NET Core 87/3/2024 9:18:09 AM. Observe the Entity Framework Core Generic Repository! The subject that will make some people uncomfortable. They are unwilling to discuss it at all. Others, on the other hand, adore it and become gidd
Consume API in Repository Design Pattern7/2/2024 8:57:02 AM. Learn how to effectively consume APIs using the Repository Design Pattern. This approach enhances code organization by separating data access logic into reusable repositories, promoting maintainabilit
Techniques of State Management in .NET6/24/2024 6:03:49 AM. State management in .NET 6 is essential for preserving and accessing data across web applications. Techniques include server-side (session state, database storage) and client-side (cookies, LocalStora
Building a .NET Desktop Application6/7/2024 10:30:03 AM. Learn to develop a .NET desktop application with SQL Server data storage, employing a structured approach involving data access, business logic, and presentation layers. Utilize Visual Studio 2019, S
Data Access Layer to execute Stored Procedures6/5/2024 5:31:47 AM. This article explains about executing a single stored procedure or batch of stored procedures from the application layer. As Data access layer completely decoupled from Application layer we just need
Dependency Injection Using Microsoft Unity Framework6/5/2024 5:30:32 AM. Explore Dependency Injection with Microsoft Unity Framework in the C# console app, emphasizing SOLID principles, IoC, and DI implementation for loosely coupled layers, enhancing testability.
Introduction to ADO.Net5/30/2024 12:10:13 PM. Explore ADO.NET, a vital component of the .NET Framework for seamless database connectivity. Utilize connection objects, commands, data readers, datasets, and adapters to interact with databases effic
Understanding Reflection in C# 5/28/2024 5:50:06 AM. Reflection in C# allows runtime inspection and interaction with object types and members, enabling dynamic invocation, type inspection, and metadata access. It's powerful for development tools and
Working With Stored Procedures Using Entity Framework: Part 15/16/2024 8:32:00 AM. Learn how to leverage Entity Framework for interacting with stored procedures in your .NET applications. This tutorial explores integrating stored procedures into your data access layer, optimizing da
CRUD Operations In ASP.NET MVC 5 Using ADO.NET5/16/2024 5:46:35 AM. 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 opera
CRUD using the Repository Pattern in MVC5/10/2024 7:59:18 AM. This article introduces the repository pattern in an MVC application. Repository pattern is intended to create an abstraction layer between the data access layer and the business logic layer of an app
Simple Insert And Select (CRUD) Operation Using .NET Core MVC With ADO.NET And Entity Framework Core5/7/2024 10:33:55 AM. 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.
NHibernate in Details: Part 24/30/2024 9:49:29 AM. Dive deeper into NHibernate with Part 2, exploring advanced topics like session management, querying, and performance optimization. Uncover the intricacies of this powerful object-relational mapping t
Storage Services Use Cases and Best Practices in Azure and AWS [Part 2]4/30/2024 8:25:53 AM. Absolutely, choosing the right storage service in Azure or AWS is crucial for achieving optimal performance, scalability, cost-efficiency, and compliance with data management requirements.Understandin
Working With Multiple Tables in MVC Using Entity Framework4/29/2024 10:12:37 AM. Learn how to effectively work with multiple database tables in ASP.NET MVC using Entity Framework. Explore entity relationships, database modeling, and data access strategies.
Database First Approach in MVC 5: Part 24/25/2024 10:41:59 AM. In MVC 5's Database First Approach (Part 2), delve deeper into leveraging Entity Framework for seamless integration with existing databases. Explore scaffolded views, data validation, and CRUD ope
Model Binding in ASP.Net 4.5 Label Control4/25/2024 10:10:50 AM. Explore the power of Model Binding in ASP.Net 4.5 Label Control for seamless data integration. Learn how to bind data effortlessly to Label Controls, enhancing user experience and streamlining data pr
Efficient Data Manipulation: Using Square Brackets in DataTable Compute4/24/2024 1:56:01 PM. Square brackets are used in programming for indexing and accessing elements in lists, arrays, or other data structures. They provide a concise and intuitive way to reference specific elements based on
Select Stored Proc With Raw SQL Query Via EDF Framework4/18/2024 10:43:47 AM. Utilize Entity Data Framework (EDF) for selecting stored procedures with raw SQL queries. Enhance data access in your application by leveraging the power of SQL alongside EDF's object-relational m
Installing EF Core with Empty Template in ASP.NET MVC Core 3.04/15/2024 11:49:21 AM. Discover how to seamlessly integrate Entity Framework Core into your ASP.NET MVC Core 3.0 application using an empty template. Follow a step-by-step installation guide to set up the data access layer
Combine ADO.NET, EF Core And Dapper In Same Blazor App 4/15/2024 11:09:08 AM. 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 perfor
Model in ASP.Net MVC : Part 14/2/2024 9:15:36 AM. The Model in MVC encapsulates application logic, excluding view and controller logic. It manages data and performs operations. This article guides through creating and utilizing a Model class in an MV
Practical Introduction To Entity Framework: Day 13/6/2024 10:29:58 AM. In this article, we will discover the fundamentals of Entity Framework in this practical introduction. Learn about ORM concepts, database operations, and CRUD operations through hands-on examples.
External Data - Attributes - Profiling Data Access1/6/2024 6:20:56 AM. The external data is recognized as the data we must pull or push from outside of a boundary of the process hosting the computer program. A very important kind of external data is streaming data. Usual
Mastering PostgreSQL CRUD Operations in .NET 8 with ADO.NET1/1/2024 7:47:53 AM. Mastering PostgreSQL CRUD Operations in .NET 8 with ADO.NET: Best Practices and Code Examples
ASP.NET Core Web API Development with Template Method Pattern and 3-Tier Architecture11/13/2023 3:22:35 PM. This design pattern allows for a structured, modular, and easily maintainable architecture by separating concerns into distinct layers and leveraging the Template Method Pattern to provide a common st
Implementing State Design Pattern in ASP.NET Core Web API with 3-Tier Architecture11/10/2023 5:17:55 AM. In this ASP.NET Core Web API project utilizing a 3-Tier Architecture with the State Design Pattern, we've created a News management system that encapsulates the state of news items, allowing for a
ASP.NET Core Web API Development with Observer Design Pattern11/1/2023 7:55:20 AM. This project represents a robust ASP.NET Core Web API application that manages tickets using a 3-tier architecture. The system provides full CRUD (Create, Read, Update, Delete) functionality for ticke
How Caching Improves Data Access Performance?10/27/2023 5:05:32 AM. In this article, we explore caching's role in enhancing data access performance. Caching involves storing frequently accessed data, reducing latency and database load. Despite its advantages, chal
ASP.NET Core Web API with 3-Tier Architecture and Iterator Pattern10/19/2023 6:27:35 AM. The Iterator Pattern is a behavioral design pattern that provides a way to access elements of a collection sequentially without exposing its underlying representation. It defines an interface for acce
New Dataset Features In ADO.Net 2.010/12/2023 4:58:43 AM. 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
Building a Robust ASP.NET Core Web API with Singleton Design Pattern and Three-Tier Architecture10/4/2023 4:38:38 AM. This example provides a basic structure for a Three-Tier Architecture in an ASP.NET Core Web API, implementing a Singleton Design Pattern for the Data Access Layer. Remember to adjust the code based o
Simplify Your Data Access with Dapper.NET8/31/2023 9:56:55 AM. Discover the agility of Dapper.NET, a micro-ORM. Harness its speed and raw SQL support for streamlined, high-performance data retrieval, even for stored procedures.
Data Access with Dapper.NET8/30/2023 8:43:01 AM. Streamline data access with Dapper.NET, a lightweight ORM for .NET apps. Learn its key features like speed, lightweight design, raw SQL support, and automatic object mapping. Delve into practical exam
Easily Connect to a Database In C#8/25/2023 10:24:29 AM. Connecting to a database in C# can be achieved using ADO.NET, a powerful technology for data access. With ADO.NET, you can easily establish connections to various database systems, such as SQL Server,
Evolution Of Microsoft Data Access Technologies8/8/2023 8:29:04 AM. This article beams on how Microsoft data access technologies evolved over the period of time.
SQL Security Tips - Dynamic Data Masking To Secure Data Access3/9/2023 5:22:36 AM. There are various aspects of security, and Dynamic Data Masking is one of the important concepts to know. We will describe here what is Dynamic masking and how to implement it with step-by-step exampl
Import Data From Excel to SQL Server (SSIS)1/17/2023 10:53:08 AM. This article shows a simple procedure for importing data from Excel to SQL using SQL Server Integration Services (SSIS).
Symmetrical Repository Pattern - Data Access Made Easy In .NET5/29/2022 3:39:55 AM. In this article, I will describe an interesting pattern that can be implemented to make it trivial to perform CRUD/RESTful data access across a full-stack .net system, with this technique that abstrac
Advanced Entity Framework Core: Extract data access layer with migrations to the library project and Execute migrations from the command line1/11/2022 3:14:14 AM. See code examples in this article: Let's imagine you have a solution with many projects including a web application with the name "MiniService", which contains appsettings.json and
Pass Data in Layered Architecture: Part-2: Non Uniform Style4/2/2021 10:32:37 AM. This article explains how to transfer data in a non-uniform fashion.
An Example of URL Rewriting With ASP.Net3/18/2021 6:41:40 AM. This article introduces URL rewriting using a data-driven application. This application creates various blogs and these blogs are accessed by the title of the blog.
Pass Data in Layered Architecture: Part-1: Uniformly Using Entity Class2/25/2021 8:52:26 AM. This article explains how to pass data across layers in a uniform fashion using an entity class.
Enterprise Library: Data Access Application Block 5.0 in ASP.NET2/16/2021 11:03:28 AM. In this sample you will how to use data access application block 5.0 with real time example in asp.net.
Understand 3-Tier Architecture in C#1/18/2021 12:02:06 PM. In this article we will learn to implement 3- Tier architecture in C#.NET application.
A Quick Look At Entity Framework 7 In-Memory Provider (for Testing)1/18/2021 9:11:38 AM. In this article you will have a quick look at Entity Framework 7 In-Memory Provider for Testing.
Writing A Generic Data Access Component - Flexible Approach12/7/2020 1:10:14 AM. Here is one more flexible approach to achieve the same. I prefer this approach to generic data access.
Data Access Overview For Smart Device Extensions11/26/2020 12:20:22 AM. In this article we will take a brief look at ata Access for Smart Device Extensions.
ADO.NET From Windows DNA's Perspective11/2/2020 10:22:05 AM. Windows DNA is a framework to build multi-tier, high performance, scalable distributed applications over the network. This article takes a Windows DNA perspective and compares how ADO.NET fits in Wind
Generic Data Access Component using Factory Pattern11/1/2020 11:53:01 PM. The article A Generic Data Access Component using Factory Pattern provides a very good way of creating ADO.Net data provider independent applications, but there is one problem with it. Different ADO.N
ADO.NET Enhancements in .NET Framework 2.0 for SQL Server Data Provider: Part II11/1/2020 7:38:16 AM. ADO.NET 2.0 includes enhancements for SQL Server client application developers. Understanding these enhancements will help you design and implement effective client applications on the .NET Framework
Importance of Data Access Layer11/1/2020 7:08:29 AM. This article is written to see the importance of having a separate Data Access layer.
Basic Database operations using ADO.NET10/29/2020 8:27:36 AM. I found very interesting database features incorporated into the .NET as ADO.NET.
MEF With WCF - Start UP9/30/2019 3:59:56 AM. In this article, I will be creating a Data Access Layer using WCF. I will be using MEF(Managed Extensibility Framework) to export the data from the Data Access Layer class and then import it.
Writing a Generic Data Access Component3/7/2019 12:31:49 AM. I've received couple of emails people asking me how can they use a common data provider to access various types of data sources without loosing the power and flexibility of native data provider li
A Generic Data Access Component using Factory Pattern3/7/2019 12:29:01 AM. This article shows to utilize the System.Activator class and a factory pattern to create the concrete provider classes.
Data Access Application Block Using MVC 2 Pattern12/18/2018 3:02:24 AM. In this article I am trying to illustrate how to use Microsoft enterprise library data using MVC 2 pattern.
Data Access Approaches Of Entity Framework10/16/2018 5:30:20 AM. The intent of this article is to explain the three data access approaches that Microsoft’s Entity Framework provides. There are several good articles on the internet on this topic, but I would like to
Separation Of Concern And Data Access From Within Code3/31/2018 5:42:22 AM. In this article, you will learn the separation of concern and data access from within code.
MySQL Data Access API Development Using Express.JS, Node.JS12/14/2017 12:25:22 PM. In this article, we are looking into introduction of Node.JS, Express.JS and then I am going to create Simple MySQL data access API using Express.JS, Node.JS.
Data Access Using Entity Framework In MVC7/10/2016 12:59:47 PM. In this article, you will learn about data access using Entity Framework in MVC.
Data Access With ADO.NET In Micro Focus Visual COBOL6/24/2016 12:12:10 PM. In this article, you will learn about data access with ADO.NET in Micro Focus Visual COBOL.
Enterprise Library Data Access Application Block In C# .NET12/12/2015 12:53:32 PM. In this article I will explain how easy it is to develop Data Access Layers with these libraries.
Business Entity And Data Access Layer In MVC 12/5/2015 10:38:24 AM. This article explains how to use business entities layer and data access layer in ASP.NET MVC.
Reusability Of The Code With Three Layers Architecture In ASP.NET11/26/2015 9:34:59 AM. In this article, you will learn about how to implement three layers architecture with ASP.NET application.
3 Layer Architecture in ASP.Net8/11/2015 10:42:46 PM. This article describes one of the important topics of development architecture, the 3-layer architecture.
MVC Data Access and Filter Using Entity Framework and HTML Helpers - Part 27/27/2015 2:39:47 PM. In this tutorial, we will learn how to use multiple tables and their relationship to fetch data from the database. Also we will learn something more about HTML Helpers.
Securing Your ASP.Net App Data That Has an Insecure Direct Object Reference3/11/2015 5:56:45 PM. In this article we will learn about measures for making your ASP.NET App Data Secure.
ADO .NET Evolution: Part II: 2-Tier to 3-Tier1/29/2015 4:01:39 AM. Implementation and example of a 3-Tier Application.
Working With ASP.Net Web Forms in Visual Studio 201312/19/2013 3:20:22 PM. In this article we will create the Data Access Layer to the ASP.NET Web Forms Application in Visual Studio 2013.
How to Architect an Application10/30/2013 12:10:46 PM. In this article let’s get into the business of how to architect an application.
Improve Performance and Scalability of ADO.NET Code10/22/2013 4:29:19 PM. This article expects that you have enough hands on experience in ADO.NET and good understanding of ADO.NET architecture.
C# Corner Chandigarh Chapter Meet, August 3, 2013 Official Recap8/11/2013 11:28:29 PM. C# Corner Chandigarh Chapter has organized its second in-person event on the Third of August 2013. It was a house full of attendees who came across to attend this event. Thanks to all who joined us.
Data Source Controls2/3/2013 4:20:46 PM. In this article, we explore the role of Data Source Controls in building web applications.
Generic Data Providers VS Specific Data Providers10/20/2012 5:05:32 AM. This article explains what are the issues or options we have if we use generic data objects such as IDbcommand, Idbconnection etc in place of specific data objects such as SqlCommand or SqlConnection.
Working with Relational Data in ADO.NET10/20/2012 4:32:46 AM. Working with hierarchal data was not that easy with the previous version of ADO.
Data Access Component for SQL Server in C#10/20/2012 3:20:22 AM. The attached source code a data access component for SQL Server that contains methods to get a DataSet.
Simple Factory Pattern Side by Side with Abstract Pattern10/4/2012 10:45:46 AM. This article will discuss the Simple Factory Pattern and how to use it with Abstract Factory Patter discussed in the previous article.
Building Custom Paging Web Form10/4/2012 7:40:10 AM. Sometimes we may need to build our own data objects instead of using DataSets & DataTables. But in this case, we will lose all paging and sorting facilities that is represented using DataSets & DataTables. To overcome this small issue we'll have to write our own custom paging feature as well as with sorting.
SQL Server Compact and LINQ9/30/2012 1:57:42 AM. In this article, I will cover how to access data in SQL Server Compact databases (.sdf file) using new development technologies such as LINQ.
Developer Roadmap For Building Smart Client Applications5/19/2012 6:11:44 AM. This article is a developer Roadmap For Building Smart Client Applications.
Building Data Access Class5/15/2012 3:56:21 PM. In this article I will describe one of the ways to build data access layer component, using such feature of the VS 2005 as generic.
NLayers Examples2/24/2012 2:11:06 PM. This article is meant to provide examples of using the NLayers project.
Generic Data Access Layer: Part 19/8/2011 9:29:47 AM. In this article we wwill be discussing how we can create a Generic Data Acess Layer which we could use in developing our Business Applications.
LINQ With 3 Layer Architecture (Insert Data Into Database)6/22/2011 4:03:49 PM. Here you will see how to use LINQ with 3 Layer Architecture (Insert data into database).
DALC4NET (An All in One .NET Data Access Layer) 5/11/2011 9:27:56 AM. DALC4NET is an Open Source data access layer built for Microsoft .NET projects. This enables us to access data from SQL Server, Oracle, MySql, MS Access, MS Excel etc. data bases.
Using 3 Layer Architecture to Insert Data Into a Database4/13/2011 1:32:47 PM. How to use 3 Layer architecture to insert data into a database.
Layer Model Of Development3/29/2011 1:28:38 PM. A layer is a reusable portion of code that performs a specific function.
3 Tier Architecture11/2/2010 6:05:11 AM. 3-Tier architecture is a very well know buzz word in the world of software development whether it web based or desktop based. In this article I am going to show how to design a web application based on 3-tier architecture.
N-Tire Web Application Sample5/27/2010 5:03:29 AM. In this simple article we will see a sample of n-tier web application.

Topics