Is there a performance difference between Model First and Code First in MS Entity Framework 4.1?

I believe that there is no difference at all in performance. Code-First, Model-First, Database-First are modelling strategies at design time For both Model-First and Database-First entity classes and a DbContext will be created with a T4 template. At runtime EF 4.1 just works with those classes and it doesn't matter where they come from - hand-written (Code-First) or autogenerated from the T4 template (Model-First, Database-First) Also keep in mind that the benefit that Model-First gives you is rather limited in my opinion: You just have the possibility to create your model classes on a design surface in VS2010.

But there are more drawbacks on the other side: The default T4 template isn't very fine granular in creating the code from the model. For instance: It doesn't put MaxLength attributes on the properties, it creates always navigation properties on both sides on a relationship (you often don't want and need both sides) and the overridden OnModelCreating method in DbContext just contains the single line throw new UnintentionalCodeFirstException() which isn't particularly impressive. You can modify the template and the CSDL part of the EDMX file though to achieve more granularity when the model classes and the DbContext are generated (thanks to Ladislav for his comment below about this option) In other words it is very likely that you have to tweak the generated code (adding attributes, removing unwished navigation properties, adding Fluent mapping code and so on) in order to get the finetuned model classes you want to work with.As soon as you have done this it becomes difficult to do any changes in the model designer because the DbContext generator will overwrite all your hand-made changes in the code In my opinion Model-First with EF 4.1 is only useful if you already have a model designed in the designer surface for instance from an older EF 4.0 project and you want to migrate your project to EF 4.1 In this case the DbContext generator might be useful to create initial code for you.

From that point I would proceed with working in the code alone which means: Working with Code-First. If you start with a new project I would prefer Code-First from the beginning. Even if you really want or need this visual representation of the model in the designer surface also in Code-First you can simply create an EDMX file from your DbContext and open it in VS2010 to show your model classes and their relationships in the designer: using (var context = new MyDbContext()) { using (var writer = new XmlTextWriter(@"c:\MyModel.

Edmx", Encoding. Default)) { EdmxWriter. WriteEdmx(context, writer); } } Edit There is actually one point where EF 4.1 recogizes the difference whether a model comes from Model-First (i.e.

An EDMX model file and designer surface) or if it is a pure Code-First model - and that is the connection string. If you create a model from Model-First you get a connection string which contains references to the model metadata files, like so: add name="MyConnectionString" connectionString="metadata=res://*/Model. Csdl|res://*/Model.

Ssdl |res://*/Model. Msl;provider=System.Data. SqlClient; provider connection string="data source=.

\sqlexpress; initial catalog=MyDb;integrated security=True; multipleactiveresultsets=True;App=EntityFramework"" providerName="System.Data. EntityClient Whereas for Code-First simply a "normal" connection string without metadata references is used: add name="MyConnectionString" connectionString="Server=. \SQLEXPRESS;Database=MyDb;Trusted_Connection=Yes;" providerName="System.Data.

SqlClient Now you can use the second simple connection string without problems also for a model which is created via Model-First. But the code snippet above (creating an EDMX from DbContext) throws an exception with the first connection string telling that WriteEdmx can only be used with Code-First but not Model-First or Database-First.So obviously the DbContext processes or stores somehow the metadata information from the connection string How to interprete this? Does it mean that it actually uses the data in the EDMX file specified in the connection string when the model is built in memory?

In this case there could theoretically be a performance difference between Code-First and Model-First (at least at model-build-time). But I don't think that the metadata are actually processed. But the mentioned exception is somewhat weird.

Why does EF 4.1 prevent me to create an EDMX model file when my model comes from Model-First? Perhaps just to avoid possible confusion and mess with two EDMX files? I don't know.

I believe that there is no difference at all in performance. Code-First, Model-First, Database-First are modelling strategies at design time. For both Model-First and Database-First entity classes and a DbContext will be created with a T4 template.At runtime EF 4.1 just works with those classes and it doesn't matter where they come from - hand-written (Code-First) or autogenerated from the T4 template (Model-First, Database-First).

Also keep in mind that the benefit that Model-First gives you is rather limited in my opinion: You just have the possibility to create your model classes on a design surface in VS2010. But there are more drawbacks on the other side: The default T4 template isn't very fine granular in creating the code from the model. For instance: It doesn't put MaxLength attributes on the properties, it creates always navigation properties on both sides on a relationship (you often don't want and need both sides) and the overridden OnModelCreating method in DbContext just contains the single line throw new UnintentionalCodeFirstException(); which isn't particularly impressive.

You can modify the template and the CSDL part of the EDMX file though to achieve more granularity when the model classes and the DbContext are generated (thanks to Ladislav for his comment below about this option). In other words it is very likely that you have to tweak the generated code (adding attributes, removing unwished navigation properties, adding Fluent mapping code and so on) in order to get the finetuned model classes you want to work with.As soon as you have done this it becomes difficult to do any changes in the model designer because the DbContext generator will overwrite all your hand-made changes in the code. In my opinion Model-First with EF 4.1 is only useful if you already have a model designed in the designer surface for instance from an older EF 4.0 project and you want to migrate your project to EF 4.1 In this case the DbContext generator might be useful to create initial code for you.

From that point I would proceed with working in the code alone which means: Working with Code-First. If you start with a new project I would prefer Code-First from the beginning. Even if you really want or need this visual representation of the model in the designer surface also in Code-First you can simply create an EDMX file from your DbContext and open it in VS2010 to show your model classes and their relationships in the designer: using (var context = new MyDbContext()) { using (var writer = new XmlTextWriter(@"c:\MyModel.

Edmx", Encoding. Default)) { EdmxWriter. WriteEdmx(context, writer); } } Edit There is actually one point where EF 4.1 recogizes the difference whether a model comes from Model-First (i.e.

An EDMX model file and designer surface) or if it is a pure Code-First model - and that is the connection string. If you create a model from Model-First you get a connection string which contains references to the model metadata files, like so: Whereas for Code-First simply a "normal" connection string without metadata references is used: Now you can use the second simple connection string without problems also for a model which is created via Model-First. But the code snippet above (creating an EDMX from DbContext) throws an exception with the first connection string telling that WriteEdmx can only be used with Code-First but not Model-First or Database-First.

So obviously the DbContext processes or stores somehow the metadata information from the connection string. How to interprete this? Does it mean that it actually uses the data in the EDMX file specified in the connection string when the model is built in memory?

In this case there could theoretically be a performance difference between Code-First and Model-First (at least at model-build-time). But I don't think that the metadata are actually processed. But the mentioned exception is somewhat weird.

Why does EF 4.1 prevent me to create an EDMX model file when my model comes from Model-First? Perhaps just to avoid possible confusion and mess with two EDMX files? I don't know.

1, but I think you miss a bit of magic that Code-First POCOs go through at runtime. Compared to actual networking delays this magic is obviously cheap, but the model also has to be verified against a database-stored checksum, which obviously incurs additional processing and networking costs. But, as most people, I can live with that, because it saves on developer time.

But since CF encourages you to use these POCOs, you might get stuck when you want to update your table definitions later (ex. Shipped product, add table, change checksum, break product). – Gleno Jul 17 at 1:09 @Gleno: Model is validated only once when the context is used for the first time after the application is started.

Moreover that feature can be turned off. – Ladislav Mrnka Jul 17 at 10:03 @Slauma: Even with model first you can get any granularity you want and you can add data annotations you want but it requires some changes in T4 template and most of the time some manual changes in CSDL part of XML (structural annotations). – Ladislav Mrnka Jul 17 at 10:04 @Ladislav: I see, I hadn't modification of the template and EDMX in mind.

I've added a note about this into my answer. – Slauma Jul 17 at 10:35 @Sluama @Gleno @Ladislav Thanks all for very useful comments. I was not aware of the EdmxWriter so that's interesting.

I would like to use T4 templates simply to increase productivity so having the EDMX file is important. – Nick Jul 17 at 13:25.

I believe that there is no difference at all in performance. Code-First, Model-First, Database-First are modelling strategies at design time . For both Model-First and Database-First entity classes and a DbContext will be created with a T4 template.

At runtime EF 4.1 just works with those classes and it doesn't matter where they come from - hand-written (Code-First) or autogenerated from the T4 template (Model-First, Database-First).

Yes, there are performance differences between Model First (EF 4.0) and Code First (EF 4.1 - 4.3.1).

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.