Entity Framework 6 - Knowledge Base (KB)

ADO.NET Entity Framework and identity columns

Is the Entity Framework aware of identity columns? ...I am using SQL Server 2005 Express Edition and have several tables where the primary key is an identity column. when I use these tables to create an entity model and use the model in conjunction with a...

Entity Framework - SaveChanges() doesn't get the generated Identity key

I'm using entities Framework in my project and it has been a nightmare!...I have a SQL DB were I have a table called Form....Form has an ID that is a PK and Identity (it's automatically increased)....This time I'm doing this:...Dim form as int32 Dim dbfor...

What is the recommended identity generation approach in Entity framework?

I am interested in what is the most performant way for StoreGeneratedPattern....In past I was used to let the DB generate the ID for me but I was wondering if there is any advantage in setting...StoreGeneratedPattern = None ...instead of...StoreGenerated...

EF5 Code First identity column error

I have class hierarchy like following:...class BaseType { [Key] [DatabaseGeneratedAttribute(DatabaseGeneratedOption.Identity)] public int Id { get; set; } [DataType(DataType.Text)] [StringLength(100)] public string CreatedBy { get; set; } ...

Using Asp.Net Identity DataBase first approach

I need to integrate Asp.Net latest MVC version with an ...existing... database which has an additional column ...String Address... to table ...dbo.AspNetUsers...I need to create an instance ...ApplicationUser... which has property Address....Any idea how ...

Migrating to Asp.Net Identity 2.0: new columns not being created in AspNetUsers table

I get the following error when I try to register a new user, using Identity 2.0 and the default MVC 5 application:...Invalid column name 'Email'. Invalid column name 'EmailConfirmed'. Invalid column name 'PhoneNumber'. Invalid column name 'PhoneNumberConf...

There is already an object named 'AspNetRoles' in the database

Some time ago, I created a ASP.NET MVC 5 website with the Identity 1.0 version, and i created the Identity tables with this project. Now i have to make other website using the same database for authentication, but now the Identity version is 2.0. So when...

MVC 5 UserManager: The entity type ApplicationUser is not part of the model for the current context

I'm trying (but failing) to implement the MVC ...UserManager... to my website. I thought my case is fairly trivial. I have a ...User... class (Entity Framework - Database first) which contains all the user's info. Not every user from the ...User... has ac...

Oracle database connection for Entity Framework

I'm trying to make a token-based authorization in my Web API service, planning to store identity tables in my Oracle database....I know there are two ways of accessing the database - via Oracle ManagedDataAccess or Oracle DataAccess. I've downloaded manag...

The entity type 'AspNetUserLogins' requires a primary key to be defined?

I scaffolded my database with EF and I changed the ...mydbcontext... to inherit from ...IdentityDbContext... because I want everything under one ...dbcontext.... ...The problem is that when I start the application and write the credentials in the login pa...