Headline

Object-Relational mapping with .NET's Entity Framework

Status

101status:Featured

Languages

Technologies

Features

Motivation

Entity Framework object model is generated for SQL Server representation of 101companies model. We use LINQ queries over entities to implement Feature:Total, Feature:Cut and Feature:Depth features by showing different types of data tranformations happening on the database level. These transformations (SQL statements) are generated by Technology:Entity Framework using O/R Mapping metadata stored in Language:XML file, which was also automatically generated from the database 101companies model representation.

Architecture

CompanyModel.edmx represents all Entity Framework artifacts required for O/R Mapping. This is an XML file contains:

  • SSDL content
  • CSDL content
  • C-S mapping content
  • EF Designer content
and also a *.cs file with C# objects.

*.edmx files are visualized in Entity Data Model Designer by default, but also can be opened as raw xml files. The Entity Data Model Designer (Entity Designer) stores storage model information in an .edmx file at design time. At build time the Entity Designer uses information in an .edmx file to create the .ssdl file that is needed by the Entity Framework at runtime.


Tests folder contains unit tests showing implemented features.

Usage

Contribution:sqlServer should be evaluated as soon as current implementation requires Feature:Hierarchical company to be created in the database.

Technology:Visual Studio 2010 should be used to open a project file. The project itself is a class-library and compiles into a DLL. To run a project you must execute at least one unit test (or all at once). Nunit GUI or other Visual studio extension (e.g. Resharper) should be used for executing unit tests.

Metadata


There are no revisions for this page.

User contributions

    This user never has never made submissions.

    User edits

    Syntax for editing wiki

    For you are available next options:

    will make text bold.

    will make text italic.

    will make text underlined.

    will make text striked.

    will allow you to paste code headline into the page.

    will allow you to link into the page.

    will allow you to paste code with syntax highlight into the page. You will need to define used programming language.

    will allow you to paste image into the page.

    is list with bullets.

    is list with numbers.

    will allow your to insert slideshare presentation into the page. You need to copy link to presentation and insert it as parameter in this tag.

    will allow your to insert youtube video into the page. You need to copy link to youtube page with video and insert it as parameter in this tag.

    will allow your to insert code snippets from @worker.

    10 most similar pages:

    Syntax for editing wiki

    For you are available next options:

    will make text bold.

    will make text italic.

    will make text underlined.

    will make text striked.

    will allow you to paste code headline into the page.

    will allow you to link into the page.

    will allow you to paste code with syntax highlight into the page. You will need to define used programming language.

    will allow you to paste image into the page.

    is list with bullets.

    is list with numbers.

    will allow your to insert slideshare presentation into the page. You need to copy link to presentation and insert it as parameter in this tag.

    will allow your to insert youtube video into the page. You need to copy link to youtube page with video and insert it as parameter in this tag.

    will allow your to insert code snippets from @worker.