Generating Interfaces from entity framework database first auto-generated code

Question

I am using MVC3, C# 4.0 and Entity Framework in Visual Studio 2010. I am generating my edmx and Designed.cs files from a database. I am then generating interfaces from the entities in the Designer.cs file as part of my nLayer structure.

The original code is

public partial class DataEntrySummary : EntityObject

which then becomes

public partial class DataEntrySummary : EntityObject, Mb.Interface.IDataEntrySummary

My concern is that when the database changes (and it will) and I regenerate the edmx files I will lose all the interface definitions.

Is there a better way of achieving the same result without having to regenerate the interfaces.

Thank you

Eranga · Accepted Answer · 2012-09-10 09:42:54Z

20

EF generates the classes with the partial keyword so that you can add extra functionality to the entities by creating another file and place the interface specific stuff there.

public partial class DataEntrySummary : Mb.Interface.IDataEntrySummary
{
}

These files will not get affected when EF updates the model.

answered Sep 10, 2012 at 9:42

Eranga

32.5k5 gold badges100 silver badges98 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

JDandChips Over a year ago

Nice, I completely scanned over the partial keyword and didn't even realise ...

Believe2014 · Accepted Answer · 2014-04-29 15:04:18Z

2

You are heading to the right direction. But for retaining the interfaces after every EDMX refresh, you'll need to customize the T4 files.

You can take a look at the customized T4 files from https://entityinterfacegenerator.codeplex.com/ They generate 1 interface for each of your class so that you can easily mock and test them separately.

So, everytime you add a new table or field, you can simply execute their T4 templates along with the ones provided by Microsoft for generating EF types.

Regards.

answered Apr 29, 2014 at 15:04

Believe2014

3,9943 gold badges28 silver badges46 bronze badges

2 Comments

Peter Smith Over a year ago

Thanks for this, sadly too late as we have now moved to code first. I will certainly review this again if there is a further need.

Believe2014 Over a year ago

Sure thing. Thanks for checking out the project. Hope it could help people like us who had to decide which technology to use. IMO code first is great only for new projects. Database first seems more practical. That's why I build the project to help people who could not afford to do code first.

Freeman · Accepted Answer · 2012-09-10 09:25:19Z

1

I think that creating an event on model update so that each time the model updates it will add the interface definitions.

Another option is to create a proxy class that implements a specific interface and inherits from the model.

answered Sep 10, 2012 at 9:25

Freeman

5,8013 gold badges32 silver badges41 bronze badges

Collectives™ on Stack Overflow

Generating Interfaces from entity framework database first auto-generated code

3 Answers 3

1 Comment

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related