Is it possible to use Entity Framework Core with existing database on tables with no primary key?

c# entity-framework-core sql-server

Question

I'm trying to use Entity Framework Core with an existing database. This database has several tables that don't have primary keys set due to other processes (out side of the scope of the application I'm building) that will break if the primary key is set.

Is it possible to create models of tables without the primary key?

I'm currently using:

  • Microsoft.EntityFrameworkCore -Version 2.0.1
  • Microsoft.EntityFrameworkCore.SqlServer -Version 2.0.1
  • Microsoft.EntityFrameworkCore.SqlServer.Design -Version
  • Microsoft.EntityFrameworkCore.Tools -Version 2.0.1
  • Microsoft.EntityFrameworkCore.Tools.DotNet -Version 2.0.0

I get this error when running the command below "Unable to generate entity type for table '...'. Please see the warning messages."

Command that I'm running:

Scaffold-DbContext "Server=...myservernamehere...;Database=...mydbnamehere...;Trusted_Connection=True;" Microsoft.EntityFrameworkCore.SqlServer -OutputDir Models

1
1
1/9/2019 2:32:18 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

Scafford will not work without a Primary Key. However, there is a workaround. At least in 2.2.0, I can't say for sure if this will work in older versions.

  • After you Scaffold the DBContext file for the database

  • At least one of your columns has to be unique data

  • You will need to create a model class for the table with all the columns you care about. It would be best to use the same name and data type as the table.

  • Create your DbSet

    public virtual DbSet<Model of table>  { get; set; }

  • In your OnModelCreating(ModelBuilder modelBuilder) create the mapping to the table 

    modelBuilder.Entity<Model of table>(entity =>
    {
        entity.HasKey(e => e.{Unique column});
        entity.ToTable("Table's Name");
    }
)
0
6/13/2019 12:52:27 PM

Related Questions

Entity Framework 6 - Missing table with only primary keys referencing different tables

As mentioned by @Hadi Hassan, EF will not “Expose” or recognize Relational Tables that are composed exclusively of other Entities....Work Around:...If you only need to ‘READ’ the data you can...Define a ...view... in your Schema for ...TableB.......Then do a ...Model (.EDMX)... Update from DB (select the Update Views)...You will now be ab...
.net c# entity-framework entity-framework-6
asked by DaniDev

How should I define a composite primary key for an existing database table?

I'm working on a Core MVC project that reads data (no writing required) from a pre-existing database. Unfortunately this database is a total mess, but I cannot change anything in it (and even if I could, I wouldn't touch it with a 10-foot pole)....Some of the relevant problems of the database are the following:...The tables don't have any foreign k...
composite-primary-key ef-database-first entity-framework entity-framework-core sql-server
asked by George T

How to read from a table without a primary key in Entity Framework Core 2.0?

I am having a problem reading from a table in my SQL Server without a primary key. I have defined an entity class such as:...public class PerfData { public Int64 ActivityId { get; set; } public Int64 Numbers{ get; set; } } ...And the ...DbContext... class, e.g. ...class MyDBContext { public DbSet<PerfData> {get; set;} } ...The entity t...
entity-framework entity-framework-core primary-key sql-server
asked by Samuel An

How to create table without primary key in Entity Framework Core?

I have an old database which has some tables without primary key. Now I'm moving my old project to Asp.Net Core and using Entity Framework Core 2.0.1 Code First approach. I have made the model class of table and trying to add migration using ...Add-Migration..., but it gives the below error. I think technically its expected behavior, But what are o...
asp.net-core asp.net-core-2.0 c# ef-code-first entity-framework-core
asked by vivek nuna

Entity Framework Core - realtion between two tables without using primary key

I would like to write Console application in dotnet core 2.1 with EFCore.Postgres 2.1.2....I have two tables in existing Database. Every table has it's own Primary key, but these tables should be related via another field - UserId...My models:...public class UserAddress { public int UserAddressId {get;set;} public int UserId {get;set;} ...
.net .net-core c# entity-framework-core postgresql
asked by Ariel Sz

Why am I getting duplicate ID columns when using Table Per Hierarchy in Entity Framework Core?

I am trying to use "table per hierarchy" to model a variety of account types in my database using EF Core (2.1) and I am having a problem where I am getting additional foreign key columns added for the derived types. I have seen ...this... question/answer but I don't think it is the same as my situation....Here are my account classes:...public abst...
c# entity-framework entity-framework-core
asked by Ben

Entity Framework Core: Violation of PRIMARY KEY constraint Cannot insert duplicate key in object

I am getting the following error when inserting records into a child table, Why is Entity Framework Core trying to insert a record into the parent table(IdentityUser table) when I am asking it to insert a record into a child table(Keywords table)? ...StackTrace:...An unhandled exception occurred while processing the request. SqlException: Violation...
asp.net-core c# entity-framework entity-framework-core
asked by Ajit Goel

Entity Framework Core generating -ve integer values for Primary Key column on a table row add

I am using EF Core v2.2 for inserting and updating rows into a table....While I am doing that, I am looping based on a list and trying to insert into the table. For the 1st row insert the code works as expected....However from the second item in the list the row doesn't get inserted into the table. ...When I debugged, I found out that after the _rm...
.net asp.net-core-webapi c# entity-framework entity-framework-core
asked by Shekar.gvr

How to change single primary key to composite primary key with EF Core

I want to delete the single primary key Id column in a SQL table that has already been created and does not contain data and define a composite primary key instead....My current entity definition is as follows:...[Key] [DatabaseGenerated(DatabaseGeneratedOption.Identity)] public int Id { get; set; } public long IpFrom { get; set; } public long Ip...
.net .net-core c# entity-framework entity-framework-core
asked by Umut Gür

I am unable to store data into database using Entity Framework Core and Ajax

I have a problem with my code. The problem is I am not getting post data by parameter using ajax....Can anyone fix this? The code is shown below....This is Javascript Ajax code where I am sending data by post method to the controller:...$('#pending').click(function () { SaveTestResult("/Reception/PatientTests/SavePendingTest"); }); function Sa...
asp.net asp.net-core asp.net-core-2.0 asp.net-core-mvc entity-framework-core
asked by SK jha

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