EF6 Updating Model loses my Explicit Casts

Question

Entity framework seems to be almost more trouble than it is worth for larger databases.

In my apps (WCF Services, Hosts, and Clients) I need to synchronise various Entity Class Objects, have the Connection parameters in various app.config files (synchronised) and when I do a model update (Database to Code) Explicit Casts made in the models.cs are destroyed. This means a lot of time wasted re-writting code that has already been done.

The more complex this application / Database becomes the more unsuitable EF seems.

How can I keep the Update Wizard undoing all my work, and keep things synchronised automatically?

or should I just go back to Sql Commands?

Have you had a look into [T4 Templates](https://msdn.microsoft.com/en-us/data/gg558520.aspx) in EF? — , May 25 '15 at 02:45

score 1 · Accepted Answer · edited May 23 '17 at 12:05

1

You should not change generated cs file ever, instead you should create partial classes to add your custom logic into generated classes. Have a look at When is it appropriate to use C# partial classes?, and similarly search google for more about partial classes in C#, you will get better idea of how to use them with your problem.

edited May 23 '17 at 12:05

Community

1
1

answered May 25 '15 at 05:32

Akash Kava

39,066
20
121
167

EF6 Updating Model loses my Explicit Casts

1 Answers1