如何让EF生成的Tickets类关联的Ticket_Comments默认按Date排序？

Hey there! I’ve dealt with this exact issue before—when EF auto-generates partial classes, you can’t just override the collection property directly, but there are a few clean ways to get your comments sorted by date by default. Let’s break down the best options:

Option 1: Use Entity Framework Fluent API (Recommended) #

This is the most robust approach because it configures sorting at the EF level, meaning the database returns already sorted comments every time you load a tickets entity. Here’s how to set it up in your DbContext:

protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
    // First, define the entity relationship (adjust based on your actual foreign key)
    modelBuilder.Entity<tickets>()
        .HasMany(t => t.ticket_comments)
        .WithRequired() // Use .WithOptional() if your comment doesn't require a ticket reference
        .HasForeignKey(tc => tc.ticket_id); // Replace with your actual foreign key property on ticket_comments

    // Add the default sort rule for the collection
    modelBuilder.Entity<tickets>()
        .HasMany(t => t.ticket_comments)
        .OrderBy(tc => tc.date); // Use OrderByDescending for newest comments first
}

Note: Make sure your ticket_comments class has the foreign key property (like ticket_id)—EF usually generates this automatically, even if it wasn’t included in your code snippet. If it’s missing, add it to your custom partial ticket_comments class first.

Option 2: Add a Read-Only Sorted Property to the tickets Partial Class #

If you don’t want to modify the DbContext configuration, create a custom read-only property in your own partial tickets class that returns sorted comments:

// Your custom partial class (separate from the auto-generated one)
public partial class tickets
{
    public IEnumerable<ticket_comments> SortedTicketComments
    {
        get
        {
            return ticket_comments.OrderBy(tc => tc.date);
        }
    }
}

Just use SortedTicketComments instead of the original ticket_comments property in your code, and you’ll always get sorted results. Keep in mind this sorts the collection in memory, so it’s better for smaller datasets.

Option 3: Explicitly Sort When Querying #

If you only need sorted comments in specific queries, include and sort the collection directly in your LINQ query:

var sortedTickets = dbContext.tickets
    .Include(t => t.ticket_comments.OrderBy(tc => tc.date))
    .ToList();

This gives you flexibility to adjust the sort order per query, but you’ll need to remember to add the OrderBy every time you load the comments.

内容的提问来源于stack exchange，提问作者markus