C# Corner

Resources  
  • XML as Middle TierJul 12, 2001. There is always been a need that there will be an intelligent middle Layer between Database Server and the UI Code. There are many ways but one fantastic approach came in picture with the XML.
  • Basic Database operations using ADO.NETAug 21, 2001. I found very interesting database features incorporated into the .NET as ADO.NET.
  • ADO.NET From Windows DNA's PerspectiveJun 12, 2002. 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 Windows DNA.
  • Database Vendor Independent Code with Improved Connection PoolingOct 17, 2002. This article covers how to create a database application that allows you to specify different databases without writing code for different data providers.
  • Building Data Access Helper Component for Microsoft SQL ServerMay 13, 2003. In this article I will be going through the development of a class library similar to Microsoft Data Application Blocks.
  • Data Access Layer based on dataSetsJul 01, 2003. This article aims to introduce the reader to several conceptual problems encountered in the development of a generic Data Access Layer (from now on referred to as DAL).
  • Migrating COM/DCOM Applications in Microsoft .NET FrameworkDec 09, 2003. In the current Internet scenario, various classic applications run on multiple networks. These applications could have been written using different languages like Visual Basic, Visual C++. For example, a retail organization would have different systems, such as an inventory management system, a bill of material systems, and a general ledger system, all implemented using various technologies available for application development. These systems need to be integrated to form a higher-level enterprise information system for an organization.
  • Remote Data Access LayerAug 24, 2004. 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.
  • Data Access Layer to execute Stored ProceduresJan 18, 2005. 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 to change the Application layer in case of any change in underlying database schema.
  • Security in ADO.NETJul 16, 2005. 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.
  • SQL Server Reporting ServicesAug 04, 2005. This article describes how to modify the team reports generated by VSTS or BI Studio over SQL Server 2005.
  • Introduction to Model View Control (MVC) Pattern using C#Dec 12, 2005. The benefits of using the Model-View-Control (MVC) pattern in our development projects is that we can completely decouple our business and presentation application layers. Furthermore, we will have a completely independent object to control the presentation layer.
  • 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.
  • Importance of Data Access LayerJan 19, 2006. This article is written to see the importance of having a separate Data Access layer.
  • An Elegant C# Data Access Layer using the Template Pattern and GenericsMay 22, 2006. The GOF Template pattern coupled with .NET 2.0 Framework generics provides an awesome synergistic alliance. This article demonstrates how to drastically reduce the amount of code required in building a data access layer. Less code to debug... less code to break... less code to maintain... what could be better?
  • Use of Proxy when using WebSericesAug 10, 2006. The article shows the advantages of using Proxy layer to add Web Services compared to using the "Add Web Reference" wizard.
  • TDO - Typed Data Object 2.0Aug 10, 2006. Tdo – Typed Data Object is a set made up of a base classes library and a .NET 2.0 source code generator for Data Layers based on Ms Sql Server 2000/MSDE/2005/EXPRESS databases and the .NET Framework 2.0.
  • Implementing N-Tier Architecture in Web ApplicationsOct 31, 2006. This article provides a brief introduction to the creation of a N-Tier Architecture System for Web Applications.
  • A guide to ObjectDataSource controlNov 17, 2006. One of the best new features of the forthcoming ASP.NET 2.0 will be the ObjectDataSource control. However, as I found out in my experimentation what seems like a simple control has some complex behaviours to master to get it working properly. If (like me) you have an existing data access layer you may have to make changes to be able to use ObjectDataSource.
  • Building Data Access ClassFeb 27, 2007. 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.
  • Set up Secure Sockets Layer (SSL) using Digital CertificatesMar 06, 2007. This article explains how to secure an IIS Web application using SSL certificates.
  • Generic Data Layer - One time creationSep 06, 2007. This article will explain how to create a generic data layer that can be used with very less amount of coding. It is a known fact that, most of the time we create applications for Create , Select , Update, Delete. And every time, we end up with writing similar set of code for every execution of our stored procedures.
  • Creating Extensible and Abstract LayerFeb 28, 2008. This article explains you about the abstraction and extensibility which is an important factor in modern day frameworks.
  • The Zen of GUI ProgrammingMar 13, 2008. This article describes some important rules to follow when creating an application that contains a presentation layer.
  • Executing multiple stored procedures within a single transaction context from ADO.NetMar 20, 2008. This article discusses how we can execute multiple stored procedures in ADO.NET with different parameter values in a single Transaction context.
  • High Performance Abstraction Layer for Non-Blocking Asynchronous Thread Safe SqlServer CallsApr 25, 2008. One of the things I find myself doing frequently is writing (and re-writing) plumbing code to execute database CRUD operations. I wrote an abstraction layer over asynchronous SqlServer calls that allows developers to correctly make async calls agains SqlServer without having to deal with any of the complex plumbing normally required. All source code is included with this article.
  • Generic Data Access using LINQ to SQL and C#Jul 22, 2008. This article discusses the construction of a generic data access layer built on top of a LINQ to SQL implementation.
  • Web Application ArchitectureNov 09, 2008. This article is about web application architecture. In this article you see how to separate each layer and why it's necessary for good application architecture. Also a small introduction to the Spring Framework and ORM can be found in this article.
  • ASP.NET ObjectDataSource Control OverviewDec 04, 2008. This post explains how to represent business objects with the ObjectDatasource control. It allows you to bind DataBound controls such as GridView, DetailsView and FormView. It also enables you to separate your business logic and data access logic from presentation layer.
  • SQL Server Compact and LINQFeb 13, 2009. In this article, I will cover how to access data in SQL Server Compact databases (.sdf file) using new development technologies such as LINQ.
  • Service Oriented Architecture (SOA) - FAQ'sFeb 14, 2009. In this article we will discuss abour Service Oriented Architecture (SOA) which is must and essential for every architect.
  • RFC Architecture for Finance Project (The Invoicing Project)Feb 26, 2009. 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.
  • F# Data Abstraction Layer For C#Apr 06, 2009. In this article I'll take a look at building a data abstraction layer in F# and consuming it with C#.
  • An Introduction to LINQJun 06, 2009. LINQ stands for Language INtegrated Query. Means query language integrated with Microsoft .NET supporting languages i.e. C#.NET, VB.NET, J#.NET etc. Need not to write\ use explicit Data Access Layer.
  • Interop Without PInvoke - Consuming Native Libraries in C#.Sep 07, 2009. This article will help get you started consuming native code with C# by writing your own interop layer in C++/CLI as a much cleaner and more flexible alternative to using PInvoke.
  • Optimize your Data Layer for quicker Code Development Feb 19, 2010. In this article we will see how to optimize the data layer.
  • How to Architect an ApplicationApr 28, 2010. In this article let’s get into the business of how to architect an application.
  • Test-driven development approach for database applicationsMay 10, 2010. In this article, I will show how programmers can use the test-driven development approach to test enterprise solutions and its underlying data layer which should also support transactions in order to manage persistent data and leave the database systems in correct states.
  • N-Tire Web Application SampleMay 26, 2010. In this simple article we will see a sample of n-tier web application.
  • How to use Tool Menu in Microsoft Expression BlendSep 15, 2010. Tool Menu in Microsoft Expression Blend has the option for Creating Layer, Make Button, Make Control, Make Image 3D, Make Brush Resource, Edit Brush Resource, Font Manager, Options.
  • 3 Tier ArchitectureNov 02, 2010. 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.
  • Chapter 1: From 2003 to 2010: Business Logic and DataNov 22, 2010. After reading this chapter, you will be able to: Use the Entity Framework (EF) to build a data access layer using an existing database or with the Model-First approach Generate entity types from the Entity Data Model (EDM) Designer using the ADO.NET Entity Framework POCO templates Get data from Web services Learn about data caching using the Microsoft Windows Server AppFabric (formerly known by the codename “Velocity”)
  • Chapter 5: From 2005 to 2010: Business Logic and DataNov 30, 2010. After reading this chapter, you will be able to Use the Entity Framework (EF) to build a data access layer using an existing database or with the Model-First approach .Generate entity types from the Entity Data Model (EDM) Designer using the ADO.NET Entity Framework POCO templates. Get data from Web services Learn about data caching using the Microsoft Windows Server AppFabric (formerly known by the codename “Velocity”)
  • Model View Presenter Pattern Implementation in ASP.NETDec 08, 2010. In this tutorial, I will show you how to implement MVP in a web app as well as a windows app. Another important aspect of MVP patterns is to do unit tests of your whole interface as well as business layer.
  • Chapter 8: From 2008 to 2010: Business Logic and DataJan 20, 2011. After reading this chapter, you will be able to Use the Entity Framework (EF) to build a data access layer using an existing database or with the Model First approach. Generate entity types from the Entity Data Model (EDM) Designer using the ADO.NET Entity Framework POCO templates Learn about data caching using the Microsoft Windows Server AppFabric (formerly known by the codename “Velocity”)
  • DALC4NET (An All in One .NET Data Access Layer) Feb 07, 2011. 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.
  • FileUpload saving data to SQL Server tableFeb 10, 2011. This article describes two simple ASP.NET pages for handling the stuff; one page for uploading and saving files to a SQL Server table and one for sending the selected file back to the user when requested. There is also a db class for the database jobs, separating the logic from the presentation layer.
  • WCF Messaging LayerFeb 15, 2011. This article helps to explain and list some basics of WCF Messaging Layer.
  • How to Retrieve Images from Database (In Layer Architecture)Feb 27, 2011. Here you will learn how to Retrieve Images from a Database (In a Layer Architecture).
  • Simplest example of MVP design pattern of Asp.netMar 10, 2011. So here we’ll discuss the MVP pattern. MVP is Model, View , Presenter. This pattern is how the interaction between these layers can be done.
  • Layer Model Of DevelopmentMar 29, 2011. A layer is a reusable portion of code that performs a specific function.
  • Scene Order (Layer Order) in XAML SilverlightApr 11, 2011. In this article, you will learn how to order elements or scenes.
  • Using 3 Layer Architecture to Insert Data Into a DatabaseApr 13, 2011. How to use 3 Layer architecture to insert data into a database.
  • SQL Azure ArchitectureMay 17, 2011. SQL Azure, which resides in the Microsoft Data Center, provides relational databases to applications with four layers of abstraction.
  • LINQ With 3 Layer Architecture (Insert Data Into Database)Jun 22, 2011. Here you will see how to use LINQ with 3 Layer Architecture (Insert data into database).
  • Silverlight 4 LINQ to SQL Classes in VS 2010Jul 14, 2011. LINQ to SQL is an ORM (stands for Object Relational Mapper/Mapping), which provides a data access layer for the application.
  • MEF With WCF - Start UPJul 23, 2011. In this article I will be creating a Data Access Layer using WCF. I will be using MEF to export the data from the Data Access Layer class and then import it.
  • ADO .NET Evolution: Part II: 2-Tier to 3-TierAug 09, 2011. Implementation and example of a 3-Tier Application.
  • ASP.NET MVC, WCF, ASP.NET Webforms, and JQueryAug 10, 2011. The sole purpose of any API within the applications I build is to deal with business layer logic and the data related to it. Ideally speaking I would want my API to return structured data which is easily transformed into a format for the client application using the API (e.g. JSON). And all my UI for web applications must be handled with client-side scripts. Client side includes both static HTML, CSS and JavaScript, and in this instance I specifically refer to JavaScript and the handling of my API’s data using JSON, for which I use jQuery.
  • Generic Data Access Layer: Part 1Sep 08, 2011. 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.
  • Generic Data Access Layer for WCF : Part 3Sep 19, 2011. In this article, we will see how we can modify what the ADO.NET Entity Framework has provided us to achieve a Generic Data Access Layer.
  • 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.
  • Generic Data Access Layer for WCF : Part 4Sep 20, 2011. In this article we will create a WCF Business Layer and its methods.
  • Generic Data Access Layer for WCF : Part 5Sep 21, 2011. In this article, we will solve the runtime serialization issues we encountered in the previous article.
  • How to Secure a Web Site Using SSLJan 18, 2012. Secure communication is an integral part of securing your distributed application to protect sensitive data, including credentials, passed to and from your application, and between application tiers.
  • Data Binding and Data Templating in Windows Store AppFeb 13, 2012. In this article we are going to explore building a Windows Store App using JavaScript and HTML5, which is how to bind your data model to the UI layer.
  • NLayers IntroductionFeb 18, 2012. In this article I would like to introduce a layering framework named NLayers. This article is intended for experienced developers or architects with a good understanding of ASP.NET and the ADO.NET Entity Framework.
  • NLayers ArchitectureFeb 24, 2012. NLayers tries to provide a Layering solution to a typical ASP.NET application. This article is a continuation of the previous one about NLayers Introduction and Installation.
  • Canvas Shape Layering Using HTML 5Mar 06, 2012. In this article we are going to have a very interesting section about canvas shape layering using HTML 5. To layer shapes we can use one of the following layering methods like moveToTop(), moveToBottom(), moveUp() and moveDown().
  • Traffic Layers Bing Maps in AJAXMay 01, 2012. In this article, we provide an example of Bing Maps In which we show the traffic in the map with the help of the Ajax Control 7.0 ISDK.
  • Understanding Multilayered Architecture in .NETMay 09, 2012. This article focuses on understanding a basic multilayered architecture in C#.
  • Build Your Deep Zoom MosaicJul 15, 2012. Here you will learn about Deep Zoom which is a layered format of images and is also known as SeaDragon which is now Microsoft Presentation.
  • Command Query Responsibility Separation (CQRS)Jul 26, 2012. CQSR is an architectural pattern which states that while designing the data access layer in a project, it can be split into two separate units of codebase.
  • SharePoint 2010 - Create SSL Enabled SiteAug 16, 2012. As part of development activities we might need to create a SSL enabled site inside SharePoint 2010. These sites will be accessed using HTTPS instead of HTTP.
  • Extend 3 Layer ASP.NET Application to 4 Layer to Achieve Higher Level AbstractionAug 19, 2012. In this article we will understand the meaning of letter N in N-Layer applications and the concept of one of the OOPS pillar Abstraction.
  • CLR Function in SQL Server 2005Aug 27, 2012. In SQL Server 2005 and later version of it, database objects like function, store Procedure, etc can be created which are already created in CLR.
  • Import Adobe Photoshop File in Expression Blend 4Sep 12, 2012. Today we are going to see the use of "Import Adobe Photoshop File Option" of File Menu.
  • jQuery UI Datepicker in MVC 4 IssueOct 28, 2012. Today, I spent couple of hours in finding the best suited fix of this issue. Actually that was a very simple problem and we may fix it by adding another http request layer in the application but that was not a productive choice.
  • How to Use Smarty in PHPJan 09, 2013. Smarty is a Template Engine which separates the Presentation Layer from the Business Layer and provides manageable wait exchange data between the two layers.
  • Create Custom Shapes As Needed in PhotoshopJan 29, 2013. In this article I am going to explain creating Custom Shapes according to your requirement in Photoshop.
  • Data Source ControlsFeb 02, 2013. In this article, we explore the role of Data Source Controls in building web applications.
  • iPhone Operating System ArchitectureFeb 25, 2013. In this article I will explain the iOS Architecture and it's layers.
  • Cocoa Touch Layer in iPhoneMar 08, 2013. In this article I will explain Cocoa Touch layer and it's framework.
  • Core OS Layer in iPhoneMar 12, 2013. In this article I will explain iOS Core OS Layer and it's framework in iPhone.
  • Passport Size Image in PhotoshopApr 01, 2013. In this article you will learn how to make a passport-sized photo in Photoshop.
  • Rain Effect in PhotoshopApr 10, 2013. In this article you will learn how to create a Rain Effect in Photoshop.
  • Learn OSI Network ModelApr 23, 2013. OSI model roughly translated as the reference model of open systems connectivity.
  • Prevent Dead Lock in Entity FrameworkMay 02, 2013. Recently I am working on Entity Framework as data access layer based Project. We found many performance issues with this application.
  • SSL in ASP.Net Web APIJun 27, 2013. In this article you will learn about the SSL (Secure Sockets Layer) in ASP.NET Web API.
  • An Example of URL Rewriting With ASP.NetAug 21, 2013. 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 ClassOct 04, 2013. This article explains how to pass data across layers in a uniform fashion using an entity class.
  • Understand 3-Tier Architecture in C#Oct 04, 2013. In this article we will learn to implement 3- Tier architecture in C#.NET application.
  • Pass Data in Layered Architecture: Part-2: Non Uniform StyleOct 07, 2013. This article explains how to transfer data in a non-uniform fashion.
  • Understand WCF: Part 2: Understand RESTful ServiceOct 13, 2013. This article will clarify a few more concepts related to services and protocols.
  • How to Work With Layers in ASP.Net ProjectNov 24, 2013. This article explains how to make and work with layers in ASP.NET projects.
  • Working With ASP.Net Web Forms in Visual Studio 2013Dec 16, 2013. In this article we will create the Data Access Layer to the ASP.NET Web Forms Application in Visual Studio 2013.
  • Create and Implement 3-Tier Architecture in ASP.NetDec 29, 2013. This article explains how to create and implement a 3-tier architecture for our project in ASP.Net.
  • How ASP.Net Web API WorksJan 04, 2014. This article explains how the Web API works. Here you will see the application layer of the API , the MVC architecture and the Web API architecture.
  • Getting Exact Location of Exception in C# CodeJan 28, 2014. This article is about determining the exact location of an exception in code.

About Layer

NA

SPONSORED BY

C# Corner Chandigarh DevCon16
Chandigarh DevCon16 is a one-day Developer Conference where programmers, technologists, authors, and members meet, demonstrate, plan, and hang out.
Visual Studio Live - Redmond 2016