data access Resources

Share

Related resources for data access

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.
Data Access Layer to execute Stored Procedures11/3/2020 1:03:35 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
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.
MVC architecture in ASP.Net using C# and Microsoft Data Access Application block5/26/2009 2:42:42 AM. In this article we will learn how to use Microsoft Data Access Application block in ASP.Net using C#, I have used Microsoft Data Access Application block in conjunction with MVC architecture, here you will learn lot about class libraries, interface, implementation etc.
RFC Architecture for Finance Project (The Invoicing Project)4/6/2009 5:54:42 AM. RFC is an open source initiative for Finance projects. It has reusable components like invoicing, accounting and purchase modules. In this section we will discuss about the Invoicing section of the RFC architecture.
OleHelper for Microsoft Access (.MDB) in ASP.NET 2.09/18/2008 12:50:27 PM. This article is very much similar to the Microsoft Data Access Application Block, provides static methods in a "sealed class OleHelper" where I have Execute Dataset, ExecuteNonQuery & PrepareCommand to work with Microsoft Access database.
Generic Data Access using LINQ to SQL and C#7/27/2008 1:21:07 PM. This article discusses the construction of a generic data access layer built on top of a LINQ to SQL implementation.
Data Access in Silverlight Controls using Silverlight Enabled WCF Service7/15/2008 10:49:52 AM. In this article, I will discuss how to access data in Silverlight 2 using a Silverlight Enabled WCF Service.
Data Access and Data Binding in Silverlight Controls using WCF Service7/15/2008 1:26:43 AM. In this article I will discuss how to bind data to Silverlight controls and access data in Silverlight 2 using WCF Service.
Enterprise Library 3.0 Data Access Application Block7/12/2007 12:41:22 AM. Data Access Application Block(DAAB) simplifies development tasks that implement common data access functionality.The DAAB provides access to the most often used features of ADO.NET in simple-to-use classes; this boosts developer productivity.
Using the ObjectDataSource control with the data access class6/18/2007 12:40:19 AM. In this article I will show that how you can use the ObjectDataSource control with the data access class (DA.dll, but it can be one of yours), described earlier, in your Web applications. The examples are written using C# and T-SQL.
Understanding ADO.Net Provider Factory in .Net 2.01/29/2007 3:47:21 AM. This article describes the ADO.NET Provider Factory in .NET 2.0
Data Access Component and the Factory Design Pattern4/5/2006 7:53:34 AM. A generic Data Access Component implementation written in C# that supports SQL, Oracle, OLEDB and ODBC data providers. Using the Factory design pattern for instantiating the data provider correct and specific objects determined at run time.
Designing and Implementing a Versatile Data Access Tier 3/29/2006 3:35:09 AM. In this tutorial, we will drill down deeper in to the design of a n-tier architecture and our focus will be on the data access tier(DAT). Our goal is to design and implement an appropriate data access tier(DAT) for scalable, reliable and interoperable web application.
Evolving into an N-Tier Application2/3/2006 1:49:10 AM. This article gives description about evolution of N-tier application.
Building Data Access Helper Component for Microsoft SQL Server2/3/2006 12:58:58 AM. In this article I will be going through the development of a class library similar to Microsoft Data Application Blocks.
Microsoft patterns & practices: The Enterprise Library2/1/2006 6:23:01 AM. Microsoft patterns & practices provide scenario-specific recommendations illustrating how to design, develop, deploy, and operate architecturally sound applications for the Microsoft .NET platform.The following article covers details on the Data Access Application Block.
Using OLEDB in ADO.NET with COBOL1/30/2006 12:10:49 AM. The SqlClient class was created by Microsoft and is used primarily to access a SQL Server database.
ADO.NET Enhancements in .NET Framework 2.0 for SQL Server Data Provider: Part I1/10/2006 4:34:34 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 2.0 platform
Building Generic Data Access Class using ADO.Net 2.01/4/2006 1:42:32 AM. 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.
Writing a Generic Data Access Component1/3/2006 4:10:28 AM. OK, 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 libraries.
A Generic Data Access Component using Factory Pattern1/3/2006 2:19:02 AM. Another way to solve this problem is to utilize the System.Activator class and a factory pattern to create the concrete provider classes as was pointed-out in Dan Fox's article "Design an Effective Data-Access Architecture" (.netmagazine, vol. 2, no. 7).
Data Access through Web Services, Stored Procedures and SQL Queries12/16/2005 7:46:57 AM. Web Services has been the most revolutionary aspect of the .NET framework developed by Microsoft. This article presents the three different modes through which data can be accessed viz. through Web services, stored procedures and SQL query using the power of ADO.NET and XML.
Generic database access with Mimer Provider Manager12/14/2005 12:33:08 AM. The Mimer Provider Manager uses different plugins to access different underlying ADO.NET providers. Plugins are developed for Oracle, SQL Server, ODBC, and OLE DB.
Remote Data Access Layer12/13/2005 11:21:38 PM. The attached source project is a data access layer library and the main idea of developing such a DAL is to separate the database execution from the client/end user and maintain it on the server side, there by reducing the number of direct simultaneous connection to the SQL Server.
Security in ADO.NET12/13/2005 5:36:17 PM. This article gives a sound idea how to write secure code for ADO.NET . Data Access Layer (DAL) is a common and very curtail for your application. Its very important know some of the basic security points while writing ADO.NET program.
Asynchronous Data Access using Callback Model12/13/2005 5:17:04 PM. The problem with the ADO.Net 1.x is that one thread has to wait for the other thread to complete. So to overcome this problem Microsoft has introduced Asynchronous data access, through which one can execute multiple threads at a time.

Topics