DbSqlSugarClient.cs 1.2 KB

123456789101112131415161718192021222324252627282930313233343536373839
  1. using SqlSugar;
  2. using System;
  3. using System.Collections.Generic;
  4. using System.Configuration;
  5. using System.Linq;
  6. using System.Text;
  7. using System.Threading.Tasks;
  8. namespace SqlSugarDb.MySqlSugarClient
  9. {
  10. public class DbSqlSugarClient
  11. {
  12. private static string comConfig = ConfigurationManager.AppSettings["MySql"];
  13. //private static readonly string connectionString = "Data Source=localhost;Database=datacollection;User Id='root';Password='Lt,100186';port=3306;charset=utf8mb4;";
  14. private static SqlSugarScope mySqlSugar = null;
  15. public static SqlSugarScope GetInstance()
  16. {
  17. if(mySqlSugar==null)
  18. {
  19. mySqlSugar = new SqlSugarScope(new ConnectionConfig()
  20. {
  21. ConnectionString = comConfig,
  22. DbType = DbType.MySql,
  23. IsAutoCloseConnection = true,
  24. InitKeyType = InitKeyType.Attribute, //从实体特性中读取主键自增列信息
  25. });
  26. // mySqlSugar.DbFirst.IsCreateAttribute()
  27. //.CreateClassFile(@"E:\项目", "Model.Entities");
  28. }
  29. return mySqlSugar;
  30. }
  31. }
  32. }