LINQ to SQL查询没有正确排序,请帮忙

var query = from employee in employeeList
            orderby employee.Name ascending
            select employee;

using System;
using System.Linq;

class Program
{
    static void Main()
    {
        // 建立数据库连接
        string connectionString = "Data Source=YourServerName;Initial Catalog=YourDatabaseName;Integrated Security=True";
        var employeeDataContext = new EmployeeDataContext(connectionString);

        // 建立查询
        var query = from employee in employeeDataContext.Employees
            orderby employee.Salary descending
            select employee;

        // 执行查询
        var result = query.ToList();

        Console.WriteLine("排序后的查询结果:");
        foreach (var employee in result)
        {
            Console.WriteLine(employee.Name);
        }
    }
}

var query = from employee in employeeList
            orderby employee.Name ascending
            select employee;