C#中如何使用EF Core的查询使用临时表？复杂查询优化？

using (var context = new AppDbContext())
{
    // 打开连接并保持会话
    context.Database.OpenConnection();
<pre class="brush:php;toolbar:false;"><pre class="brush:php;toolbar:false;">try
{
    // 创建临时表
    context.Database.ExecuteSqlRaw(@"
        CREATE TABLE #TempOrders (
            OrderId INT,
            TotalAmount DECIMAL(18,2),
            CustomerId INT
        )");

    // 插入数据到临时表
    context.Database.ExecuteSqlRaw(@"
        INSERT INTO #TempOrders (OrderId, TotalAmount, CustomerId)
        SELECT o.Id, SUM(i.Price * i.Quantity), o.CustomerId
        FROM Orders o
        JOIN OrderItems i ON o.Id = i.OrderId
        GROUP BY o.Id, o.CustomerId");

    // 查询临时表，并映射到实体或DTO
    var results = context.Set<OrderSummary>()
        .FromSqlRaw("SELECT OrderId AS Id, TotalAmount, CustomerId FROM #TempOrders WHERE TotalAmount > 1000")
        .ToList();
}
finally
{
    context.Database.CloseConnection();
}

var results = context.Set<OrderSummary>()
    .FromSqlRaw(@"
        WITH TempOrders AS (
            SELECT 
                o.Id AS OrderId,
                SUM(i.Price * i.Quantity) AS TotalAmount,
                o.CustomerId
            FROM Orders o
            JOIN OrderItems i ON o.Id = i.OrderId
            GROUP BY o.Id, o.CustomerId
        )
        SELECT OrderId, TotalAmount, CustomerId 
        FROM TempOrders 
        WHERE TotalAmount > 1000")
    .ToList();