Identity value generation can only be used with signed integer properties after upgrade to EF Core 1.1

asp.net-core asp.net-core-1.0 entity-framework-core

Question

When I updated "Microsoft.EntityFrameworkCore.Tools.DotNet" to version "1.1.0-preview4", entity framework has stopped to generate migrations.

Error: 

dotnet : System.ArgumentException: Identity value generation cannot be used      
for the property 'UID' on entity type 'SomeEntity' because the property type is   
'Guid'. Identity value generation can only be used with signed integer properties.
1
2
11/29/2016 5:55:16 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

Solution is get rid of attribute [DatabaseGenerated(DatabaseGeneratedOption.Identity)]

[Key]
// [DatabaseGenerated(DatabaseGeneratedOption.Identity)] <-- remove this
public Guid UID { get; set; }

and update model builder

protected override void OnModelCreating(ModelBuilder modelBuilder)
{
    base.OnModelCreating(modelBuilder);

    // add this:
    modelBuilder.Entity<SomeEntity>().Property(p => p.UID).ValueGeneratedOnAdd();
}
3
11/29/2016 3:49:43 PM

Related Questions

NullReferenceException in EF 5-6.1.1 with two navigation properties to the same type

The workaround is to have an "OwnerId" property on Ticket. (See fix branch in the solution in github)...So, Ticket becomes: ...public class Ticket { public int Id { get; set; } public string Name { get; set; } public int? OwnerId { get; set; } public virtual User Owner { get; set; } public int? LockedByUserId { get; set; } ...
c# code-first entity-framework entity-framework-5 entity-framework-6
asked by Matt V

EF Core 1.1 preview1: No executable found matching command "dotnet-ef"

You need to add ..."Microsoft.EntityFrameworkCore.Tools.DotNet": "1.0.0-preview3-final"... to the tools section....See ...https://blogs.msdn.microsoft.com/dotnet/2016/10/25/announcing-entity-framework-core-1-1-preview-1/... for more info
asp.net entity-framework entity-framework-core macos migration
asked by Andriy Svyryd

EF Core 1.1 to WebApi Core - Add-Migration fails

The issue is related to the ...builder.AddUserSecrets()... call. To fix perform the following steps:...Adding the user secret to the assembly (instead of just ...project.json...) by adding attribute ...[assembly: UserSecretsId("aspnet-TestApp-ce345b64-19cf-4972-b34f-d16f2e7976ed")]... to ...Startup.cs...In ...Startup.cs... replace ...builder.AddUs...
.net asp.net-core c# entity-framework entity-framework-core
asked by Michael Dennis

EF Core 1.1 Migration - The current CSharpHelper cannot scaffold literals of type

You are using a .NET Core 1.1 runtime but the old tooling packages (you should be using the latest tooling, as of this date it is ...preview4..., which is still in ...alpha..., contrary to the runtime - ...yeah, not very intuitive at first...)...In summary, this is a ...Known Issue...Update your ...project.json... to use ...preview4... as stated in...
.net .net-core c# entity-framework entity-framework-core
asked by Andrés Robinet

EF Core 1.1 - How to Add migrations in .net core console

You need to add ...Sample.Infrascruture... as ...--project.... Like this:...dotnet ef --project "C:\MYPATH\Sample.Infrastructure" --startup-project "C:\MYPATH\Sample.UI" migrations add "TXT" ...And then run it from the ...Sample.UI... project...The same when you do a ...database upgrade...Also, try to set the connectionstring in ...BlogDbContext...
.net-core entity-framework-core
asked by Morten OC

ASP.NET Core and EF Core 1.1 - Diplay Data using Stored Procedure

While support for stored procedures isn’t completely there with Entity Framework Core ...yet..., you still can use ...FromSql... to consume stored procedures with it....In order to do that, the database context needs to know the entity you are mapping to from the stored procedure. Unfortunately, the only way to do that right now is to actually d...
asp.net-core entity-framework-core
asked by poke

Entity framework Core with Identity and ASP.NET Core 1.1 Seeding

Archer, to seed data to a database in ASP.NET core you should first create a class, you could call this DbInitializer, and it should look something like this....public static class DbInitializer { public async static void InitializeAync(ApplicationDbContext context, UserManager<ApplicationUser> userManager, RoleManager<IdentityRole> roleManager...
asp.net-core entity-framework-core
asked by Temi Lajumoke

Upgrade from EF Core 1.1 to 2.0 preview

EF Core 2.0 Preview 1... requires Visual Studio 15.3 Preview, so you have to install it. ...Announcing EF Core 2.0 Preview 1...:...Accessing .NET Core tooling in Visual Studio requires Visual Studio 2017 15.3 Preview, Visual Studio for Mac or Visual Studio Code. More information about this and download links can be found in the .NET Core 2.0 ...
entity-framework-core
asked by Ilya Chumakov

Add-Migration doesn't work after upgrading from Entity Framework Core 1.1 to 2

It seems like your upgrade not only Ef,but also Asp.Net CORE. Change your ...Program.cs... file to:...public class Program { public static void Main(string[] args) { var host = BuildWebHost(args); host.Run(); } // Tools will use this to get application services public static IWebHost BuildWebHost(string[] args)...
entity-framework-core
asked by Suleymani

Different user types with ASP.NET Core 1.1 Identity and Entity Framework Core

You shouldn't create different tables for each user type you have. You should create roles and assign that roles to a user. For example create a role student and a role teacher and assign them acording to your needs....So I would say what you've done isn't a good design....When you need to save additional values for a student/teacher than I would d...
asp.net-core asp.net-identity c# entity-framework-core
asked by user743414

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