SqlSugar 常用注释配置

SqlSugar 
//实体
//IsIdentity = true自增  IsPrimaryKey = true 主键
//
 [SugarColumn(IsNullable = false, IsPrimaryKey = true, IsIdentity = true )]
public string user{get;set;}
           

实体生成

using SqlSugar;
using System;
using System.Collections.Generic;
using System.Text;

namespace SqlSugarDB
{
    /// <summary>
    /// 生成实体
    /// </summary>
  public class GenerateEntity
    {
        public static void Entity() {
            SqlSugarClient db = DBSqlServer.DB;
            try
            {
                db.DbFirst.IsCreateDefaultValue().CreateClassFile("C:\\Users\\Administrator\\Desktop\\sqlsugar");
               // LogHelp.info("实体生成完成");
            }
            catch (Exception ex)
            {
                //LogHelp.error("实体生成:"+ ex.Message);
               System.Windows.Forms.MessageBox.Show(ex.Message);
            }
        }
    }
}
           

连接

using LogPrinting;
using SqlSugar;
using System;
using System.Collections.Generic;
using System.Configuration;
using System.Linq;
using System.Text;

namespace SqlSugarDB
{
    public class DBSqlServer
    {
        public SqlSugarClient DB { get; set; }
        public  DBSqlServer ()
        {
             DB = new SqlSugarClient(
            new ConnectionConfig()
            {
                ConnectionString = ConfigLink.connStr,
                DbType = DbType.SqlServer,//设置数据库类型
                IsAutoCloseConnection = true,//自动释放数据务，如果存在事务，在事务结束后释放
                InitKeyType = InitKeyType.Attribute //从实体特性中读取主键自增列信息
            });
            try
            {
                DB.Aop.OnLogExecuting = (sql, pars) =>
            {

                LogText.Loginfo(sql + "\r\n" +
                DB.Utilities.SerializeObject(pars.ToDictionary(it => it.ParameterName, it => it.Value)));
                Console.WriteLine(sql + "\r\n" +
                DB.Utilities.SerializeObject(pars.ToDictionary(it => it.ParameterName, it => it.Value)));
                
            };
                //调式代码 用来打印SQL 
            }
            catch (Exception ex)
            {
                LogText.LogErr("DBSqlServer:"+ ex.Message);
               Console.WriteLine(ex.Message);
            }
            //return DB;
        }
    }
}
           

App.config 配置数据库连接字符串

using System;
using System.Collections.Generic;
using System.Configuration;
using System.Text;

namespace SqlSugarDB
{
    class ConfigLink
    {
        //
     //public static readonly  string connStr = ConfigurationManager.AppSettings["ConnectionString"].ToString();
     //  public static readonly string connStr1 = System.Configuration.ConfigurationManager.AppSettings["SqlServer"].ToString();

        /// <summary>
        /// 获取连接字符串
        /// </summary>
        public static string connStr
        {
            get
            {
                string _connectionString = ConfigurationManager.AppSettings["ConnectionString"];
                
                return _connectionString;
            }
        }
    }
}