WinFormsApp1/DbContext/LibraryDbContext.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Reflection.Metadata.Ecma335;
using System.Security.Cryptography;
using System.Text;
using System.Threading.Tasks;

using Microsoft.EntityFrameworkCore;

namespace WinFormsApp1
{
    /// <summary>
    /// 数据库内容
    /// </summary>
    public class LibraryDbContext : DbContext
    {
        /// <summary>
        /// 共享数据库上下文实例，使用前需要先调用SetSharedInstance方法
        /// </summary>
        public static LibraryDbContext Shared
        {
            get
            {
                return _instance;
            }
            set
            {
                _instance = value;
            }
        }
        private static LibraryDbContext _instance;//shared属性对应的实体

        /// <summary>
        /// 设置共享数据库上下文的Connectionstring
        /// </summary>
        /// <param name="ConnectionString"></param>
        /// <returns>返回shared对象</returns>
        public static LibraryDbContext SetSharedInstance(string ConnectionString)
        {
            _instance = new LibraryDbContext(ConnectionString);

            return _instance;
        }

        public LibraryDbContext(string ConnectionString)
        {
            if (ConnectionString == null || ConnectionString == string.Empty)
                throw new ArgumentNullException("ConnectionString", "ConnectionString不能为空");

            this._ConnectionString = ConnectionString;
        }

        public DbSet<Book> Books { get; set; }
        public DbSet<Account> Accounts { get; set; }
        public DbSet<BookCategory> Categories { get; set; }
        public DbSet<BorrowLog> BorrowLogs { get; set; }
        public DbSet<BookWareHouse> BookWareHouses { get; set; }
        public DbSet<BookInfo> BookInfo { get; set; }