Building an Agile SQL Data Access Layer

Giorgio Bozio

Rate me:

4.80/5 (5 votes)

6 Jan 2009CPOL4 min read

51.1K

646

An article on building a SQL Server data access layer in C# in a completely separate layer.

sqldalcode.zip
- SqlDalCode
  - InMemoryDal.BusinessLogic
    - bin
      - Debug
        
        InMemoryDal.BusinessLogic.dll
        
        InMemoryDal.BusinessLogic.pdb
        
        InMemoryDal.Entities.dll
        
        InMemoryDal.Entities.pdb
        
        InMemoryDal.Helpers.dll
        
        InMemoryDal.Helpers.pdb
        
        InMemoryDal.InMemoryData.dll
        
        InMemoryDal.InMemoryData.pdb
        
        InMemoryDal.Interfaces.dll
        
        InMemoryDal.Interfaces.pdb
        
        NLog.dll
        
        NLog.xml
        
        SqlData.dll
        
        SqlData.pdb
    - CustomerLogic.cs
    - InMemoryDal.BusinessLogic.csproj
    - OrderItemLogic.cs
    - OrderLogic.cs
    - ProductLogic.cs
    - Properties
      - AssemblyInfo.cs
  - InMemoryDal.Entities
    - bin
      - Debug
        
        InMemoryDal.Entities.dll
        
        InMemoryDal.Entities.pdb
    - ClassDiagram1.cd
    - Customer.cs
    - Entities.cd
    - EntityAttributes.cs
    - InMemoryDal.Entities.csproj
    - Order.cs
    - OrderItem.cs
    - Product.cs
    - Properties
      - AssemblyInfo.cs
  - InMemoryDal.Helpers
    - bin
      - Debug
        
        InMemoryDal.Entities.dll
        
        InMemoryDal.Entities.pdb
        
        InMemoryDal.Helpers.dll
        
        InMemoryDal.Helpers.pdb
        
        InMemoryDal.InMemoryData.dll
        
        InMemoryDal.InMemoryData.pdb
        
        InMemoryDal.Interfaces.dll
        
        InMemoryDal.Interfaces.pdb
        
        SqlData.dll
        
        SqlData.pdb
    - GBDipendencyInjection.cs
    - InMemoryDal.Helpers.csproj
    - Properties
      - AssemblyInfo.cs
  - InMemoryDal.InMemoryData
    - bin
      - Debug
        
        InMemoryDal.Entities.dll
        
        InMemoryDal.Entities.pdb
        
        InMemoryDal.InMemoryData.dll
        
        InMemoryDal.InMemoryData.pdb
        
        InMemoryDal.Interfaces.dll
        
        InMemoryDal.Interfaces.pdb
    - CustomerInMemoryDAL.cs
    - InMemoryDal.InMemoryData.csproj
    - InMemoryOrderSession.cs
    - InMemoryTransaction.cs
    - OrderInMemoryDAL.cs
    - OrderItemInMemoryDAL.cs
    - ProductInMemoryDAL.cs
    - Properties
      - AssemblyInfo.cs
  - InMemoryDal.Interfaces
    - bin
      - Debug
        
        InMemoryDal.Entities.dll
        
        InMemoryDal.Entities.pdb
        
        InMemoryDal.Interfaces.dll
        
        InMemoryDal.Interfaces.pdb
    - ICustomerDAL.cs
    - InMemoryDal.Interfaces.csproj
    - Interfaces.cd
    - IOrderDAL.cs
    - IOrderItemDAL.cs
    - IOrdersSession.cs
    - IProductDAL.cs
    - Properties
      - AssemblyInfo.cs
  - InMemoryDal.sln
  - InMemoryDal.SqlData
    - bin
      - Debug
        
        InMemoryDal.Entities.dll
        
        InMemoryDal.Entities.pdb
        
        InMemoryDal.Interfaces.dll
        
        InMemoryDal.Interfaces.pdb
        
        SqlData.dll
        
        SqlData.pdb
    - DBGet.cs
    - InMemoryDal.SqlData.csproj
    - InMemoryDal.SqlData.csproj.user
    - Properties
      - AssemblyInfo.cs
    - SqlOrderDAL.cs
    - SqlOrdersSession.cs
  - InMemoryDal.Tests
    - AuthoringTests.txt
    - bin
      - Debug
        
        InMemoryDal.BusinessLogic.dll
        
        InMemoryDal.BusinessLogic.pdb
        
        InMemoryDal.BusinessLogic_Accessor.dll
        
        InMemoryDal.BusinessLogic_Accessor.pdb
        
        InMemoryDal.Entities.dll
        
        InMemoryDal.Entities.pdb
        
        InMemoryDal.Helpers.dll
        
        InMemoryDal.Helpers.pdb
        
        InMemoryDal.InMemoryData.dll
        
        InMemoryDal.InMemoryData.pdb
        
        InMemoryDal.Interfaces.dll
        
        InMemoryDal.Interfaces.pdb
        
        InMemoryDal.Tests.dll
        
        InMemoryDal.Tests.pdb
        
        NLog.dll
        
        NLog.xml
        
        SqlData.dll
        
        SqlData.pdb
    - CustomerLogicTest.cs
    - InMemoryDal.Tests.csproj
    - OrderLogicTest.cs
    - Properties
      - AssemblyInfo.cs
    - Test References
      - InMemoryDal.BusinessLogic.accessor
  - InMemoryDal.vsmdi
  - InMemoryDal1.vsmdi
  - InMemoryDal2.vsmdi
  - LocalTestRun.testrunconfig
  - TestResults


