从Linq到Sql的随机行

using System;
using System.Data.Linq;
using System.Data.SqlClient;
using System.Linq;

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

class Program
{
    static void Main(string[] args)
    {
        string connectionString = "Data Source=your_server;Initial Catalog=your_database;Integrated Security=True";
        SqlConnection connection = new SqlConnection(connectionString);

        Table<RandomRow> randomRows = connection.GetTable<RandomRow>();

        Random random = new Random();
        int randomId = random.Next(1, randomRows.Count() + 1);

        RandomRow randomRow = randomRows.FirstOrDefault(r => r.Id == randomId);

        Console.WriteLine($"Id: {randomRow.Id}, Name: {randomRow.Name}");
    }
}