Headline
Object-Relational mapping with .NET's Entity Framework
Status
Languages
- Language:CSharp (C#): Programming language used for all code (Version 4.0)
Technologies
- Technology:csc.exe: C# compiler (Version 4.0)
- Technology:.NET: Framework used to execute compiled code (Version 4.0)
- Technology:Entity Framework Entity Framework toolkit (Version 3.0)
- Technology:NUnit: Unit testing framework used for testing (Version 2.5.9)
- Technology:SQL Server: SQL Server 2008 used as a data storage. (Free Express edition is enough)
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
*.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.
Backlinks
There are no revisions for this page.
User contributions
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.
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.