Browse by Tags

All Tags » .Net » Entity Framework (EF) (RSS)
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 | 1 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 | with no comments
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 | 1 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 | with no comments
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, Sep 1 2009 15:34

PFx is good

I am sure that the Parallel Framework (PFx) will take more and more importance in future developments. However, demos often are not in phase with the reality. It’s true that a fractal demo on a 1000 cores machine is ideal for parallel demo, however in...
Posted by Matthieu MEZIL | with no comments
Filed under: , , ,
Tue, Jul 21 2009 16:03

How to have FK in EF v1?

Before answering this question, I will start with another one: why do we need FK? to be able to change a relationship without loading the related entity but we can already do it with the EntityReference property. for the binding With the windows forms...
Posted by Matthieu MEZIL | with no comments
Filed under: , , ,
Mon, Jun 29 2009 18:49

T4 for View Generation

EF team blogged about it here and I think that it’s very useful. First, I think that it’s easier to use than Edmgen. Moreover, contrary to EdmGen, it allows you to use embedded metadata artifacts. If you want to use the MS T4 template with...
Posted by Matthieu MEZIL | with no comments
Filed under: , ,
Fri, Jun 26 2009 3:23

POCO T4

With EF4 features CTP1, we have a great POCO template which is divided in two tt files to allow us to have the entitiy POCO classes and the context in different projects. It’s very very cool. However, I think that it’s a shame not to have...
Posted by Matthieu MEZIL | with no comments
Filed under: , , ,
Tue, Jun 16 2009 12:22

SubObjectSet

With EF, when you use TPH or TPC inheritance mapping scenarii, the EntitySet is on the base class. As I mentioned often in the past with EF v1, you can add a property in your context which returns the EntitySet.OfType<MySubType>(). Ok it’s...
Posted by Matthieu MEZIL | with no comments
Filed under: ,
Fri, Jun 12 2009 20:26

Entity Framework v2: How to get only one entity easier with EF4

Alex James wrote an extension method which allows to get only one entity from a query and the entity key . If we have the key, I think it’s useless to allow it for all queries and it’s useful only for EntitySet. With EF4, this extension method...
Posted by Matthieu MEZIL | 1 comment(s)
Filed under: ,
Wed, Jun 10 2009 2:12

Entity Framework: Undo Redo v2

After my first Undo Redo POC version , one of my customers wanted to be able to manage many actions per Undo / Redo. So I added two extension methods: BeginGroupOfUndoActions and EndGroupOfUndoActions. My code is now this one: public static class ObjectContextExtension...
Posted by Matthieu MEZIL | 8 comment(s)
Filed under: ,
Mon, Jun 8 2009 17:57

EF : Undo Redo

How to use Undo/Redo with EntityFramework? This isn’t managed by EF. So we will have to do it ourselves. We could clone the entities and group them into a Stack but in this case I worry about my memory usage growing too much. So I prefer another...
Posted by Matthieu MEZIL | 2 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 | 1 comment(s)
Filed under: , ,
Mon, May 25 2009 15:54

EF4 POCO: my tests

I published an unit tests project to show how POCO works with EF4 . I also wrote a BetaBugs test class in order to illustrate the POCO implementation Beta bugs.
Posted by Matthieu MEZIL | with no comments
Filed under: , ,
More Posts Next page »