sqlsugar学习记录

    /// 

    /// sqlsuager数据库连接字符串
    /// 
    public static class SqlSugarDbContext
    {
        /// 

        /// 创建数据库及注入sqlsugar基本配置
        /// 
        /// 
        /// 
        public static SqlSugarScope AddSqlsugarSetup(this IServiceCollection services, IConfiguration configuration)
        {
            SqlSugarScope sqlSugar = new SqlSugarScope(new ConnectionConfig()
            {
                DbType = SqlSugar.DbType.SqlServer,
                ConnectionString = configuration["ConnectionStrings:conn"],
                IsAutoCloseConnection = true,
            });
            services.AddSingleton(sqlSugar);//这边是SqlSugarScope用AddSingleton
            var test= sqlSugar.DbMaintenance.CreateDatabase();//创建数据库
            return sqlSugar;
            
        }
        /// 

        /// 初始化系统表
        /// 
        /// 
        public static void InitSysTables(this SqlSugarScope sugarScope)
        {
            Type[] types = Assembly.Load("Synergy.Domain").GetTypes().Where(s=>s.FullName.Contains("SysEntity")).ToArray();
            sugarScope.CodeFirst.SetStringDefaultLength(200).InitTables(types);//生成所有的系统表
        }

    }