使用EF Core访问SqlServer数据库

 1 using Microsoft.EntityFrameworkCore;
 2 
 3 namespace ConsoleApp1
 4 {
 5     public partial class D1 : DbContext
 6     {
 7         protected override void OnConfiguring(DbContextOptionsBuilder options)
 8            => options.UseSqlServer(@"data source=(localdb)\mssqllocaldb;initial catalog=d1;user id=sa;password=xxx");
 9 
10         public virtual DbSet<t1> t1 { get; set; }
11     }
12 }

using System.ComponentModel.DataAnnotations;
namespace ConsoleApp1
{
    public class t1
    {
        [Key]
        [StringLength(10)]
        public string xm { get; set; }

        public byte? nl { get; set; }
    }
}

using System;
using System.Linq;

namespace ConsoleApp1
{
    class Program
    {
        static void Main(string[] args)
        {
            D1 d = new D1();
            var t = from x in d.t1 select(x);
            foreach (var item in t)
            {
                Console.Write(item.xm + "," + item.nl);
                Console.WriteLine();
            }
        }
    }
}

ls,18
zs,20