Browse by Tags

All Tags » Entity Data Model (EDM) (RSS)
Sat, Nov 27 2010 2:38

Generate your WCF Service from your edmx using T4

One year ago, I wrote T4 templates in order to generate WCF Service from edmx using T4. I presented it in last MS France TechDays and MVP Summit. However, I didn’t take time to think about what I wanted to do with it. Moreover, I wrote them with the EF...
Posted by Matthieu MEZIL | with no comments
Filed under: , , , ,
Wed, Sep 8 2010 11:37

EDM mapping: How to use Horizontal Entity Splitting

One of the reasons why I love so much Entity Framework is the mapping. Many developers ignore how powerful EF mapping is. I just remind them that I realized some videos on it . Some scenarios are often very useful but some are less frequent. Horizontal...
Posted by Matthieu MEZIL | with no comments
Filed under: , ,
Wed, Jun 16 2010 17:51

How to include recursion / table valued functions in LINQ To Entities queries with EF4?

In this post, we use Northwind DB with this EDM:   I want to get all orders for an employee or his sub-employees in only one T-SQL query. Recursion with T-SQL => CTE. The problem is the fact that EF4 doesn’t support recursion. I found an interesting...
Posted by Matthieu MEZIL | 3 comment(s)
Filed under: , , , ,
Fri, May 21 2010 11:31

Bulk Delete v3

In my last two posts ( Bulk Delete with EF4 and Bulk Delete only for loaded entities ), I showed you how to do Bulk delete with EF4. However, there are some issues that I will try to fix with this new post: Frans explained me that my solution was very...
Posted by Matthieu MEZIL | 5 comment(s)
Filed under: , , ,
Mon, May 3 2010 13:32

EDM videos

I’m very happy to announce you the publication of 5 videos I made on http://msdn.microsoft.com/en-us/data/videos.aspx . Conceptual, Storage, and Mapping Layers and Their Relationships Inheritance Mapping Scenarios Splitting Scenarios Modeling Complex...
Posted by Matthieu MEZIL | with no comments
Filed under: , ,
Thu, Mar 18 2010 17:54

How to map a View on a collection of Complex Type?

With EF, when we want to use views, we have to map them on Entity Type. The problem is the fact that Entity Type must have a key. In EF, we have Complex Type which doesn’t have Entity Key but we can’t map views on Complex Type. However, with EF4, we can...
Posted by Matthieu MEZIL | with no comments
Filed under: , ,
Sun, Mar 14 2010 0:33

CSDL Function

In my previous post (in French) , I used a CSDL Function in order to have a DateDiff using the DB current date from the LINQ To Entities query. In this post , I want to calculate the OrderDetail amount with: ( double )od.Quantity * ( double )od.UnitPrice...
Posted by Matthieu MEZIL | 2 comment(s)
Filed under: , , ,
Mon, Dec 21 2009 18:00

Self-Tracking entities: How to reduce exchange between client and server?

Self-Tracking entities are really great for N-Tiers scenarios but we have to be careful in order to reduce exchange between client and server. Imagine the following EDM: and the following scenario: using ( var context = new NorthwindClientContext ())...
Posted by Matthieu MEZIL | 4 comment(s)
Filed under: , , ,
Sat, Dec 12 2009 18:56

EF and N-Tiers

Even if it’s really easier with Self-Tracking entities and EF4, a difficult point remains in N-Tiers scenarios. In a previous post , I explained how with T4, I can generate all my WCF service. Now, what about the client tiers? I explained how can I use...
Posted by Matthieu MEZIL | 5 comment(s)
Filed under: , , ,
Tue, Nov 24 2009 18:17

Data oriented WCF service Agile with EF4 and a “sort of” provider LINQ

