Tags Achitecture .Net ADO ADO.NET Data Services ADO.NET Data Services Hooking POC Article dta srs Bug C # EDM EDM Designer Designer v2 Entity Data Model (EDM) Entity Framework (EF) Events LINQ To SQL Linq IL lol MEF metaprogramming MVP Summit NuGet Parallel Framework (PFx) Pattern & Practises PCL PDC Character Quiz PRISM Roslyn Silverlight SQL TDD T4 Tech Ed TFS TPL Unit tests Unity VB Velocity VS W7 WCF WCF Async Queryable Services WCF Data Services WCF RIA Services WF WPF WinForms WP7 XML
During the training I lead this week, one of my interns tried to stick me by giving me a base to which the use of EF was, supposedly, not possible. dta srs Fortunately, my honor and that of the RU except ...
Value is an integer between 1 and 9 can no longer dta srs change once it is assigned and Key is equal to Id * 10 + Value Inheriteds a table with 3 columns: id, int, Indentity (PK) Key, int, not null Text2, dta srs nvarchar
Key is the same as in the table bases and therefore, it was actually a 1 -> 0..1 between bases and Inheriteds although this relationship does not exist in the database. Descriptions of a table with 4 columns: id, int, Identity dta srs (PK) Key, int, not null Language, dta srs Text nchar, nvarchar
CSDL side (description of entities), he wanted to have one class Base asbtraite (mapped Bases) an Entity class that inherits from Base (mapped Inheriteds) a Class Description a 1 -> * between base and Description
How to do this? First, the designer, after importing the tables and have renamed entity type generated, he dupprimer the Id property dta srs of each of them. Then, define Base.Key, Description.Key and Description.Language as EntityKey. dta srs Base Set as abstract Delete Entity.Key Add the inheritance relationship between Entity and Base and update the mapping Entity (ie: you have to map the Key column on the Base.Key property) Add the relationship between base and Description
<Property Name = "Key" type = "int" Nullable = "false" StoreGeneratedPattern = "Computed" />
<PropertyRef Name = "Key" />
UPDATE Bases
SET [Text] =Text
</ CommandText>
</ MappingFragment>
</ ModificationFunctionMapping>
You made me dive in ED ... I struggled at first because I had the base type was anything but ideal ... and with your tickets that put me on the tracks ... I always managed to get what I wanted.
Roll on the weekend lol
I still have a lot of questions about the EF (the opposite would be surprising given the size of the tool ...), it was Julia Lerman we had advised you (I've seen it was a book about the EF O'Reilly)?
acoudeyras Anonymous dta srs comments are disabled Last 10 posted blogs - Paris Tech Days 2015: Malware Blog unchained by the Technical Romelard Fabrice 02-12-2015, 10:58 p.m. - Paris Tech Days 2015: The transformation of SI with the Microsoft Cloud, what will the role of the CIO tomorrow, how cloud MS accompanies this transformer ... by Blog Technical Romelard Fabrizio 02-12-2015, 10:51 p.m. - Paris Tech Days 2015: The social intranet dta srs with Office 365 and Yammer - what possibilities integration? Blog Romelard by Fabrice technique on 02-12-2015, 10:46 p.m. - Paris Tech Days 2015: Plenary Day 3 - Towards a technology invisible and ubiquitous dta srs intelligence? Blog by Romelard Technical Fabrizio 02-12-2015, 10:59 - TechDays Paris 2015: Geek is in da House by {new} Blog Romelard Technical Fabrizio 02-12-2015, 1:13 - Tech Days Paris 2015: Windows Server vNext - Virtualization and Storage Technique Romelard Blog by Fabrizio 02-12-2015, 0:26 - Tech Days Paris 2015: What's new in Windows dta srs 10? Blog Romelard by Fabrice technique on 02-11-2015, 11:37 p.m. - Paris Tech Days 2015: Successful migration to Office 365 by training uilisateurs by Blog Technical Romelard Fabrizio 02-11-2015, 2:32 p.m. - Tech Days Paris 2015: Windows PowerShell 5.0 by 10 and Technical Blog of the Romelard Fabrice 02-11-2015, 1:10 p.m. - Paris Tech Days 2015: Day 2 pleinière - Cloud & Mobile, come as you are! Blog by Romelard Technical Fabrizio 02-11-2015, 10:39
No comments:
Post a Comment