Microsoft Visual Studio Solution File, Format Version 10.00
# Visual Studio 2008
Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "InMemoryDal.InMemoryData", "InMemoryDal.InMemoryData\InMemoryDal.InMemoryData.csproj", "{62F1D591-2D97-443B-8908-22A175765078}"
EndProject
Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "InMemoryDal.Interfaces", "InMemoryDal.Interfaces\InMemoryDal.Interfaces.csproj", "{2DD78B53-D866-469C-A24C-F964080CB2FE}"
EndProject
Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "InMemoryDal.Helpers", "InMemoryDal.Helpers\InMemoryDal.Helpers.csproj", "{53E6ED70-4808-4833-ACD5-32FB6FFEABA9}"
EndProject
Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "InMemoryDal.Entities", "InMemoryDal.Entities\InMemoryDal.Entities.csproj", "{41F094B4-E01E-4F3A-A333-27D007FAE97C}"
EndProject
Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "InMemoryDal.BusinessLogic", "InMemoryDal.BusinessLogic\InMemoryDal.BusinessLogic.csproj", "{87CEABFA-0F4D-4A0D-9E44-6DAF8FE1FC3C}"
EndProject
Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "InMemoryDal.Tests", "InMemoryDal.Tests\InMemoryDal.Tests.csproj", "{966C71A5-E8BD-4855-A350-EC9F7FCD188C}"
EndProject
Project("{2150E333-8FDC-42A3-9474-1A3956D46DE8}") = "Solution Items", "Solution Items", "{52124342-D9A8-4DFF-9E1C-8F621D789CF1}"
	ProjectSection(SolutionItems) = preProject
		InMemoryDal.vsmdi = InMemoryDal.vsmdi
		InMemoryDal1.vsmdi = InMemoryDal1.vsmdi
		InMemoryDal2.vsmdi = InMemoryDal2.vsmdi
		LocalTestRun.testrunconfig = LocalTestRun.testrunconfig
	EndProjectSection
