Can EF7 Create non-clustered primary key?

Entity Framework Code-First - Define the Non-clustered key for this EntityType

I Have defined an entity class with a key, but I don,t want that key be cluster because I have another cluster index in my entity, but I received an error when I add an Index attribute to my model,...Can anybody tell me that how can I define a ...Non-Clustered Key...????

create non clustered index on primary key entity framework 6.0

AFAIK this is not possible with EntityTypeConfiguration. However you can do this with Code-First migrations. Working example:...public class Product { public Guid Id { get; set; } public int Price { get; set; } } class AppDbContext : DbContext { public DbSet<Product> Products { get; set; } } public partial class InitialCr...

Mapping foreign key to non primary surrogate key column in EF code first

public class A { [DatabaseGenerated(DatabaseGeneratedOption.Identity)] public virtual int Aid { get; set; } public virtual ICollection<B> B { get; set; } } public class B { [DatabaseGenerated(DatabaseGeneratedOption.Identity)] public virtual int Bid { get; set; } [Key] [Column(Order = 0)] ...

Entity Framework 6 creates Id column even though other primary key is defined

I defined a DataObject as:...public class SensorType : EntityData { //PKs public string CompanyId { get; set; } public string ServiceId { get; set; } public string Type { get; set; } } ...And used fluent API to make CompanyId and ServiceId a composite key:...modelBuilder.Entity<SensorType>() .HasKey(t => new { t.Company...

Create a non-clustered index in Entity Framework Core

Using Entity Framework Core, I want to have a Guid PK, without suffering page ...fragmentation... in the database....I have seen this ...post... and ...this.... Although it was possible in EF6, the way it's done seems to have changed....Is it possible to create a non-clustered primary key in Entity Framework Core and have an additional index?...Q&A...

Entity Framework Core assigning null value to non-null primary key

Update: I have fixed the problem. The solution in my case was missing from my migration and will be specific to your database manager....The fix is this line in the migration:...Id = table.Column<long>(nullable: false) .Annotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.SerialColumn) ...I have a table that I am trying to l...

Creating composite primary key consisting off foreign keys in fluent API with ASP.NET core

The question here is how can i generate a composite primary key consisting of two foreign keys? ...I have tried: ...public class ActiveQuestions_Questions { [Column(Order = 0), Key, ForeignKey("ActiveQuestion")] public string ActiveQuestionId {get; set;} [Column(Order = 1), Key, ForeignKey("Question")] public string QuestionId {ge...

EF Core non-primitive type value object as primary key?

I've been trying to use a value object as a unique id in entity framework core. I've gotten to the point where it is saving to the database correctly, but EF is not querying the database correctly to find my entity. It looks like EF is loading the whole table, then doing the mapping in memory. When I look at the query it does not include a predic...

EF 6 Code-First Many to Many relationship with same entity on non-primary key

I have an EF 6 Task entity, which looks like this:...public class Task { public Guid TaskId {get; set;} public TaskTypeEnum TaskType {get; set;} public TaskStatusEnum TaskStatus {get; set;} public virtual ICollection<Task> Dependencies {get; set;} } ...Tasks of a certain type can be dependent on all other tasks of a certain type to...

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...