ADO.NET Entity Framework as Data Access Layer

sarvesh.upadhyay

Rate me:

4.19/5 (12 votes)

30 Oct 2009Public Domain2 min read

106.3K

4.3K

ADO.NET Entity Framework as Data Access Layer

dataaccesslayer.zip
- DataAccessLayer
  - App.Config
  - bin
    - Debug
  - CustomerDbOperation.cs
  - DataAccessLayer.csproj
  - DataAccessLayerTestProject
    - App.config
    - AuthoringTests.txt
    - bin
      - Debug
    - CustomerDbOperationTest.cs
    - DataAccessLayerTestProject.csproj
    - Properties
      - AssemblyInfo.cs
  - IDatabaseOperation.cs
  - LocalTestRun.testrunconfig
  - Properties
    - AssemblyInfo.cs
  - TestModel.Designer.cs
  - TestModel.edmx
  - TestResults
    - Sarvesh_HOME 2009-10-28 23_49_27.trx
    - Sarvesh_HOME 2009-10-28 23_49_27
      - Out
        
        DataAccessLayer.dll
        
        DataAccessLayer.pdb
        
        dataaccesslayertestproject.dll
        
        dataaccesslayertestproject.dll.config
        
        DataAccessLayerTestProject.pdb
    - Sarvesh_HOME 2009-10-29 07_57_49.trx
    - Sarvesh_HOME 2009-10-29 07_57_49
      - Out
        
        DataAccessLayer.dll
        
        DataAccessLayer.pdb
        
        dataaccesslayertestproject.dll
        
        dataaccesslayertestproject.dll.config
        
        DataAccessLayerTestProject.pdb
    - Sarvesh_HOME 2009-10-29 08_35_04.trx
    - Sarvesh_HOME 2009-10-29 08_35_04
      - Out
        
        DataAccessLayer.dll
        
        DataAccessLayer.pdb
        
        dataaccesslayertestproject.dll
        
        dataaccesslayertestproject.dll.config
        
        DataAccessLayerTestProject.pdb
    - Sarvesh_HOME 2009-10-29 08_40_21.trx
    - Sarvesh_HOME 2009-10-29 08_40_21
      - Out
        
        DataAccessLayer.dll
        
        DataAccessLayer.pdb
        
        dataaccesslayertestproject.dll
        
        dataaccesslayertestproject.dll.config
        
        DataAccessLayerTestProject.pdb
    - Sarvesh_HOME 2009-10-29 08_42_11.trx
    - Sarvesh_HOME 2009-10-29 08_42_11
      - Out
        
        DataAccessLayer.dll
        
        DataAccessLayer.pdb
        
        dataaccesslayertestproject.dll
        
        dataaccesslayertestproject.dll.config
        
        DataAccessLayerTestProject.pdb
    - Sarvesh_HOME 2009-10-29 08_42_32.trx
    - Sarvesh_HOME 2009-10-29 08_42_32
      - Out
        
        DataAccessLayer.dll
        
        DataAccessLayer.pdb
        
        dataaccesslayertestproject.dll
        
        dataaccesslayertestproject.dll.config
        
        DataAccessLayerTestProject.pdb
    - Sarvesh_HOME 2009-10-29 09_07_25.trx
    - Sarvesh_HOME 2009-10-29 09_07_25
      - Out
        
        DataAccessLayer.dll
        
        DataAccessLayer.pdb
        
        dataaccesslayertestproject.dll
        
        dataaccesslayertestproject.dll.config
        
        DataAccessLayerTestProject.pdb
    - Sarvesh_HOME 2009-10-29 09_07_58.trx
    - Sarvesh_HOME 2009-10-29 09_07_58
      - Out
        
        DataAccessLayer.dll
        
        DataAccessLayer.pdb
        
        dataaccesslayertestproject.dll
        
        dataaccesslayertestproject.dll.config
        
        DataAccessLayerTestProject.pdb
    - Sarvesh_HOME 2009-10-29 09_08_43.trx
    - Sarvesh_HOME 2009-10-29 09_08_43
      - Out
        
        DataAccessLayer.dll
        
        DataAccessLayer.pdb
        
        dataaccesslayertestproject.dll
        
        dataaccesslayertestproject.dll.config
        
        DataAccessLayerTestProject.pdb
    - Sarvesh_HOME 2009-10-29 09_09_25.trx
    - Sarvesh_HOME 2009-10-29 09_09_25
      - In
        
        HOME
      - Out
        
        DataAccessLayer.dll
        
        DataAccessLayer.pdb
        
        dataaccesslayertestproject.dll
        
        dataaccesslayertestproject.dll.config
        
        DataAccessLayerTestProject.pdb
    - Sarvesh_HOME 2009-10-29 09_14_55.trx
    - Sarvesh_HOME 2009-10-29 09_14_55
      - Out
        
        DataAccessLayer.dll
        
        DataAccessLayer.pdb
        
        dataaccesslayertestproject.dll
        
        dataaccesslayertestproject.dll.config
        
        DataAccessLayerTestProject.pdb
    - Sarvesh_HOME 2009-10-29 09_22_35.trx
    - Sarvesh_HOME 2009-10-29 09_22_35
      - Out
        
        DataAccessLayer.dll
        
        DataAccessLayer.pdb
        
        dataaccesslayertestproject.dll
        
        dataaccesslayertestproject.dll.config
        
        DataAccessLayerTestProject.pdb
    - Sarvesh_HOME 2009-10-29 09_46_03.trx
    - Sarvesh_HOME 2009-10-29 09_46_03
      - Out
        
        DataAccessLayer.dll
        
        DataAccessLayer.pdb
        
        dataaccesslayertestproject.dll
        
        dataaccesslayertestproject.dll.config
        
        DataAccessLayerTestProject.pdb
    - Sarvesh_HOME 2009-10-29 09_48_41.trx
    - Sarvesh_HOME 2009-10-29 09_48_41
      - Out
        
        DataAccessLayer.dll
        
        DataAccessLayer.pdb
        
        dataaccesslayertestproject.dll
        
        dataaccesslayertestproject.dll.config
        
        DataAccessLayerTestProject.pdb
    - Sarvesh_HOME 2009-10-29 09_48_58.trx
    - Sarvesh_HOME 2009-10-29 09_48_58
      - Out
        
        DataAccessLayer.dll
        
        DataAccessLayer.pdb
        
        dataaccesslayertestproject.dll
        
        dataaccesslayertestproject.dll.config
        
        DataAccessLayerTestProject.pdb
    - Sarvesh_HOME 2009-10-29 09_49_05.trx
    - Sarvesh_HOME 2009-10-29 09_49_05
      - Out
        
        DataAccessLayer.dll
        
        DataAccessLayer.pdb
        
        dataaccesslayertestproject.dll
        
        dataaccesslayertestproject.dll.config
        
        DataAccessLayerTestProject.pdb
    - Sarvesh_HOME 2009-10-29 09_49_38.trx
    - Sarvesh_HOME 2009-10-29 09_49_38
      - Out
        
        DataAccessLayer.dll
        
        DataAccessLayer.pdb
        
        dataaccesslayertestproject.dll
        
        dataaccesslayertestproject.dll.config
        
        DataAccessLayerTestProject.pdb
    - Sarvesh_HOME 2009-10-29 09_57_25.trx
    - Sarvesh_HOME 2009-10-29 09_57_25
      - Out
        
        DataAccessLayer.dll
        
        DataAccessLayer.pdb
        
        dataaccesslayertestproject.dll
        
        dataaccesslayertestproject.dll.config
        
        DataAccessLayerTestProject.pdb
    - Sarvesh_HOME 2009-10-29 10_03_07.trx
    - Sarvesh_HOME 2009-10-29 10_03_07
      - Out
        
        DataAccessLayer.dll
        
        DataAccessLayer.pdb
        
        dataaccesslayertestproject.dll
        
        dataaccesslayertestproject.dll.config
        
        DataAccessLayerTestProject.pdb
    - Sarvesh_HOME 2009-10-29 10_03_31.trx
    - Sarvesh_HOME 2009-10-29 10_03_31
      - Out
        
        DataAccessLayer.dll
        
        DataAccessLayer.pdb
        
        dataaccesslayertestproject.dll
        
        dataaccesslayertestproject.dll.config
        
        DataAccessLayerTestProject.pdb
    - Sarvesh_HOME 2009-10-29 10_04_15.trx
    - Sarvesh_HOME 2009-10-29 10_04_15
      - Out
        
        DataAccessLayer.dll
        
        DataAccessLayer.pdb
        
        dataaccesslayertestproject.dll
        
        dataaccesslayertestproject.dll.config
        
        DataAccessLayerTestProject.pdb
    - Sarvesh_HOME 2009-10-29 10_04_56.trx
    - Sarvesh_HOME 2009-10-29 10_04_56
      - Out
        
        DataAccessLayer.dll
        
        DataAccessLayer.pdb
        
        dataaccesslayertestproject.dll
        
        dataaccesslayertestproject.dll.config
        
        DataAccessLayerTestProject.pdb
    - Sarvesh_HOME 2009-10-29 10_06_14.trx
    - Sarvesh_HOME 2009-10-29 10_06_14
      - Out
        
        DataAccessLayer.dll
        
        DataAccessLayer.pdb
        
        dataaccesslayertestproject.dll
        
        dataaccesslayertestproject.dll.config
        
        DataAccessLayerTestProject.pdb
    - Sarvesh_HOME 2009-10-29 10_07_36.trx
    - Sarvesh_HOME 2009-10-29 10_07_36
      - Out
        
        DataAccessLayer.dll
        
        DataAccessLayer.pdb
        
        dataaccesslayertestproject.dll
        
        dataaccesslayertestproject.dll.config
        
        DataAccessLayerTestProject.pdb
    - Sarvesh_HOME 2009-10-29 10_07_50.trx
    - Sarvesh_HOME 2009-10-29 10_07_50
      - Out
        
        DataAccessLayer.dll
        
        DataAccessLayer.pdb
        
        dataaccesslayertestproject.dll
        
        dataaccesslayertestproject.dll.config
        
        DataAccessLayerTestProject.pdb
  - WCFADOEF.sln
  - WCFADOEF.suo
  - WCFADOEF.vsmdi
- databaseScript
  - testScript.sql
- imgs
  - pic1.JPG
  - pic2.JPG
  - pic3.JPG
  - pic4.JPG
  - pic5.JPG
  - pic6.JPG
  - Thumbs.db

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
  <connectionStrings>
    <add name="TestEntities" connectionString="metadata=res://*/TestModel.csdl|res://*/TestModel.ssdl|res://*/TestModel.msl;provider=System.Data.SqlClient;provider connection string=&quot;Data Source=home;Initial Catalog=Test;Integrated Security=True;MultipleActiveResultSets=True&quot;" providerName="System.Data.EntityClient" />
  </connectionStrings>
</configuration>

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 A Public Domain dedication

Written By

sarvesh.upadhyay

Architect

India

Sarvesh Upadhyay is Technical Architect in Microsoft Technologies with 12 yrs of hands on experience on various domain like CRM, CMS, Inventory Management System, Telecome Billing, E-Commerce application, Retail etc.
He has indepth knowledge on Design Patterns, Asp.Net MVC, MVP , C#, JavaScript, Knockout, MS-SQL Server,Web Services,Web API, MSMQ, Saleslogix CRM, etc.

ADO.NET Entity Framework as Data Access Layer

License

Comments and Discussions