I use a different approach than Julie’s one for EF Agile development. Indeed, I use here Self-Tracking Entities and I massively use T4. The first step is to create a project DAL in which we will add an edmx. In my sample, I use Northwind DataBase with...
Posted by Matthieu MEZIL | 5 comment(s)
Filed under: , , , , , ,
Sat, Nov 21 2009 9:42

4 in 1: EF won’t fire DBAs, Velocity, SQL CLR and SQL Dependency

Imagine that we have a table Cars with a PK Id (nvarchar(8)) based on the following regex pattern [1-9][0-9]{1,2}[A-Z]{2,3}[0-9]{2}. The last two numbers are a region code. The increasement is done like this: 10AA[region], 11AA[region], …, 999AA[region...
Posted by Matthieu MEZIL | with no comments
Filed under: , , , , ,
Wed, Nov 4 2009 17:40

ADO.NET Data Services Client context

One of the great points with EF is the eco-system around it. Even if it can be used without EF, I think that ADO .NET Data Services is one of the technologies in this eco-system. Indeed, using ADO.NET Data Services with EF implies almost no code to write...
Posted by Matthieu MEZIL | 1 comment(s)
Filed under: , , , ,
Mon, Oct 26 2009 18:13

Generate a WCF service from an edmx with T4 v2

I recently published a T4 template to generate a WCF service . I updated it to be able to load its relationships from an entity . When the template is written (what I’ve already done), it generates the WCF service for us (you just have to set the...
Posted by Matthieu MEZIL | with no comments
Filed under: , , ,
Tue, Oct 20 2009 8:39

Entity Framework: the productivity way

One of the best points with Entity Framework is the developer productivity gain. If you associate EF with the T4 template code generation, this gain explodes. Imagine that we want a WCF service which exposes some data. For each entity type, you probably...
Posted by Matthieu MEZIL | 3 comment(s)
Filed under: , , , ,
Wed, Oct 7 2009 0:10

EF: Include with where clause

Several guys ask me if it’s possible to add a condition in the Include method and the answer is no. However you can do an equivalent like this: from cWithP in     ( from c in context.Categories      select new     ...
Posted by Matthieu MEZIL | 4 comment(s)
Filed under: , ,
Sat, Sep 26 2009 13:17

I need you!

I submitted one Birds of Feather session for the next Tech Ed in Berlin. My session submission depends on your votes . I think that you will find by yourselves which is my session Thanks by advance for your votes
Posted by Matthieu MEZIL | with no comments
Filed under: , , ,
Wed, Sep 2 2009 15:49

ADO.NET EntityObject Generator: how to get the EntityType’s EntitySet and how to get EntitySet’s EntityTypes?

One of my customers wanted to know how to get all EntityTypes for an EntitySet in his T4 template based on the MS ADO.NET EntityObject Generator one. So I made a POC for him. What do I do? I change two classes included in the template (my changes are...
Posted by Matthieu MEZIL | 5 comment(s)
Filed under: , , ,
Tue, Jun 2 2009 16:10

How to split your EDM v2?

After my previous post about it , my customer asks me the following question: how to get a complete graph (with categories, suppliers, products, order details, orders, customers and employees)? To realize it, we have to add “sort of” navigation...
Posted by Matthieu MEZIL | with no comments
Filed under: , ,
Fri, May 29 2009 8:44

ValidateOnBuild

The VS 2008 SP1 EDM designer doesn’t support all the mapping scenarii: Complex Types (supported with VS 2010 Beta 1) TPC Horizontal Entity Splitting I know another (free) designer which does . The most irritating thing with VS 2008 EDM designer (it isn...
Posted by Matthieu MEZIL | with no comments
Filed under: , ,
Wed, May 27 2009 3:46

How to split your EDM?

One of my customers wants to code an ERP. To make it, he wants to use EF. His DB has more than 600 tables with a lot of relationships between all of them. The problem is the fact that Entity Framework has some difficulties with big models. You should...
Posted by Matthieu MEZIL | 2 comment(s)
Filed under: , ,
More Posts Next page »