可以在实体框架中设置列顺序 [英] Possible to set column ordering in Entity Framework

问题描述

在实体框架代码优先方法中，是否有任何可能的配置来设置数据库列的顺序??

Is there any possible configuration to set database column ordering in entity framework code first approach..?

我的所有实体集都应具有一些用于保留recordinfo的公共字段

All of my entity set should have some common fields for keeping recordinfo

public DateTime CreatedAt { get; set; }
public int CreatedBy { get; set; }
public DateTime ModifiedAt { get; set; }
public int ModifiedBy { get; set; }
public bool IsDeleted { get; set; }

我想将此字段保留在表的末尾.我可以使用任何可能的EF配置来配置它，而不是将这些字段保留在模型类的末尾.

I want to keep this fields at the end of the table. Is there any possible EF configuration that i can use to config this rather than keeping this fields at the end of my model class.

推荐答案

我假设您正在使用Entity Framework 6，因为列排序

I'm assuming you are using Entity Framework 6 since column ordering is not yet supported in EF Core.

您可以使用数据属性或流利的API来设置列顺序.

You can use either data attributes or the fluent API to set column order.

要使用数据属性设置列顺序，请引用System.ComponentModel.DataAnnotations并使用

To use a Data Attribute to set column order, reference System.ComponentModel.DataAnnotations and use the ColumnAttribute. You can also set the column name with this attribute if you want it to differ from the property name.

[Column("CreatedAt", Order=0)]
public DateTime CreatedAt { get; set; }
[Column("CreatedBy", Order=1)]
public int CreatedBy { get; set; }

请注意，Order参数从零开始.

Note the Order parameter is zero-based.

另请参见: http://www .entityframeworktutorial.net/code-first/column-dataannotations-attribute-in-code-first.aspx

或者，您可以在DbContext类的OnModelCreating方法中使用Fluent API:

Alternatively, you can use the Fluent API in the OnModelCreating method in your DbContext class:

protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
    //Configure Column
    modelBuilder.Entity<EntityClass>()
                .Property(p => p.CreatedAt)
                .HasColumnOrder(0);
}

另请参见: http://www .entityframeworktutorial.net/code-first/configure-property-mappings-using-fluent-api.aspx

这种方式比较冗长，但是您可以对发生的事情有更多的控制.

This way is a bit more verbose but you can have a more bit control over what's happening.

这篇关于可以在实体框架中设置列顺序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！