Entity framework not generating the database classes

entity-framework-6 visual-studio-2019

Question

Using Visual Studio 2019 I recently upgraded all my NuGet packages, so I see that EntityFramework is now showing as 6.2.0. My project is a Web API 2 solution. When I open my database model and right-click to Update Model from Database I can select my new tables but when I save the edmx file it closes immediately. In the past it would run for a bit while it wrote new files.

In the actual .edmx file itself for example I see this entry for my newly added table:

<EntityType Name="Audit_Log">
  <Key>
    <PropertyRef Name="id" />
  </Key>
  <Property Name="id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
  <Property Name="Lab_Space_Id" Type="int" Nullable="false" />
  <Property Name="Field" Type="varchar" MaxLength="80" Nullable="false" />
  <Property Name="Old_Value" Type="varchar" MaxLength="1000" />
  <Property Name="New_Value" Type="varchar" MaxLength="1000" />
  <Property Name="Modified" Type="datetime2" Precision="7" Nullable="false" />
  <Property Name="Updater" Type="int" Nullable="false" />
</EntityType>

However, it didn't generate the corresponding class definition for the Audit_Log class. If I completely remove the edmx file and select all my desired tables plus this new one it will generate it correctly.

1
0
5/22/2019 6:42:01 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

This is a workaround for the problem. If you expand the .edmx file in Solution Explorer you'll see two files that end in .tt. Right-click on those and choose to Run Custom Tool and then the classes will be generated. Just doing it on the .edmx file itself didn't work for me.

0
5/22/2019 8:29:16 PM

Related Questions

Change entity framework database first auto generated domain classes

are you planning then to go code first? Will you need to regenerate ever again ?...If you know the answer to those questions. Or have at least considered the impact.... See ...Reverse engineer code first to existing DB...This gets you a model you can start with...OtherWise: The partial class approach may help. Last time i tried (EF4) the generated ...
c# ef-database-first entity-framework entity-framework-6
asked by phil soady

How can you change the parameterless constructor of an Entity Framework 6 database-first generated class?

You can't implement a 2nd parameterless constructor ...User()..., because there is already one in the auto-generated class....Hence, you have only 2 options to resolve this issue:...Inherit from the original class ...User... (see below)....Modify the ...T4-template... so the parameterless constructor is generated with the extra code ...DateCreated ...
ef-database-first entity-framework-6
asked by Matt

Oracle ODP.Net With Entity Framework 6 - Entity framework database compatible provider could not be found

Just to complement, i've tried everything but in my case it was solved by setting the "...defaultConnectionFactory...", like this:...<entityFramework> <defaultConnectionFactory type="Oracle.ManagedDataAccess.EntityFramework.OracleConnectionFactory, Oracle.ManagedDataAccess.EntityFramework"> </defaultConnectionFactory> <providers> <provider invari...
.net ado.net-entity-data-model entity-framework odac oracle
asked by Fernando Meneses Gomes

Entity Framework Not Generating Classes for Tables or Procedures

Make sure the table has a key column. It will not generate the view if there is no key column in a table.
ado.net-entity-data-model c# entity-framework sql-server
asked by Divakar Mayakrishnan

Entity Framework "Database First" not generating Foreign keys

I just ended up editing it manually adding the forgein key annotation:...[Table("rapportAnomalie")] public partial class rapportAnomalie { [Key] public int code_rapport { get; set; } public DateTime date_rapport { get; set; } [Required] [StringLength(50)] public string etat { get; set; } public int code_agence { get;...
asp.net c# entity-framework-6 visual-studio-2015
asked by Omar Chaabouni

How can I alias partial classes generated by Entity Framework Code First From Database?

Try this:...[Table("vwDS_ProductCategories")] public partial class ProductCategories { }
c# ef-code-first entity-framework-6 partial-classes
asked by Juan

Entity Framework's auto generated class's code gets re generated every time model is updated

You are using the ...MetadataTypeAttribute... wrong. You should create a seperate class for the annotations....I do it with a private inner class for example:...[MetadataType(typeof(Table1MetaData))] public partial class Table1 { private class Table1MetaData { [MaxLength(20)] public string Foo { get; set; } } } ...Import...
asp.net-mvc c# entity-framework entity-framework-6 sql-server
asked by Christian Gollhardt

Entity Framework 6 Database First Doesn't Generate Entity on Table With Composite Key

Gert Arnold's comment pointed me in the right direction, as did ...this answer.......Once I added another column besides the two primary keys, Entity Framework generated the entity. Here is a sample table definition for which EF Database First will create an entity:...create table [dbo].[CustomerRequests] ( [CustomerId] int not null, [Reque...
composite-primary-key ef-database-first entity-framework entity-framework-6 sql-server
asked by Chris Schiffhauer

EF6 database first for Oracle sometimes not generating a class for a table

I finally figured out what was happening. One of the "problem" tables was not actually a problem, just my misunderstanding of how Entity Framework works. This table was a pure join table having only two columns: one column pointing to table A and the other to table B. Entity Framework does not generate a class for a pure join table. Instead, it ...
c# entity-framework-6 oracle12c visual-studio-2013
asked by Bill at Work

Npgsql Entity Framework database first not generating point type properties

Entity Framework 6.x supports only a limited, closed set of types, which doesn't include PostgreSQL's ...point... type. The documentation you're linking to is for Npgsql, the ADO.NET provider, which is the layer below the Entity Framework provider....Entity Framework Core does have extensible type mapping and supports point out of the box, I sugges...
entity-framework-6 npgsql postgresql
asked by Shay Rojansky

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow