{"id":79262,"date":"2026-05-09T17:23:06","date_gmt":"2026-05-09T09:23:06","guid":{"rendered":"https:\/\/www.yimenapp.com\/kb-yimen\/?p=79262"},"modified":"2026-05-09T17:23:06","modified_gmt":"2026-05-09T09:23:06","slug":"sqlsugar%e5%bf%ab%e9%80%9f%e5%bc%80%e5%8f%91%e6%a1%86%e6%9e%b6%e6%8e%a8%e8%8d%90","status":"publish","type":"post","link":"https:\/\/www.yimenapp.com\/kb-yimen\/79262\/","title":{"rendered":"sqlsugar\u5feb\u901f\u5f00\u53d1\u6846\u67b6\u63a8\u8350"},"content":{"rendered":"

SQLSugar\u662f\u4e00\u4e2a\u57fa\u4e8eORM\u6846\u67b6\u7684\u5feb\u901f\u5f00\u53d1\u6846\u67b6\uff0c\u53ef\u4ee5\u65b9\u4fbf\u5730\u8fdb\u884c\u6570\u636e\u5e93<\/a><\/span>\u64cd\u4f5c<\/a><\/span>\uff0c\u63d0\u9ad8\u5f00\u53d1\u6548\u7387\u3002\u4e0b\u9762\u5c31\u6765\u8be6\u7ec6\u4ecb\u7ecd\u4e00\u4e0bSQLSugar\u7684\u539f\u7406\u548c\u4f7f\u7528\u65b9\u6cd5\u3002<\/p>\n

\u4e00\u3001\u539f\u7406<\/p>\n

SQLSugar\u57fa\u4e8eORM\u6846\u67b6\uff0cORM\u5168\u79f0\u4e3aObject-Relational Mapp<\/a><\/span>ing\uff0c\u5373\u5bf9\u8c61\u5173\u7cfb\u6620\u5c04\u3002ORM\u6846\u67b6\u5c06\u6570\u636e<\/a><\/span>\u5e93\u8868\u6620\u5c04\u4e3a\u5bf9\u8c61\uff0c\u5c06\u6570\u636e\u5e93\u64cd\u4f5c\u5c01\u88c5\u4e3a\u5bf9\u8c61\u65b9\u6cd5\uff0c\u4f7f\u5f97\u5f00\u53d1\u8005\u53ef\u4ee5\u4e0d\u7528\u5173\u5fc3\u5e95\u5c42\u6570\u636e\u8bbf\u95ee\u7ec6\u8282\uff0c\u53ea\u9700\u8981\u5173\u6ce8\u4e1a\u52a1\u903b\u8f91\u7684\u5b9e\u73b0\uff0c\u63d0\u9ad8\u5f00\u53d1\u6548\u7387\u3002<\/p>\n

SQLSugar\u91c7\u7528\u4e86Code First\u7684\u5f00\u53d1\u6a21\u5f0f\uff0c\u5373\u5148\u5b9a\u4e49\u5b9e\u4f53\u7c7b\uff0c\u518d\u7531\u5b9e\u4f53\u7c7b\u751f\u6210\u6570\u636e\u5e93\u8868\u3002\u5f00\u53d1\u8005\u53ea\u9700\u8981\u7f16\u5199\u5b9e\u4f53\u7c7b\uff0c\u5c31\u53ef\u4ee5\u81ea\u52a8\u751f\u6210\u6570\u636e\u5e93\u8868\u548c\u6570\u636e\u8bbf\u95ee\u65b9\u6cd5\u3002SQLSugar\u652f\u6301\u591a\u79cd\u6570\u636e\u5e93\u7c7b\u578b\uff0c\u5305\u62ecSQL Server\u3001MySQL\u3001Oracle\u3001SQLite\u7b49\u3002<\/p>\n

\u4e8c\u3001\u4f7f\u7528\u65b9\u6cd5<\/p>\n

1. \u5b89\u88c5SQLSugar<\/p>\n

\u53ef\u4ee5\u901a\u8fc7Nuget\u5305\u7ba1\u7406\u5668\u5b89\u88c5SQLSugar\uff0c\u4e5f\u53ef\u4ee5\u4eceGitHub\u4e0a\u4e0b\u8f7d\u6e90\u4ee3\u7801\u624b\u52a8\u5b89\u88c5\u3002<\/p>\n

2. \u5b9a\u4e49\u5b9e\u4f53\u7c7b<\/p>\n

\u5b9a\u4e49\u5b9e\u4f53\u7c7b\u65f6\u9700\u8981\u4f7f\u7528\u7279\u6b8a\u7684\u6807\u8bb0\uff0c\u4f8b\u5982\uff1a<\/p>\n

“`<\/p>\n

[SugarTable(“User”)]<\/p>\n

public class User<\/p>\n

{<\/p>\n

[SugarColumn(IsPrimaryKey = true, IsIdentity = true)]<\/p>\n

public int Id { get; set; }<\/p>\n

[SugarColumn(Length = 50, IsNullable = false)]<\/p>\n

public string Name { get; set; }<\/p>\n

[SugarCo<\/p>\n

<\/figure><\/p>\n

lumn(Length = 50, IsNullable = false)]<\/p>\n

public string Password { get; set; }<\/p>\n

}<\/p>\n

“`<\/p>\n

\u5728\u8fd9\u4e2a\u4f8b\u5b50\u4e2d\uff0c\u4f7f\u7528\u4e86SugarTable\u548cSugarColumn\u4e24\u4e2a\u7279\u6b8a\u7684\u6807\u8bb0\u3002SugarTable\u7528\u4e8e\u6307\u5b9a\u6570\u636e\u5e93\u8868\u540d\uff0cSugarColumn\u7528\u4e8e\u6307\u5b9a\u5b9e\u4f53\u7c7b\u5c5e\u6027\u5bf9\u5e94\u7684\u6570\u636e\u5e93\u5b57\u6bb5\u540d\u3001\u5c5e\u6027\u957f\u5ea6\u3001\u662f\u5426\u5141\u8bb8\u4e3a\u7a7a\u7b49\u4fe1\u606f\u3002<\/p>\n

3. \u6570\u636e\u5e93\u8fde\u63a5\u914d\u7f6e<\/p>\n

\u5728\u4f7f\u7528SQLSugar\u4e4b\u524d\uff0c\u9700\u8981\u5148\u914d\u7f6e\u6570\u636e\u5e93\u8fde\u63a5\u4fe1\u606f\u3002\u53ef\u4ee5\u4f7f\u7528\u4ee5\u4e0b\u4ee3\u7801\u914d\u7f6e\u6570\u636e\u5e93\u8fde\u63a5\uff1a<\/p>\n

“`<\/p>\n

SqlSugarClient db = new SqlSugarClient(new ConnectionConfig()<\/p>\n

{<\/p>\n

ConnectionString = “serve\u754c\u9762\u5e94\u7528\u7a0b\u5e8f\u5f00\u53d1\u6846\u67b6<\/a>r=127.0.0.1;database=test;uid=root;pwd=123456;”,<\/p>\n

DbType = DbType.MySql,<\/p>\n

IsAutoCloseConnection = true,<\/p>\n

});<\/p>\n

“`<\/p>\n

\u5728\u8fd9\u4e2a\u4f8b\u5b50\u4e2d\uff0c\u4f7f\u7528\u4e86ConnectionConfig\u7c7b\u914d\u7f6e\u6570\u636e\u5e93\u8fde\u63a5\u4fe1\u606f\uff0c\u5305\u62ec\u8fde\u63a5\u5b57\u7b26\u4e32\u3001\u6570\u636e\u5e93\u7c7b\u578b\u3001\u662f\u5426\u81ea\u52a8\u5173\u95ed\u8fde\u63a5\u7b49\u4fe1\u606f\u3002<\/p>\n

4. \u6570\u636e\u5e93\u64cd\u4f5c<\/p>\n

\u901a\u8fc7SQLSugar\u53ef\u4ee5\u8fdb\u884c\u5404\u79cd\u6570\u636e\u5e93\u64cd\u4f5c\uff0c\u5305\u62ec\u589e\u5220\u6539\u67e5\u7b49\u3002\u4ee5\u4e0b\u662f\u4e00\u4e9b\u4f8b\u5b50\uff1a<\/p>\n

“`<\/p>\n

\/\/\u63d2\u5165\u6570\u636e<\/p>\n

User user = new User() { Name = “Tom”, Password = “123456” };<\/p>\n

int id = db.Insertable(user).ExecuteReturnIdentity();<\/p>\n

\/\/\u66f4\u65b0\u6570\u636e<\/p>\n

int result = db.Updateable().SetColumns(u => new Uservue\u624b\u673aapp<\/a>() { Password = “654321” }).Where(u => u.Name == “Tom”).ExecuteCommand();<\/p>\n

\/\/\u5220\u9664\u6570\u636e<\/p>\n

int result = db.Deleteable().Where(u => u.Name == “Tom”).ExecuteCommand();<\/p>\n

\/\/\u67e5\u8be2\u6570\u636e<\/p>\n

List userList = db.Queryable().Where(u => u.Name.Contains(“T”)).ToList();<\/p>\n

“`<\/p>\n

\u5728\u8fd9\u4e9b\u4f8b\u5b50\u4e2d\uff0c\u4f7f\u7528\u4e86Insertable\u3001Updateable\u3001Deleteable\u548cQueryable\u7b49\u65b9\u6cd5\u8fdb\u884c\u6570\u636e\u5e93\u64cd\u4f5c\u3002\u5176\u4e2d\uff0cInsertable\u7528\u4e8e\u63d2\u5165\u6570\u636e\uff0cUpdateable\u7528\u4e8e\u66f4\u65b0\u6570\u636e\uff0cDeleteable\u7528\u4e8e\u5220\u9664\u6570\u636e\uff0cQueryable\u7528\u4e8e\u67e5\u8be2\u6570\u636e\u3002<\/p>\n

5. \u5176\u4ed6\u529f\u80fd<\/p>\n

SQLSugar\u8fd8\u63d0\u4f9b\u4e86\u4e00\u4e9b\u5176\u4ed6\u7684\u529f\u80fd\uff0c\u4f8b\u5982\u5206\u9875\u67e5\u8be2\u3001\u4e8b\u52a1\u5904\u7406\u3001\u591a\u8868\u67e5\u8be2\u7b49\u3002\u4ee5\u4e0b\u662f\u4e00\u4e9b\u4f8b\u5b50\uff1a<\/p>\n

“`<\/p>\n

\/\/\u5206\u9875\u67e5\u8be2<\/p>\n

List userList = db.Queryable().Where(u => u.Name.Contains(“T”)).OrderBy(u => u.Id).ToPageList(1, 10);<\/p>\n

\/\/\u4e8b\u52a1\u5904\u7406<\/p>\n

db.Ado.BeginTran();<\/p>\n

try<\/p>\n

{<\/p>\n

db.Insertable(new User() { Name = “Tom”, Password = “123456” }).ExecuteCommand();<\/p>\n

db.Insertable(new User() { Name = “Jerry”, Password = “654321” }).ExecuteCommand();<\/p>\n

db.Ado.CommitTran();<\/p>\n

}<\/p>\n

catch (Exception ex)<\/p>\n

{<\/p>\n

db.Ado.RollbackTran();<\/p>\n

}<\/p>\n

\/\/\u591a\u8868\u67e5\u8be2<\/p>\n

var query = db.Queryable((u, o) => new object[] {<\/p>\n

JoinType.Left, u.Id == o.UserId<\/p>\n

}).Select((u, o) => new {<\/p>\n

UserId = u.Id,<\/p>\n

UserName = u.Name,<\/p>\n

OrderId = o.Id,<\/p>\n

OrderNo = o.OrderNo<\/p>\n

}).Where((u, o) => u.Name.Contains(“T”));<\/p>\n

“`<\/p>\n

\u5728\u8fd9\u4e9b\u4f8b\u5b50\u4e2d\uff0c\u4f7f\u7528\u4e86ToPageList\u3001BeginTran\u3001CommitTran\u3001RollbackTran\u548cJoinType\u7b49\u65b9\u6cd5\u8fdb\u884c\u5206\u9875\u67e5\u8be2\u3001\u4e8b\u52a1\u5904\u7406\u3001\u591a\u8868\u67e5\u8be2\u7b49\u64cd\u4f5c\u3002<\/p>\n

\u4e09\u3001\u603b\u7ed3<\/p>\n

SQLSugar\u662f\u4e00\u4e2a\u57fa\u4e8eORM\u6846\u67b6\u7684\u5feb\u901f\u5f00\u53d1\u6846\u67b6\uff0c\u53ef\u4ee5\u65b9\u4fbf\u5730\u8fdb\u884c\u6570\u636e\u5e93\u64cd\u4f5c\uff0c\u63d0\u9ad8\u5f00\u53d1\u6548\u7387\u3002SQLSugar\u91c7\u7528\u4e86Code First\u7684\u5f00\u53d1\u6a21\u5f0f\uff0c\u652f\u6301\u591a\u79cd\u6570\u636e\u5e93\u7c7b\u578b\u3002\u4f7f\u7528SQLSugar\u9700\u8981\u5148\u5b9a\u4e49\u5b9e\u4f53\u7c7b\uff0c\u7136\u540e\u914d\u7f6e\u6570\u636e\u5e93\u8fde\u63a5\u4fe1\u606f\uff0c\u6700\u540e\u8fdb\u884c\u5404\u79cd\u6570\u636e\u5e93\u64cd\u4f5c\u3002SQLSugar\u8fd8\u63d0\u4f9b\u4e86\u4e00\u4e9b\u5176\u4ed6\u7684\u529f\u80fd\uff0c\u4f8b\u5982\u5206\u9875\u67e5\u8be2\u3001\u4e8b\u52a1\u5904\u7406\u3001\u591a\u8868\u67e5\u8be2\u7b49\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"

SQLSugar\u662f\u4e00\u4e2a\u57fa\u4e8eORM\u6846\u67b6\u7684\u5feb\u901f\u5f00\u53d1\u6846\u67b6\uff0c\u53ef\u4ee5\u65b9\u4fbf\u5730\u8fdb\u884c\u6570\u636e\u5e93\u64cd\u4f5c\uff0c\u63d0\u9ad8\u5f00\u53d1\u6548\u7387\u3002\u4e0b\u9762\u5c31\u6765\u8be6\u7ec6\u4ecb\u7ecd\u4e00\u4e0bSQLSugar\u7684\u539f\u7406\u548c\u4f7f\u7528\u65b9\u6cd5\u3002\u4e00\u3001\u539f\u7406SQLSugar\u57fa\u4e8eORM\u6846\u67b6\uff0cORM\u5168\u79f0\u4e3a<\/p>\n","protected":false},"author":21,"featured_media":0,"comment_status":"","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8057],"tags":[51363,51364,1893,1934,5804],"special":[],"attr":[],"class_list":{"0":"post-79262","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"hentry","6":"category-appkaifa","7":"tag-app","9":"tag-1893","10":"tag-1934","11":"tag-5804","12":"entry"},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.yimenapp.com\/kb-yimen\/wp-json\/wp\/v2\/posts\/79262","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.yimenapp.com\/kb-yimen\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.yimenapp.com\/kb-yimen\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.yimenapp.com\/kb-yimen\/wp-json\/wp\/v2\/users\/21"}],"replies":[{"embeddable":true,"href":"https:\/\/www.yimenapp.com\/kb-yimen\/wp-json\/wp\/v2\/comments?post=79262"}],"version-history":[{"count":1,"href":"https:\/\/www.yimenapp.com\/kb-yimen\/wp-json\/wp\/v2\/posts\/79262\/revisions"}],"predecessor-version":[{"id":79301,"href":"https:\/\/www.yimenapp.com\/kb-yimen\/wp-json\/wp\/v2\/posts\/79262\/revisions\/79301"}],"wp:attachment":[{"href":"https:\/\/www.yimenapp.com\/kb-yimen\/wp-json\/wp\/v2\/media?parent=79262"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.yimenapp.com\/kb-yimen\/wp-json\/wp\/v2\/categories?post=79262"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.yimenapp.com\/kb-yimen\/wp-json\/wp\/v2\/tags?post=79262"},{"taxonomy":"special","embeddable":true,"href":"https:\/\/www.yimenapp.com\/kb-yimen\/wp-json\/wp\/v2\/special?post=79262"},{"taxonomy":"attr","embeddable":true,"href":"https:\/\/www.yimenapp.com\/kb-yimen\/wp-json\/wp\/v2\/attr?post=79262"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}