使用带有逗号分隔ID的LINQ从SQL获取所有数据

using System;
using System.Collections.Generic;
using System.Data.Linq;
using System.Linq;

public class DataContext : DataContext
{
    public Table<User> Users;
}

public class User
{
    public int Id { get; set; }
    public string Name { get; set; }
}

public class Program
{
    public static void Main()
    {
        string ids = "1,2,3,4,5";
        int[] idArray = ids.Split(',').Select(int.Parse).ToArray();

        using (DataContext db = new DataContext())
        {
            var users = db.Users.Where(user => idArray.Contains(user.Id)).ToList();

            foreach (var user in users)
            {
                Console.WriteLine($"Id: {user.Id}, Name: {user.Name}");
            }
        }
    }
}

int[] idArray = ids.Split(',').Select(id => int.TryParse(id, out int parsedId) ? parsedId : throw new FormatException($"Invalid ID: {id}")).ToArray();

var idSet = new HashSet<int>(idArray);
var users = db.Users.Where(user => idSet.Contains(user.Id)).ToList();