如何使用LINQ在C#中以Datetime格式转换SQL中的Timestamp数据类型值？

using System.Data.Linq;
using System.Data.Linq.Mapping;

[Table(Name = "YourTableName")]
public class YourTable
{
    [Column(IsPrimaryKey = true)]
    public int Id { get; set; }

    [Column]
    public byte[] Timestamp { get; set; }
}

public List<YourTable> GetYourTableData()
{
    using (var db = new DataContext("YourConnectionString"))
    {
        var query = from t in db.GetTable<YourTable>()
                    select new YourTable
                    {
                        Id = t.Id,
                        Timestamp = t.Timestamp
                    };

        return query.ToList();
    }
}

var data = GetYourTableData();
foreach (var item in data)
{
    DateTime timestamp = new DateTime(BitConverter.ToInt64(item.Timestamp, 0));
    Console.WriteLine($"Id: {item.Id}, Timestamp: {timestamp}");
}