Category Archives: 7675

Entity Data Model classes

Entity Framework provides some classes to describe the Entity Data Model. This can be very helpful in many cases and particularly for code generation.   Then, Entity Framework provides a ttinclude file that allows us to use this model instead … Continue reading

Posted in 10511, 16868, 17895, 7674, 7675 | Leave a comment

WAQS: Implement your own identity logic

7 reasons to use WAQS WAQS documentation   Imagine that you don’t have identity key column in your DB and you use your own way to define your DB sequence. So you need an identity logic on the client but … Continue reading

Posted in 16868, 7674, 7675 | Leave a comment

WAQS: Edmx Update Model from Database

7 reasons to use WAQS WAQS documentation   Sometimes, particularly when you want to use many small models, you have to change edmx ssdl (DB description) yourself modifying the xml. The issue with this appends when you want to update … Continue reading

Posted in 16868, 7674, 7675 | Leave a comment

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 … Continue reading

Posted in 10369, 10511, 7671, 7674, 7675 | 1 Comment

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 … Continue reading

Posted in 7671, 7674, 7675 | Leave a comment

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 … Continue reading

Posted in 12253, 7671, 7674, 7675, 9104 | 2 Comments

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 … Continue reading

Posted in 7671, 7674, 7675, 9104 | 4 Comments

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 Types Custom Mapping With SSDL I want to particularly thank … Continue reading

Posted in 7671, 7674, 7675 | Leave a comment

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 … Continue reading

Posted in 7671, 7674, 7675 | Leave a comment

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 … Continue reading

Posted in 12253, 7671, 7674, 7675 | 2 Comments