Abstract Data Access Layer Design

Anwar Ibáñez O'Kamell

Rate me:

4.85/5 (16 votes)

5 Sep 2009CPOL4 min read

72.9K

1.2K

The present document tries to describe the architecture of a specific layer of access to data for relational databases. This document tries to present/display a form to automate tasks of access to data.

demoproject.zip
- DemoProject
  - Test
    - (ClassDiagram1).cd
    - bin
      - Debug
        
        PersistenceFile.xml
        
        Test.exe
        
        Test.vshost.exe
        
        Test.vshost.exe.manifest
        
        XPeriment.Persistence.dll
    - ClaseCliente.cs
    - ClaseCompra.cs
    - ClaseDetalleCompra.cs
    - ClaseProducto.cs
    - Form1.cs
    - Form1.Designer.cs
    - Form1.resx
    - Program.cs
    - Properties
    - Test.csproj
    - Test.csproj.user
  - XPeriment.Architect
    - bin
      - Debug
        
        BizAgi.Architect.vshost.exe
        
        BizAgi.Architect.vshost.exe.manifest
        
        Experiment.Architect.exe
        
        Experiment.Architect.vshost.exe
        
        Experiment.Architect.vshost.exe.manifest
    - FieldData.cs
    - Main.cs
    - Main.Designer.cs
    - Main.resx
    - Program.cs
    - Properties
    - XPeriment.Architect.csproj
  - XPeriment.Management.sln
  - XPeriment.Management.suo
  - XPeriment.Persistence
    - (ClassDiagram).cd
    - app.config
    - bin
      - Debug
        
        PersistenceFile.xml
        
        XPeriment.Persistence.dll
        
        XPeriment.Persistence.dll.config
    - DataAcessTasks
      - (ClassDiagram).cd
      - (ClassDiagram1).cd
      - BaseTask.cs
      - DataTaskPerformer.cs
      - DeleteTask.cs
      - FieldData.cs
      - FieldSetTask.cs
      - FieldValueData.cs
      - InsertTask.cs
      - JoinData.cs
      - PerformerTransaction.cs
      - QueryTask.cs
      - ScriptBuilder.cs
      - SqlServer
        
        SqlPerformerTransaction.cs
        
        SqlTaskPerformer.cs
      - UpdateTask.cs
    - PersistenceFile.xml
    - PersistentObjects
      - (ClassDiagram).cd
      - Attributes
        
        ForaignKey.cs
        
        IgnoreMappingAttribute.cs
        
        ManyToManyListAttribute.cs
        
        MappingFile.cs
        
        MapToAttribute.cs
        
        NullsAllowed.cs
        
        OneToManyListAttribute.cs
      - FieldMapping.cs
      - MappingDirectionTypes.cs
      - ObjectMapping.cs
      - PersistenceCatalog.cs
      - PersistentObject.cs
      - PrimaryKeyAttribute.cs
      - ReflectionUtility.cs
    - Properties
    - Settings.cs
    - XPeriment.Persistence.csproj
    - XPeriment.Persistence.csproj.user


Microsoft Visual Studio Solution File, Format Version 10.00
# Visual Studio 2008
Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "XPeriment.Architect", "XPeriment.Architect\XPeriment.Architect.csproj", "{E561CAEF-A31A-4E73-AE43-978C88A339EF}"
EndProject
Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "XPeriment.Persistence", "XPeriment.Persistence\XPeriment.Persistence.csproj", "{F7A9CCE0-11E0-4A01-A289-4B64ACC61DEB}"
EndProject
Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "Test", "Test\Test.csproj", "{48C63285-3E6B-4A2E-88B3-51EAF3306831}"
EndProject
Global
	GlobalSection(SolutionConfigurationPlatforms) = preSolution
		Debug|Any CPU = Debug|Any CPU
		Release|Any CPU = Release|Any CPU
	EndGlobalSection
	GlobalSection(ProjectConfigurationPlatforms) = postSolution
		{E561CAEF-A31A-4E73-AE43-978C88A339EF}.Debug|Any CPU.ActiveCfg = Debug|Any CPU
		{E561CAEF-A31A-4E73-AE43-978C88A339EF}.Debug|Any CPU.Build.0 = Debug|Any CPU
		{E561CAEF-A31A-4E73-AE43-978C88A339EF}.Release|Any CPU.ActiveCfg = Release|Any CPU
		{E561CAEF-A31A-4E73-AE43-978C88A339EF}.Release|Any CPU.Build.0 = Release|Any CPU
		{F7A9CCE0-11E0-4A01-A289-4B64ACC61DEB}.Debug|Any CPU.ActiveCfg = Debug|Any CPU
		{F7A9CCE0-11E0-4A01-A289-4B64ACC61DEB}.Debug|Any CPU.Build.0 = Debug|Any CPU
		{F7A9CCE0-11E0-4A01-A289-4B64ACC61DEB}.Release|Any CPU.ActiveCfg = Release|Any CPU
		{F7A9CCE0-11E0-4A01-A289-4B64ACC61DEB}.Release|Any CPU.Build.0 = Release|Any CPU
		{48C63285-3E6B-4A2E-88B3-51EAF3306831}.Debug|Any CPU.ActiveCfg = Debug|Any CPU
		{48C63285-3E6B-4A2E-88B3-51EAF3306831}.Debug|Any CPU.Build.0 = Debug|Any CPU
		{48C63285-3E6B-4A2E-88B3-51EAF3306831}.Release|Any CPU.ActiveCfg = Release|Any CPU
		{48C63285-3E6B-4A2E-88B3-51EAF3306831}.Release|Any CPU.Build.0 = Release|Any CPU
	EndGlobalSection
	GlobalSection(SolutionProperties) = preSolution
		HideSolutionNode = FALSE
	EndGlobalSection
EndGlobal

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By

Anwar Ibáñez O'Kamell

Systems Engineer

Colombia

http://www.construirsoftware.blogspot.com/

Abstract Data Access Layer Design

License

Comments and Discussions