Oscar.EntityFrameworkCore.Sql 6.0.0

快速开始

依赖包

<ItemGroup>
    <PackageReference Include="Microsoft.EntityFrameworkCore.Relational" Version="6.0.0" />
    <PackageReference Include="Oscar.Data.SqlClient" Version="4.1.0" />
</ItemGroup>

示例

using Microsoft.EntityFrameworkCore;
using System;

namespace ConsoleApp12
{
    internal class Program
    {
        static void Main(string[] args)
        {
            var connectStrings = "Server=10.1.1.66;Port=2003;User Id=SYSDBA;Password=szoscar55;Database=OSRDB;";
            var optionsBuilder = new DbContextOptionsBuilder<UserDbContext>();
            optionsBuilder.UseSql(connectStrings);

            using (var context = new UserDbContext(optionsBuilder.Options))
            {
                var users = context.Users;
                foreach (var user in users)
                {
                    Console.WriteLine(user.Name);
                }
            }

            Console.WriteLine("Hello, World!");
        }
    }

    public class UserDbContext : DbContext
    {
        public UserDbContext(DbContextOptions<UserDbContext> options) : base(options)
        {
        }

        public DbSet<User> Users { get; set; }

        // create table users (id int primary key, name varchar(64), age int);
        protected override void OnModelCreating(ModelBuilder modelBuilder)
        {
            base.OnModelCreating(modelBuilder);

            modelBuilder.Entity<User>(m =>
            {
                m.ToTable("USERS");
                m.HasKey(m => m.Id);
                m.Property(m => m.Name).HasMaxLength(64);
            });
        }
    }

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

        public string Name { get; set; }

        public int Age { get; set; }
    }
}