EndProject
Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "InMemoryDal.SqlData", "InMemoryDal.SqlData\InMemoryDal.SqlData.csproj", "{F97527BE-7FB7-4275-BD9E-96E411B9CAD4}"
EndProject
Global
	GlobalSection(TestCaseManagementSettings) = postSolution
		CategoryFile = InMemoryDal2.vsmdi
	EndGlobalSection
	GlobalSection(SolutionConfigurationPlatforms) = preSolution
		Debug|Any CPU = Debug|Any CPU
		Release|Any CPU = Release|Any CPU
	EndGlobalSection
	GlobalSection(ProjectConfigurationPlatforms) = postSolution
		{62F1D591-2D97-443B-8908-22A175765078}.Debug|Any CPU.ActiveCfg = Debug|Any CPU
		{62F1D591-2D97-443B-8908-22A175765078}.Debug|Any CPU.Build.0 = Debug|Any CPU
		{62F1D591-2D97-443B-8908-22A175765078}.Release|Any CPU.ActiveCfg = Release|Any CPU
		{62F1D591-2D97-443B-8908-22A175765078}.Release|Any CPU.Build.0 = Release|Any CPU
		{2DD78B53-D866-469C-A24C-F964080CB2FE}.Debug|Any CPU.ActiveCfg = Debug|Any CPU
		{2DD78B53-D866-469C-A24C-F964080CB2FE}.Debug|Any CPU.Build.0 = Debug|Any CPU
		{2DD78B53-D866-469C-A24C-F964080CB2FE}.Release|Any CPU.ActiveCfg = Release|Any CPU
		{2DD78B53-D866-469C-A24C-F964080CB2FE}.Release|Any CPU.Build.0 = Release|Any CPU
		{53E6ED70-4808-4833-ACD5-32FB6FFEABA9}.Debug|Any CPU.ActiveCfg = Debug|Any CPU
		{53E6ED70-4808-4833-ACD5-32FB6FFEABA9}.Debug|Any CPU.Build.0 = Debug|Any CPU
		{53E6ED70-4808-4833-ACD5-32FB6FFEABA9}.Release|Any CPU.ActiveCfg = Release|Any CPU
		{53E6ED70-4808-4833-ACD5-32FB6FFEABA9}.Release|Any CPU.Build.0 = Release|Any CPU
		{41F094B4-E01E-4F3A-A333-27D007FAE97C}.Debug|Any CPU.ActiveCfg = Debug|Any CPU
		{41F094B4-E01E-4F3A-A333-27D007FAE97C}.Debug|Any CPU.Build.0 = Debug|Any CPU
		{41F094B4-E01E-4F3A-A333-27D007FAE97C}.Release|Any CPU.ActiveCfg = Release|Any CPU
		{41F094B4-E01E-4F3A-A333-27D007FAE97C}.Release|Any CPU.Build.0 = Release|Any CPU
		{87CEABFA-0F4D-4A0D-9E44-6DAF8FE1FC3C}.Debug|Any CPU.ActiveCfg = Debug|Any CPU
		{87CEABFA-0F4D-4A0D-9E44-6DAF8FE1FC3C}.Debug|Any CPU.Build.0 = Debug|Any CPU
		{87CEABFA-0F4D-4A0D-9E44-6DAF8FE1FC3C}.Release|Any CPU.ActiveCfg = Release|Any CPU
		{87CEABFA-0F4D-4A0D-9E44-6DAF8FE1FC3C}.Release|Any CPU.Build.0 = Release|Any CPU
		{966C71A5-E8BD-4855-A350-EC9F7FCD188C}.Debug|Any CPU.ActiveCfg = Debug|Any CPU
		{966C71A5-E8BD-4855-A350-EC9F7FCD188C}.Debug|Any CPU.Build.0 = Debug|Any CPU
		{966C71A5-E8BD-4855-A350-EC9F7FCD188C}.Release|Any CPU.ActiveCfg = Release|Any CPU
		{966C71A5-E8BD-4855-A350-EC9F7FCD188C}.Release|Any CPU.Build.0 = Release|Any CPU
		{F97527BE-7FB7-4275-BD9E-96E411B9CAD4}.Debug|Any CPU.ActiveCfg = Debug|Any CPU
		{F97527BE-7FB7-4275-BD9E-96E411B9CAD4}.Debug|Any CPU.Build.0 = Debug|Any CPU
		{F97527BE-7FB7-4275-BD9E-96E411B9CAD4}.Release|Any CPU.ActiveCfg = Release|Any CPU
		{F97527BE-7FB7-4275-BD9E-96E411B9CAD4}.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

Giorgio Bozio

Italy

Software architect. At present working on C# development, with mainly Asp.net Ajax and MVC user inteface. Particularly interested in OOP, test driven, agile development.

Building an Agile SQL Data Access Layer

License

Comments and Discussions