123456789101112131415161718192021222324252627282930313233343536373839 |
- using SqlSugar;
- using System;
- using System.Collections.Generic;
- using System.Configuration;
- using System.Linq;
- using System.Text;
- using System.Threading.Tasks;
- namespace SqlSugarDb.MySqlSugarClient
- {
- public class DbSqlSugarClient
- {
- private static string comConfig = ConfigurationManager.AppSettings["MySql"];
- //private static readonly string connectionString = "Data Source=localhost;Database=datacollection;User Id='root';Password='Lt,100186';port=3306;charset=utf8mb4;";
- private static SqlSugarScope mySqlSugar = null;
- public static SqlSugarScope GetInstance()
- {
- if(mySqlSugar==null)
- {
- mySqlSugar = new SqlSugarScope(new ConnectionConfig()
- {
- ConnectionString = comConfig,
- DbType = DbType.MySql,
- IsAutoCloseConnection = true,
- InitKeyType = InitKeyType.Attribute, //从实体特性中读取主键自增列信息
- });
- // mySqlSugar.DbFirst.IsCreateAttribute()
- //.CreateClassFile(@"E:\项目", "Model.Entities");
- }
-
- return mySqlSugar;
- }
- }
- }
|