如何使用linq和entityframework获取json中的表数据

using System;
using System.Collections.Generic;
using System.Data.Entity;
using System.Linq;
using Newtonsoft.Json;

// 定义模型类
public class Person
{
    public int Id { get; set; }
    public string Name { get; set; }
    public int Age { get; set; }
}

// 定义数据库上下文
public class MyDbContext : DbContext
{
    public DbSet<Person> People { get; set; }
}

class Program
{
    static void Main(string[] args)
    {
        // JSON数据
        string json = @"[
            { ""Id"": 1, ""Name"": ""Alice"", ""Age"": 25 },
            { ""Id"": 2, ""Name"": ""Bob"", ""Age"": 30 },
            { ""Id"": 3, ""Name"": ""Charlie"", ""Age"": 35 }
        ]";

        // 反序列化JSON数据为模型对象
        List<Person> people = JsonConvert.DeserializeObject<List<Person>>(json);

        // 使用LINQ查询语法获取表数据
        var adults = from p in people
                     where p.Age >= 18
                     orderby p.Name
                     select p;

        foreach (var person in adults)
        {
            Console.WriteLine($"Id: {person.Id}, Name: {person.Name}, Age: {person.Age}");
        }
    }
}