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;
            }
        }
    }
}