SQLBuilder \u662f\u4e00\u4e2a\u5f3a\u5927\u7684\u94fe\u5f0f SQL \u6784\u5efa\u5668，\u91c7\u7528\u6d41\u7545\u7684 API \u8bbe\u8ba1，\u8ba9 SQL \u8bed\u53e5\u7684\u6784\u5efa\u53d8\u5f97\u7b80\u5355\u3001\u76f4\u89c2\u4e14\u5b89\u5168\u3002\u5b83\u652f\u6301\u53c2\u6570\u5316\u67e5\u8be2，\u6709\u6548\u9632\u6b62 SQL \u6ce8\u5165\u653b\u51fb，\u540c\u65f6\u63d0\u4f9b\u4e86\u4e30\u5bcc\u7684\u529f\u80fd\u6765\u6ee1\u8db3\u5404\u79cd\u590d\u6742\u7684\u6570\u636e\u5e93\u64cd\u4f5c\u9700\u6c42\u3002<\/p>\n
::: warning \u4e0a\u4e0b\u6587\u7ba1\u7406 \u7531\u4e8e SQLBuilder \u91c7\u7528\u94fe\u5f0f\u8bed\u6cd5，\u57fa\u4e8e\u4e0a\u4e0b\u6587\u6700\u7ec8\u521b\u5efa\u6216\u6267\u884c SQL \u8bed\u53e5，\u56e0\u6b64\u5f53\u7ed3\u675f\u4e00\u6bb5 SQL，\u91cd\u65b0\u5f00\u59cb\u53e6\u5916\u4e00\u6bb5 SQL \u7684\u7f16\u5199\u65f6，\u9700\u8981\u6267\u884c clear() \u65b9\u6cd5\u3002<\/p>\n
\u6ce8\u610f：<\/p>\n
\u901a\u5e38\u901a\u8fc7 DBCash \u5de5\u5382\u7c7b\u83b7\u53d6 SQLBuilder \u5b9e\u4f8b：<\/p>\n
var kit = DBCash.newKit(0); \/\/ 0 \u8868\u793a\u6570\u636e\u5e93\u7d22\u5f15<\/p>\n
var dt = kit.select("*")
\n .from("Users")
\n .where("Status", "1")
\n .query();<\/p>\n
\u8fd9\u4e2a\u7b80\u5355\u7684\u793a\u4f8b\u5c55\u793a\u4e86 SQLBuilder \u7684\u57fa\u672c\u7528\u6cd5：<\/p>\n
select() \u65b9\u6cd5\u7528\u4e8e\u521b\u5efa SELECT \u8bed\u53e5\u540e\u9762\u8ddf\u968f\u7684\u5217\u4fe1\u606f\u3002\u8c03\u7528\u591a\u6b21\u65f6，\u4f1a\u81ea\u52a8\u7528\u9017\u53f7\u62fc\u63a5\u3002\u4e3a\u7a7a\u65f6，\u81ea\u52a8\u4e3a *\u3002<\/p>\n
\/\/ \u67e5\u8be2\u6240\u6709\u5217
\nvar dt = kit.select()
\n .from("Users")
\n .query();<\/p>\n
\/\/ \u67e5\u8be2\u6307\u5b9a\u5217
\nvar dt = kit.select("Id", "Name", "Email")
\n .from("Users")
\n .query();<\/p>\n
\/\/ \u591a\u6b21\u8c03\u7528\u4f1a\u81ea\u52a8\u62fc\u63a5
\nvar dt = kit.select("Id")
\n .select("Name")
\n .select("Email")
\n .from("Users")
\n .query();
\n\/\/ \u751f\u6210\u7684 SQL: SELECT Id, Name, Email FROM Users<\/p>\n
distinct() \u65b9\u6cd5\u4ee3\u8868 SQL \u7684 DISTINCT \u5173\u952e\u5b57，\u7528\u4e8e\u53bb\u9664\u91cd\u590d\u8bb0\u5f55\u3002<\/p>\n
var dt = kit.select("Name")
\n .distinct()
\n .from("Users")
\n .query();
\n\/\/ \u751f\u6210\u7684 SQL: SELECT DISTINCT Name FROM Users<\/p>\n
top() \u65b9\u6cd5\u7528\u4e8e\u53d6\u524d n \u6761\u6570\u636e\u3002<\/p>\n
var dt = kit.select("Id", "Name")
\n .from("Users")
\n .orderby("CreateTime desc")
\n .top(10)
\n .query();
\n\/\/ \u751f\u6210\u7684 SQL: SELECT TOP 10 Id, Name FROM Users ORDER BY CreateTime desc<\/p>\n
from() \u65b9\u6cd5\u7528\u4e8e\u521b\u5efa FROM \u8bed\u53e5\u8ddf\u968f\u7684\u8868\u5b9a\u4e49\u90e8\u5206，\u53ef\u4ee5\u662f\u8868\u3001\u8fde\u63a5\u8bed\u53e5\u3001\u5b50\u67e5\u8be2\u7b49\u3002<\/p>\n
\/\/ \u5355\u8868\u67e5\u8be2
\nvar dt = kit.select("*")
\n .from("Users")
\n .query();<\/p>\n
\/\/ \u591a\u8868\u8fde\u63a5
\nvar dt = kit.select("u.Name", "o.OrgName")
\n .from("Users u left join Organizations o on u.OrgId = o.Id")
\n .query();<\/p>\n
\u8fde\u7eed\u8c03\u7528 from() \u65f6，\u591a\u4e2a from \u5b57\u7b26\u4e32\u4e4b\u95f4\u4f1a\u7528\u9017\u53f7\u8fde\u63a5，\u5f62\u6210 SELECT FROM table a, table b \u8fd9\u6837\u7684\u683c\u5f0f\u3002<\/p>\n
var dt = kit.select("a.Name", "b.Title")
\n .from("Users a")
\n .from("Posts b")
\n .where("a.Id = b.UserId")
\n .query();<\/p>\n
from() \u65b9\u6cd5\u652f\u6301\u5b50\u67e5\u8be2，\u53ef\u4ee5\u4f7f\u7528\u59d4\u6258\u6765\u6784\u5efa\u5b50\u67e5\u8be2：<\/p>\n
int cc = kit
\n .from("a", (d) => {
\n d.select("d.IsFocused", "r.RiskId")
\n .from("DealRecords d join RiskInfo r on d.RiskIssueId = r.Id");
\n })
\n .join("join DangerInfo g on a.RiskId=g.SourceRiskId")
\n .where("a.Index=1")
\n .where("g.DangerType='2'")
\n .setTable("g")
\n .set("DangerLevel", "(case when a.IsFocused='1' then '3' else '1' end) ", false)
\n .doUpdate();<\/p>\n
join() \u65b9\u6cd5\u7528\u4e8e\u6dfb\u52a0\u8fde\u63a5\u8bed\u53e5\u3002\u6ce8\u610f，join() \u65b9\u6cd5\u4e0d\u4f1a\u81ea\u52a8\u62fc\u63a5\u4efb\u4f55 left join \u8fd9\u6837\u7684\u524d\u7f00，\u9700\u8981\u81ea\u884c\u5199\u5b8c\u6574\u7684 join \u8fde\u63a5\u8bed\u53e5\u3002<\/p>\n
var dt = kit.select("u.Name", "d.DeptName")
\n .from("Users u")
\n .join("left join Departments d on u.DeptId = d.Id")
\n .where("u.Status", "1")
\n .query();<\/p>\n
orderby() \u65b9\u6cd5\u7528\u4e8e\u5b9a\u4e49\u6392\u5e8f\u90e8\u5206\u3002<\/p>\n
\/\/ \u5355\u5b57\u6bb5\u6392\u5e8f
\nvar dt = kit.select("*")
\n .from("Users")
\n .orderby("CreateTime desc")
\n .query();<\/p>\n
\/\/ \u591a\u5b57\u6bb5\u6392\u5e8f（\u591a\u6b21\u8c03\u7528）
\nvar dt = kit.select("*")
\n .from("Users")
\n .orderby("Status")
\n .orderby("CreateTime desc")
\n .query();<\/p>\n
groupBy() \u65b9\u6cd5\u7528\u4e8e\u5b9a\u4e49\u5206\u7ec4\u90e8\u5206\u3002<\/p>\n
var dt = kit.select("DepartmentId", "COUNT(*) as UserCount")
\n .from("Users")
\n .groupBy("DepartmentId")
\n .orderby("UserCount desc")
\n .query();<\/p>\n
having() \u65b9\u6cd5\u7528\u4e8e\u5b9a\u4e49\u5206\u7ec4\u7684\u6761\u4ef6\u90e8\u5206，\u901a\u5e38\u4e0e groupBy() \u4e00\u8d77\u4f7f\u7528\u3002<\/p>\n
var dt = kit.select("DepartmentId", "COUNT(*) as UserCount")
\n .from("Users")
\n .groupBy("DepartmentId")
\n .having("COUNT(*) > 10")
\n .query();<\/p>\n
WHERE \u6761\u4ef6\u662f SQLBuilder \u4e2d\u6700\u91cd\u8981\u548c\u6700\u7075\u6d3b\u7684\u90e8\u5206，\u63d0\u4f9b\u4e86\u591a\u79cd\u65b9\u5f0f\u6765\u6784\u5efa\u67e5\u8be2\u6761\u4ef6\u3002<\/p>\n
where() \u65b9\u6cd5\u6709\u591a\u79cd\u91cd\u8f7d\u5f62\u5f0f，\u53ef\u4ee5\u6ee1\u8db3\u5404\u79cd\u67e5\u8be2\u9700\u6c42\u3002<\/p>\n
kit.where("IsDeleted=0")
\n\/\/ \u751f\u6210\u7684 SQL: WHERE IsDeleted=0<\/p>\n
::: warning \u5b89\u5168\u63d0\u793a \u76f4\u63a5\u62fc\u63a5\u5b57\u7b26\u4e32\u5b58\u5728 SQL \u6ce8\u5165\u98ce\u9669，\u5e94\u8c28\u614e\u4f7f\u7528，\u7279\u522b\u662f\u5f53\u6761\u4ef6\u4e2d\u5305\u542b\u7528\u6237\u8f93\u5165\u65f6\u3002 :::<\/p>\n
kit.where("Status", "1")
\n\/\/ \u751f\u6210\u7684 SQL: WHERE Status = @wh_01
\n\/\/ \u53c2\u6570 @wh_01 \u7684\u503c\u4e3a "1"<\/p>\n
\u8fd9\u662f\u6700\u5e38\u7528\u548c\u6700\u5b89\u5168\u7684\u65b9\u5f0f，\u4f1a\u81ea\u52a8\u8fdb\u884c\u53c2\u6570\u5316\u5904\u7406\u3002<\/p>\n
\/\/ \u5927\u4e8e\u6761\u4ef6
\nkit.where("Age", 18, ">")
\n\/\/ \u751f\u6210\u7684 SQL: WHERE Age > @wh_01<\/p>\n
\/\/ \u5c0f\u4e8e\u7b49\u4e8e\u6761\u4ef6
\nkit.where("CreateTime", DateTime.Now, "<=")
\n\/\/ \u751f\u6210\u7684 SQL: WHERE CreateTime <= @wh_01<\/p>\n
\/\/ \u4e0d\u7b49\u4e8e\u6761\u4ef6
\nkit.where("Status", "0", "<>")
\n\/\/ \u751f\u6210\u7684 SQL: WHERE Status <> @wh_01<\/p>\n
\/\/ \u4f7f\u7528 SQL \u51fd\u6570，\u4e0d\u53c2\u6570\u5316
\nkit.where("CreateTime", "getdate()", ">", false)
\n\/\/ \u751f\u6210\u7684 SQL: WHERE CreateTime > getdate()<\/p>\n
\/\/ \u53c2\u6570\u5316\u65b9\u5f0f
\nkit.where("CreateTime", DateTime.Now, ">", true)
\n\/\/ \u751f\u6210\u7684 SQL: WHERE CreateTime > @wh_01<\/p>\n
\u4f7f\u7528\u59d4\u6258\u6765\u6784\u5efa\u590d\u6742\u7684\u5d4c\u5957\u6761\u4ef6，\u59d4\u6258\u5185\u7684\u6761\u4ef6\u4f1a\u81ea\u52a8\u7528\u62ec\u53f7\u5305\u88f9\u3002<\/p>\n
kit.where((w) => {
\n w.where("Status", "1")
\n .where("Age", 18, ">=");
\n})
\n\/\/ \u751f\u6210\u7684 SQL: WHERE (Status = @wh_01 AND Age >= @wh_02)<\/p>\n
whereIn() \u65b9\u6cd5\u7528\u4e8e\u6784\u5efa WHERE field IN (value1, value2, …) \u6761\u4ef6\u3002<\/p>\n
var ids = new List<int> { 1, 2, 3, 4, 5 };
\nkit.whereIn("UserId", ids)
\n\/\/ \u751f\u6210\u7684 SQL: WHERE UserId IN (1, 2, 3, 4, 5)<\/p>\n
whereIn() \u65b9\u6cd5\u5177\u6709\u4ee5\u4e0b\u667a\u80fd\u7279\u6027（2024-6-21 \u66f4\u65b0）：<\/p>\n
\/\/ \u6570\u503c\u578b，\u4e0d\u53c2\u6570\u5316
\nvar ids = new List<int> { 1, 2, 3 };
\nkit.whereIn("UserId", ids)
\n\/\/ \u751f\u6210\u7684 SQL: WHERE UserId IN (1, 2, 3)<\/p>\n
\/\/ \u5b57\u7b26\u4e32\u578b，\u7b80\u5355\u5b57\u7b26\u4e32\u4e0d\u53c2\u6570\u5316
\nvar codes = new List<string> { "A001", "A002", "A003" };
\nkit.whereIn("Code", codes)
\n\/\/ \u751f\u6210\u7684 SQL: WHERE Code IN ('A001', 'A002', 'A003')<\/p>\n
\/\/ \u590d\u6742\u5b57\u7b26\u4e32，\u53c2\u6570\u5316
\nvar names = new List<string> { "\u5f20\u4e09", "\u674e\u56db", "\u738b\u4e94" };
\nkit.whereIn("Name", names)
\n\/\/ \u751f\u6210\u7684 SQL: WHERE Name IN (@wh_01, @wh_02, @wh_03)<\/p>\n
::: warning \u53c2\u6570\u6570\u91cf\u9650\u5236 \u4e00\u4e2a SQL \u7684\u53c2\u6570\u5b58\u5728\u4e0a\u9650，SQL Server \u4e3a 2000\u3002\u5f53 whereIn \u7684\u53c2\u6570\u6570\u91cf\u8d85\u8fc7\u9650\u5236\u65f6，\u53ef\u80fd\u9700\u8981\u5206\u6279\u5904\u7406\u3002 :::<\/p>\n
whereInGuid() \u65b9\u6cd5\u4e13\u95e8\u7528\u4e8e GUID \u4e3b\u952e\u7684 WHERE IN \u6761\u4ef6，\u5fc5\u987b\u662f\u6709\u6548\u7684 GUID，\u5426\u5219\u6761\u4ef6\u5c06\u8f6c\u4e3a\u6c38\u8fdc\u4e0d\u6210\u7acb\u7684 1=2\u3002<\/p>\n
var oids = new List<string> {
\n "00000000-0000-0000-0000-000000000001",
\n "00000000-0000-0000-0000-000000000002"
\n};
\nvar dt = kit.clear()
\n .select("*")
\n .from("DangerInfo")
\n .whereInGuid("SourceRiskId", oids)
\n .query();<\/p>\n
whereGuid() \u65b9\u6cd5\u7528\u4e8e GUID \u4e3b\u952e\u6761\u4ef6，\u81ea\u52a8\u8fdb\u884c GUID \u7684\u6b63\u5219\u6838\u9a8c，\u6838\u9a8c\u5931\u8d25\u65f6\u6761\u4ef6\u8f6c\u4e3a 1=2\u3002<\/p>\n
var danger = kit.select("d.*")
\n .from("DangerInfo d")
\n .whereGuid("DangerId", dangerId)
\n .where("DangerType", "4")
\n .queryRow();<\/p>\n
whereLike() \u65b9\u6cd5\u7528\u4e8e\u6784\u5efa\u5168\u6a21\u7cca\u7684 LIKE \u67e5\u8be2，\u5373\u4e24\u4fa7 %%，\u4ea7\u751f WHERE field LIKE '%value%' \u683c\u5f0f\u7684\u6761\u4ef6\u3002<\/p>\n
kit.whereLike("Title", "\u6d4b\u8bd5")
\n\/\/ \u751f\u6210\u7684 SQL: WHERE Title LIKE '%\u6d4b\u8bd5%'<\/p>\n
whereNotLike() \u65b9\u6cd5\u7528\u4e8e\u6784\u5efa NOT LIKE \u6761\u4ef6\u3002<\/p>\n
kit.whereNotLike("Title", "\u6d4b\u8bd5")
\n\/\/ \u751f\u6210\u7684 SQL: WHERE Title NOT LIKE '%\u6d4b\u8bd5%'<\/p>\n
whereExist() \u65b9\u6cd5\u7528\u4e8e\u6784\u5efa WHERE EXISTS \u6761\u4ef6，\u53ef\u4ee5\u4f7f\u7528\u5b57\u7b26\u4e32\u6216\u59d4\u6258\u3002<\/p>\n
\/\/ \u4f7f\u7528\u5b57\u7b26\u4e32
\nkit.whereExist("SELECT 1 FROM Orders WHERE Orders.UserId = Users.Id")<\/p>\n
\/\/ \u4f7f\u7528\u59d4\u6258（\u63a8\u8350）
\nkit.whereExist((s) => {
\n s.select("1")
\n .from("Orders o")
\n .where("o.UserId = Users.Id");
\n})<\/p>\n
whereNotExist() \u65b9\u6cd5\u7528\u4e8e\u6784\u5efa WHERE NOT EXISTS \u6761\u4ef6\u3002<\/p>\n
kit.whereNotExist((s) => {
\n s.select("1")
\n .from("Orders o")
\n .where("o.UserId = Users.Id");
\n})<\/p>\n
whereFormat() \u65b9\u6cd5\u4f7f\u7528\u5b57\u7b26\u4e32\u6a21\u677f\u8fdb\u884c\u683c\u5f0f\u5316，\u53c2\u6570\u653e\u5165\u5230 SQL \u53c2\u6570\u4e2d\u3002\u683c\u5f0f\u4e3a {0} {1} {2} \u7b49\u6807\u51c6\u5316\u7684 C# String.Format \u8bed\u6cd5\u3002<\/p>\n
kit.whereFormat("(a.field = {0} OR b.field = {1})", contactId, param2)
\n\/\/ \u751f\u6210\u7684 SQL: WHERE (a.field = @wh_01 OR b.field = @wh_02)<\/p>\n
\u5bf9\u4e8e\u590d\u6742\u7684\u6761\u4ef6（\u7efc\u5408\u591a\u4e2a AND\/OR），\u53ef\u4ee5\u4f7f\u7528 sink() \u548c rise() \u65b9\u6cd5\u6765\u7ba1\u7406\u6761\u4ef6\u5206\u7ec4\u3002<\/p>\n
kit.sinkOR()
\n .whereLikeLeft("d.DeptCode", deptCode)
\n .whereLikeLeft("j.DeptCode", deptCode)
\n .rise();<\/p>\n
kit.or((k) => {
\n k.where("IsPublic", "1")
\n .where("DeptId", orgId);
\n});<\/p>\n
whereOR() \u65b9\u6cd5\u7528\u4e8e\u6784\u5efa OR \u6761\u4ef6\u7ec4\u3002<\/p>\n
var dt = kit.select("l.LandId", "d.ScheduleStatus")
\n .from("LandSchedule d join LandInfo l on d.LandId=l.LandId")
\n .where("d.IsEnabled", "1")
\n .whereOR((k) => {
\n k.where("d.AccessLevel", "1") \/\/ \u5168\u516c\u5f00\u7684
\n .whereIn("l.LandId", (u) => { \/\/ \u4f5c\u4e3a\u5de1\u67e5\u5458\u6307\u5b9a\u7684
\n u.select("w.LandId")
\n .from("LandWatcher w")
\n .where("w.UserId", userManager.UserId)
\n .where("w.IsEnabled", "1"); \/\/ \u542f\u7528\u7684
\n });
\n })
\n .query();<\/p>\n
whereNotIn() \u65b9\u6cd5\u7528\u4e8e\u6784\u5efa WHERE NOT IN \u6761\u4ef6，\u652f\u6301\u96c6\u5408\u6216\u5b50\u67e5\u8be2\u3002<\/p>\n
\/\/ \u4f7f\u7528\u96c6\u5408
\nvar excludeIds = new List<int> { 1, 2, 3 };
\nkit.whereNotIn("UserId", excludeIds)<\/p>\n
\/\/ \u4f7f\u7528\u5b50\u67e5\u8be2
\nkit.whereNotIn("UserId", (s) => {
\n s.select("Id")
\n .from("BlockedUsers");
\n})<\/p>\n
\u8981\u70b9：\u9694\u79bb SQL \u6ce8\u5165\u98ce\u9669\u3002<\/p>\n
param1 = RegexUtils.SqlFilter(param1, false);
\nkit.where("a=" + param1)<\/p>\n
kit.where("TaskId in (select TaskId from TaskType c where c.TypeCode=" +
\n kit.addPara("code", typeCode) + ")")<\/p>\n
kit.whereFormat("TaskId in (select TaskId from TaskType c where c.TypeCode={0})", typeCode)<\/p>\n
kit.whereIn("TaskId", (c) => {
\n c.select("TaskId")
\n .from("TaskType c")
\n .where("c.TypeCode", typeCode);
\n})<\/p>\n
setTable() \u65b9\u6cd5\u7528\u4e8e\u8bbe\u7f6e INSERT\u3001UPDATE\u3001DELETE \u8bed\u53e5\u8981\u64cd\u4f5c\u7684\u76ee\u6807\u8868\u3002\u6839\u636e\u4e0a\u4e0b\u6587\u60c5\u51b5\u53ef\u4ee5\u662f\u8868\u540d\u6216\u8005\u522b\u540d\u3002<\/p>\n
kit.setTable("Users")<\/p>\n
set() \u65b9\u6cd5\u7528\u4e8e\u8bbe\u7f6e\u5b57\u6bb5\u540d\u548c\u5bf9\u5e94\u7684\u503c\u3002\u5f53\u4f20\u5165 3 \u4e2a\u53c2\u6570\u65f6，\u6807\u8bc6\u662f\u5426\u53c2\u6570\u5316，\u9ed8\u8ba4\u4e3a\u53c2\u6570\u5316\u3002\u5f53\u9700\u8981\u624b\u52a8\u4f7f\u7528 SQL \u51fd\u6570\u6216\u5b50\u67e5\u8be2\u65f6，\u4f20 false\u3002<\/p>\n
\/\/ \u53c2\u6570\u5316\u65b9\u5f0f（\u63a8\u8350）
\nkit.set("Name", "\u5f20\u4e09")
\nkit.set("Age", 25)
\nkit.set("CreateTime", DateTime.Now)
\n\/\/ \u751f\u6210\u7684 SQL: SET Name = @sp_01, Age = @sp_02, CreateTime = @sp_03<\/p>\n
\/\/ \u975e\u53c2\u6570\u5316\u65b9\u5f0f（\u4f7f\u7528 SQL \u51fd\u6570）
\nkit.set("CreateTime", "getdate()", false)
\n\/\/ \u751f\u6210\u7684 SQL: SET CreateTime = getdate()<\/p>\n
\/\/ \u4f7f\u7528\u5b50\u67e5\u8be2
\nkit.set("TotalCount", "(SELECT COUNT(*) FROM Orders WHERE Orders.UserId = Users.Id)", false)<\/p>\n
int count = kit.setTable("Users")
\n .set("Id", IdHelper.NextId())
\n .set("Name", "\u5f20\u4e09")
\n .set("Email", "zhangsan@example.com")
\n .set("CreateTime", DateTime.Now)
\n .doInsert();<\/p>\n
\u4f7f\u7528 newRow() \u65b9\u6cd5\u53ef\u4ee5\u4e00\u6b21\u63d2\u5165\u591a\u7ec4\u503c\u3002<\/p>\n
kit.setTable("DeptWorker");
\nforeach (DataRow man in dt.Rows)
\n{
\n kit.newRow()
\n .set("DeptWorkerId", Guid.NewGuid())
\n .set("OrgId", row.OrgId)
\n .set("TaskFlag", "1")
\n .set("BelongFlag", "1", false)
\n .set("LastUpdated", DateTime.Now)
\n .set("IsDeleted", "0", false);
\n}
\nvar count = kit.doInsert();<\/p>\n
::: tip \u6ce8\u610f\u4e8b\u9879 \u6bcf\u6b21\u8c03\u7528 newRow() \u4f1a\u5f00\u542f\u4e00\u7ec4\u65b0\u7684 set\u3002\u9700\u8fde\u7eed\u6267\u884c\u76f4\u5230 doInsert()，\u4e0d\u80fd\u4e2d\u65ad\u6267\u884c\u3002\u5982\u679c\u9700\u8981\u6df7\u7528 INSERT\/UPDATE，\u4f7f\u7528 batchSQL \u5904\u7406\u3002 :::<\/p>\n
int count = kit.setTable("Users")
\n .set("Name", "\u674e\u56db")
\n .set("UpdateTime", DateTime.Now)
\n .where("Id", userId)
\n .doUpdate();<\/p>\n
\u521b\u5efa\u5e76\u6267\u884c UPDATE FROM \u8bed\u53e5\u3002<\/p>\n
kit.set("ClassYear", "2022")
\n .set("EndTime", DateTime.Now)
\n .set("TrainType", "p.PostTrainType", false)
\n .set("Days", "p.PostDay", false)
\n .setTable("c")
\n .from("ClassInfo as c left join PostClass p on c.PostClassId=p.PostClassId")
\n .where("c.ClassId in ('" + newClassIds + "')")
\n .doUpdate();<\/p>\n
::: tip \u6570\u636e\u5e93\u5dee\u5f02 \u6ce8\u610f，SQL Server \u4e0b\u548c MySQL \u4e0b\u7684 UPDATE FROM \u8bed\u53e5\u7684\u8bed\u6cd5\u6709\u6240\u533a\u522b，\u56e0\u4e3a MySQL \u53ea\u652f\u6301\u5bf9 INNER JOIN \u8fdb\u884c\u66f4\u65b0，SQL Server \u5141\u8bb8\u4efb\u610f\u7684 JOIN\u3002 :::<\/p>\n
int count = kit.setTable("Users")
\n .where("Status", "0")
\n .where("CreateTime", DateTime.Now.AddYears(-1), "<")
\n .doDelete();<\/p>\n
cc += kit.setTable("WorkerScope")
\n .where("SourceType", "1")
\n .where("WorkerId", " not in", (ckit) => {
\n ckit.select("WorkerId")
\n .from("Worker w")
\n .where("( w.IsEnabled = 1 and w.IsDeleted = 0)");
\n })
\n .doDelete();<\/p>\n
setPage() \u65b9\u6cd5\u7528\u4e8e\u8bbe\u7f6e\u7ffb\u9875\u53c2\u6570\u3002<\/p>\n
kit.setPage(10, 1) \/\/ \u6bcf\u9875 10 \u6761，\u7b2c 1 \u9875<\/p>\n
rowNumber() \u65b9\u6cd5\u662f\u884c\u53f7\u5f00\u7a97\u51fd\u6570，\u4e00\u822c\u7ed3\u5408\u5206\u9875\u4f7f\u7528\u3002<\/p>\n
var dt = kit.select("a.AreaId", "a.CreatedTime")
\n .from("DangerArea a")
\n .where("(a.IsDeleted is null or a.IsDeleted=0)")
\n .setPage(pageSize, pageNum)
\n .rowNumber("AreaIndex", "rowm")
\n .orderby("rowm asc")
\n .query();<\/p>\n
::: tip \u7ffb\u9875\u67e5\u8be2\u6ce8\u610f\u4e8b\u9879 \u7ffb\u9875\u67e5\u8be2\u65f6，orderby \u6761\u4ef6\u5e94\u5199\u5165\u5230 rowNumber() \u65f6，\u6392\u5e8f\u6761\u4ef6\u624d\u4f1a\u88ab\u5e94\u7528\u5230\u5b50\u67e5\u8be2\u4e2d\u3002<\/p>\n
\u7ffb\u9875\u67e5\u8be2\u6784\u5efa\u4e86\u5f62\u5982：<\/p>\n
WITH<\/span> tmp AS<\/span> (<\/span> \u56e0\u6b64，ORDER BY \u88ab\u653e\u7f6e\u5230\u4e86\u5916\u5c42，\u4f1a\u4ea7\u751f\u5f02\u4e8e\u975e\u7ffb\u9875\u67e5\u8be2\u7684\u7ed3\u679c\u3002 :::<\/p>\n queryPaged() \u65b9\u6cd5\u6267\u884c\u5206\u9875\u67e5\u8be2，\u5e76\u8fd4\u56de\u5206\u9875\u4fe1\u606f\u3002<\/p>\n \/\/ \u8fd4\u56de PagedDataTable \/\/ \u8fd4\u56de PageOutput<T> var dt = kit.select("a.*") \/\/ WHERE IN \u5b50\u67e5\u8be2 \/\/ WHERE EXISTS \u5b50\u67e5\u8be2 \/\/ WHERE NOT IN \u5b50\u67e5\u8be2 union() \u65b9\u6cd5\u7528\u4e8e\u5f00\u59cb\u4e00\u4e2a\u65b0\u7684 SELECT \u8bed\u53e5\u5206\u7ec4\u3002<\/p>\n var dt = kit.select("'\u5df2\u5b8c\u6210' as status", "count(*) as count") unionAs() \u65b9\u6cd5\u7528\u4e8e\u8bbe\u7f6e UNION \u8bed\u53e5\u5916\u5c42\u5305\u88f9\u540e AS \u7684\u5b50\u67e5\u8be2\u522b\u540d，\u662f\u5426\u4f7f\u7528 UNION ALL，\u662f\u5426\u5305\u88f9\u7b49\u3002<\/p>\n var dt = kit.select("'\u5df2\u5b8c\u6210' as status", "count(*) as count") ::: tip UNION \u4e0e\u7ffb\u9875 union() \u548c\u7ffb\u9875\u540c\u65f6\u4f7f\u7528\u65f6，\u4f1a\u5148\u6267\u884c UNION \u7684\u8bed\u53e5\u7ec4\u88c5，\u6700\u540e\u6267\u884c\u7ffb\u9875\u7ec4\u88c5\u3002\u56e0\u6b64，\u9ed8\u8ba4\u60c5\u51b5\u4e0b UNION \u8bed\u53e5\u4f1a\u7f6e\u4e8e\u7ffb\u9875\u7684\u8868\u8868\u8fbe\u5f0f\u5185\u90e8，\u5373\u4f4d\u4e8e WITH AS \u8bed\u53e5\u4e2d\u3002 :::<\/p>\n MERGE INTO \u8bed\u53e5\u7528\u4e8e\u6839\u636e\u6e90\u8868\u7684\u6570\u636e\u5bf9\u76ee\u6807\u8868\u8fdb\u884c\u63d2\u5165\u6216\u66f4\u65b0\u64cd\u4f5c\u3002<\/p>\n ::: warning \u6570\u636e\u5e93\u652f\u6301 \u503c\u5f97\u6ce8\u610f\u7684\u662f，\u53ea\u6709 SQL Server \/ Oracle \u6570\u636e\u5e93\u539f\u751f\u652f\u6301\u5b8c\u6574\u7684 MERGE INTO \u8bed\u53e5\u3002 :::<\/p>\n int count = kit.setTable("SysRole") \u5f53\u6765\u6e90\u8868\u5e26\u6709 WHERE \u6761\u4ef6\u65f6，\u9700\u8981\u81ea\u5b9a\u4e49\u6765\u6e90\u8868\u7684\u522b\u540d（mergeAs），\u9ed8\u8ba4\u522b\u540d\u4e3a src\u3002<\/p>\n var count = kit.setTable("DangerInfo") CTE（Common Table Expression，\u516c\u7528\u8868\u8868\u8fbe\u5f0f）\u9012\u5f52\u67e5\u8be2\u7528\u4e8e\u5904\u7406\u6811\u5f62\u7ed3\u6784\u6570\u636e\u3002<\/p>\n \u521b\u5efa\u9012\u5f52 CTE \u8868\u8fbe\u5f0f\u3002<\/p>\n ::: warning \u4e0a\u4e0b\u6587\u5207\u6362 \u6ce8\u610f：withRecurTo() \u5c06\u5207\u6362\u5f53\u524d this \u5230\u9012\u5f52 CTE \u6784\u9020\u5668，\u76f4\u5230\u6267\u884c apply() \u8fd4\u56de SQLBuilder\u3002 :::<\/p>\n var dt = kit.withRecurTo("o") \u4ee5\u4e0a\u8bed\u53e5\u7684\u542b\u4e49：<\/p>\n query() \u65b9\u6cd5\u6267\u884c\u67e5\u8be2，\u5e76\u8fd4\u56de\u4e00\u4e2a DataTable \u7c7b\u5b9e\u4f8b\u3002<\/p>\n DataTable dt = kit.query();<\/p>\n var tar = kit.select("TableName", "TableId", "TableType", "ModifyDate") var list = kit.select("*") \u5c06\u81ea\u52a8\u4f7f\u7528\u7c7b\u578b\u8f6c\u6362\u5668，\u5c06\u67e5\u8be2\u7ed3\u679c\u8f6c\u6362\u4e3a\u7c7b\u578b\u7684\u96c6\u5408\u3002<\/p>\n \u8fd4\u56de\u4e00\u884c\u6570\u636e，\u975e\u4e00\u884c\u5219\u4e3a null\u3002\u67e5\u8be2\u4e00\u884c\u65f6，\u7ed3\u679c\u5fc5\u987b\u4e3a\u4e00\u884c，\u5426\u5219\u8fd4\u56de Null\u3002<\/p>\n var wsRow = kit.clear() \u8fd4\u56de\u4e00\u884c\u4e00\u5217\u7684\u7ed3\u679c，\u975e\u4e00\u884c\u5219\u8fd4\u56de null\u3002<\/p>\n var value = kit.select("COUNT(*)") \u67e5\u8be2\u4e00\u884c\u4e00\u5217\u7684\u67d0\u4e2a\u503c\u3002\u4e0d\u5b58\u5728\u65f6\u8fd4\u56de\u9ed8\u8ba4\u503c\u3002<\/p>\n var value = kit.select("Name") \u67e5\u8be2\u7ed3\u679c\u4e00\u884c\u8f6c\u5b9e\u4f53\u7c7b\u3002<\/p>\n var user = kit.select("*") \u67e5\u8be2\u5355\u4e2a\u503c，\u5e76\u8f6c\u6362\u3002<\/p>\n var count = kit.select("COUNT(*)") \u8fd4\u56de\u67e5\u8be2\u7684\u884c\u6570，\u81ea\u52a8\u4f7f\u7528 SELECT COUNT(*) \u67e5\u8be2\u3002<\/p>\n int count = kit.select("*") \u4ee5\u4e0b\u65b9\u6cd5\u8f93\u51fa\u7ed3\u679c\u4e3a SQLCmd \u5bf9\u8c61，\u5305\u542b SQL \u6587\u672c\u3001\u53c2\u6570\u96c6\u5408\u3002<\/p>\n var sqlCmd = kit.select("*") var sqlCmd = kit.select("*") var sqlCmd = kit.setTable("Users") var sqlCmd = kit.setTable("Users") var sqlCmd = kit.setTable("TargetTable") \u6267\u884c\u4e00\u4e2a\u81ea\u5b9a\u4e49\u7684 SQL \u67e5\u8be2，\u501f\u7528 db \u5b9e\u4f8b\u6267\u884c\u3002<\/p>\n var dt = kit.exeQuery("SELECT * FROM Users WHERE Status = @status", \/\/ \u9519\u8bef\u793a\u4f8b \/\/ \u6b63\u786e\u793a\u4f8b \u4f18\u5148\u4f7f\u7528\u53c2\u6570\u5316\u67e5\u8be2，\u9632\u6b62 SQL \u6ce8\u5165\u653b\u51fb\u3002<\/p>\n \/\/ \u63a8\u8350：\u53c2\u6570\u5316 \/\/ \u4e0d\u63a8\u8350：\u76f4\u63a5\u62fc\u63a5 \u5bf9\u4e8e\u590d\u6742\u7684 AND\/OR \u6761\u4ef6，\u4f7f\u7528 sink()\/rise() \u6216\u59d4\u6258\u65b9\u5f0f\u3002<\/p>\n \/\/ \u63a8\u8350：\u4f7f\u7528\u59d4\u6258 \/\/ \u4e0d\u63a8\u8350：\u76f4\u63a5\u62fc\u63a5\u590d\u6742\u5b57\u7b26\u4e32 \/\/ \u63a8\u8350：\u6e05\u6670\u6613\u8bfb \/\/ \u4e0d\u63a8\u8350：\u96be\u4ee5\u9605\u8bfb var user = kit.select("*") if (user != null) { \u5145\u5206\u5229\u7528\u7c7b\u578b\u8f6c\u6362\u529f\u80fd，\u51cf\u5c11\u624b\u52a8\u6620\u5c04\u4ee3\u7801\u3002<\/p>\n \/\/ \u63a8\u8350：\u81ea\u52a8\u8f6c\u6362 \/\/ \u4e0d\u63a8\u8350：\u624b\u52a8\u8f6c\u6362 SQLBuilder \u662f\u4e00\u4e2a\u529f\u80fd\u5f3a\u5927\u3001\u6613\u4e8e\u4f7f\u7528\u7684 SQL \u6784\u5efa\u5668，\u901a\u8fc7\u94fe\u5f0f\u8bed\u6cd5\u548c\u4e30\u5bcc\u7684 API，\u8ba9\u6570\u636e\u5e93\u64cd\u4f5c\u53d8\u5f97\u7b80\u5355\u3001\u5b89\u5168\u3001\u9ad8\u6548\u3002\u638c\u63e1 SQLBuilder \u7684\u4f7f\u7528，\u53ef\u4ee5\u5927\u5927\u63d0\u9ad8\u5f00\u53d1\u6548\u7387，\u540c\u65f6\u4fdd\u8bc1\u4ee3\u7801\u7684\u5b89\u5168\u6027\u548c\u53ef\u7ef4\u62a4\u6027\u3002<\/p>\n \u672c\u6587\u6863\u6db5\u76d6\u4e86 SQLBuilder \u7684\u4e3b\u8981\u529f\u80fd\u548c\u4f7f\u7528\u65b9\u6cd5，\u5305\u62ec：<\/p>\n \u5e0c\u671b\u672c\u6587\u6863\u80fd\u591f\u5e2e\u52a9\u60a8\u66f4\u597d\u5730\u7406\u89e3\u548c\u4f7f\u7528 SQLBuilder，\u5728\u5b9e\u9645\u5f00\u53d1\u4e2d\u53d1\u6325\u5176\u5f3a\u5927\u7684\u529f\u80fd\u3002<\/p>\n","protected":false},"excerpt":{"rendered":" SQLBuilder \u5b8c\u6574\u6559\u7a0b
\n SELECT<\/span> ROW_NUMBER(<\/span>)<\/span> OVER<\/span> (<\/span>PARTITION<\/span> BY<\/span> .<\/span>.<\/span>.<\/span> ORDER<\/span> BY<\/span> .<\/span>.<\/span>.<\/span>)<\/span> AS<\/span> rowm,<\/span> .<\/span>.<\/span>.<\/span>
\n)<\/span>
\nSELECT<\/span> *<\/span> FROM<\/span> tmp WHERE<\/span> rowm ><\/span> ${pageSize*<\/span>pageNum} ORDER<\/span> BY<\/span> .<\/span>.<\/span>.<\/span><\/p>\nqueryPaged() \u65b9\u6cd5<\/h4>\n
\nPagedDataTable paged = kit.queryPaged();<\/p>\n
\nPageOutput<Task> paged = kit.queryPaged<Task>();<\/p>\n
\n\u5b50\u67e5\u8be2\u4e0e\u8fde\u63a5<\/h3>\n
\u5b50\u67e5\u8be2\u4f5c\u4e3a\u6570\u636e\u6e90<\/h4>\n
\n .from("a", (d) => {
\n d.select("d.IsFocused", "r.RiskId")
\n .from("DealRecords d join RiskInfo r on d.RiskIssueId = r.Id");
\n })
\n .join("join DangerInfo g on a.RiskId=g.SourceRiskId")
\n .where("a.Index=1")
\n .query();<\/p>\n\u5b50\u67e5\u8be2\u4f5c\u4e3a\u6761\u4ef6<\/h4>\n
\nkit.whereIn("UserId", (s) => {
\n s.select("Id")
\n .from("ActiveUsers")
\n .where("Status", "1");
\n})<\/p>\n
\nkit.whereExist((s) => {
\n s.select("1")
\n .from("Orders o")
\n .where("o.UserId = Users.Id");
\n})<\/p>\n
\nkit.where("WorkerId", " not in", (ckit) => {
\n ckit.select("WorkerId")
\n .from("Worker w")
\n .where("( w.IsEnabled = 1 and w.IsDeleted = 0)");
\n})<\/p>\n
\nUNION \u67e5\u8be2<\/h3>\n
union() \u65b9\u6cd5<\/h4>\n
\n .from("Task")
\n .where("Status", "2")
\n .where("TaskType", taskParam.type)
\n .union()
\n .select("'\u8fdb\u884c\u4e2d' as status", "count(*) as count")
\n .from("Task")
\n .where("Status", "1")
\n .where("TaskType", taskParam.type)
\n .query();<\/p>\nunionAs() \u65b9\u6cd5<\/h4>\n
\n .from("Task")
\n .where("Status", "2")
\n .union()
\n .select("'\u8fdb\u884c\u4e2d' as status", "count(*) as count")
\n .from("Task")
\n .where("Status", "1")
\n .unionAs(wrapAsName: "a", isUnionAll: false, wrapSelect: true)
\n .selectUnioned("a.status", "a.count")
\n .query();<\/p>\n
\nMERGE INTO \u8bed\u53e5<\/h3>\n
\u57fa\u672c MERGE INTO<\/h4>\n
\n .from("Responsibility as r")
\n .mergeOn("SysRole.Code=r.RespCode")
\n .set("Name", "r.RespName", false)
\n .set("Remark", "r.Description", false)
\n .set("OrderNo", "r.[Level]", false)
\n .set("DataScope", "r.AccessType", false)
\n .setI("Code", "r.RespCode", false) \/\/ setI \u7528\u4e8e INSERT \u65f6\u7684\u5b57\u6bb5
\n .setI("TenantId", "1300000000001")
\n .setI("IsDeleted", "0", false)
\n .doMergeInto();<\/p>\n\u5e26 WHERE \u6761\u4ef6\u7684 MERGE INTO<\/h4>\n
\n .from("RiskInfo as a")
\n .whereInGuid("a.RiskId", oids)
\n .mergeAs("r")
\n .mergeOn("DangerInfo.SourceRiskId=r.RiskId")
\n .setU("Title", "r.IssueName", false) \/\/ setU \u7528\u4e8e UPDATE \u65f6\u7684\u5b57\u6bb5
\n .setU("DangerLevel", "(case when r.IsFocused='1' then '3' else '1' end) ", false)
\n .doMergeInto();<\/p>\n
\nCTE \u9012\u5f52\u67e5\u8be2<\/h3>\n
withRecurTo() \u65b9\u6cd5<\/h4>\n
\n .select(commonFields)
\n .selectDeep("Depth")
\n .fromRoot("Organization")
\n .joinOn("OrgId", "ParentId")
\n .whereRoot((r, cur) => {
\n r.where(cur.RootAs + ".OrgId", rootId);
\n })
\n .whereNext((n, cur) => {
\n n.where(cur.CTEJoinAs + ".Depth<" + depth);
\n })
\n .apply()
\n .select("*", "(select COUNT(*) from Organization n where n.ParentId=o.OrgId) as childCount")
\n .from("o")
\n .where("o.OrgId", rootId, "<>")
\n .query();<\/p>\n\n
\n\u67e5\u8be2\u7ed3\u679c\u8f6c\u6362<\/h3>\n
query() \u65b9\u6cd5<\/h4>\n
\u624b\u52a8\u8f6c\u6362\u67e5\u8be2\u7ed3\u679c<\/h4>\n
\n .from("SystemTables")
\n .where("TableType = 'U'")
\n .orderby("TableName")
\n .query((row) => {
\n return new TableOutput {
\n ConfigId = configId,
\n EntityName = row["TableName"].ToString(),
\n TableName = row["TableName"].ToString(),
\n TableComment = row["TableName"].ToString()
\n };
\n });<\/p>\n\u81ea\u52a8\u8f6c\u6362\u4e3a\u5b9e\u4f53\u7c7b<\/h4>\n
\n .from("Users")
\n .where("Status", "1")
\n .query<Task>();<\/p>\nqueryRow() \u65b9\u6cd5<\/h4>\n
\n .select("SUM(m.TotalAmount) as totalOut", "SUM(m.TotalUsage) as totalUsed")
\n .from("WaterSource m")
\n .where("m.Year", year)
\n .queryRow();<\/p>\nqueryRowValue() \u65b9\u6cd5<\/h4>\n
\n .from("Users")
\n .queryRowValue();<\/p>\nqueryRowString() \u65b9\u6cd5<\/h4>\n
\n .from("Users")
\n .where("Id", userId)
\n .queryRowString("\u9ed8\u8ba4\u503c");<\/p>\nqueryFirst() \u65b9\u6cd5<\/h4>\n
\n .from("Users")
\n .where("Id", userId)
\n .queryFirst<User>();<\/p>\nqueryScalar() \u65b9\u6cd5<\/h4>\n
\n .from("Users")
\n .queryScalar<int>();<\/p>\ncount() \u65b9\u6cd5<\/h4>\n
\n .from("Users")
\n .where("Status", "1")
\n .count();<\/p>\n
\n\u9ad8\u7ea7\u7279\u6027<\/h3>\n
\u83b7\u53d6 SQL \u8bed\u53e5<\/h4>\n
toSelect() \u65b9\u6cd5<\/h5>\n
\n .from("Users")
\n .where("Status", "1")
\n .toSelect();
\n\/\/ sqlCmd.SQL \u5305\u542b SQL \u6587\u672c
\n\/\/ sqlCmd.Params \u5305\u542b\u53c2\u6570\u96c6\u5408<\/p>\ntoSelectCount() \u65b9\u6cd5<\/h5>\n
\n .from("Users")
\n .where("Status", "1")
\n .toSelectCount();<\/p>\ntoUpdate() \u65b9\u6cd5<\/h5>\n
\n .set("Name", "\u5f20\u4e09")
\n .where("Id", userId)
\n .toUpdate();<\/p>\ntoDelete() \u65b9\u6cd5<\/h5>\n
\n .where("Status", "0")
\n .toDelete();<\/p>\ntoMergeInto() \u65b9\u6cd5<\/h5>\n
\n .from("SourceTable")
\n .mergeOn("TargetTable.Id = SourceTable.Id")
\n .toMergeInto();<\/p>\nexeQuery() \u65b9\u6cd5<\/h4>\n
\n new Paras { { "@status", "1" } });<\/p>\n
\n\u6700\u4f73\u5b9e\u8df5<\/h3>\n
1. \u4e0a\u4e0b\u6587\u7ba1\u7406<\/h4>\n
\n
\nvar dt1 = kit.select("*").from("Table1").query();
\nvar dt2 = kit.select("*").from("Table2").query(); \/\/ \u9519\u8bef！\u4f1a\u5305\u542b Table1 \u7684\u4e0a\u4e0b\u6587<\/p>\n
\nvar dt1 = kit.select("*").from("Table1").query();
\nvar dt2 = kit.clear().select("*").from("Table2").query(); \/\/ \u6b63\u786e<\/p>\n2. \u53c2\u6570\u5316\u67e5\u8be2<\/h4>\n
\nkit.where("Name", userName)<\/p>\n
\nkit.where("Name = '" + userName + "'")<\/p>\n3. \u590d\u6742\u6761\u4ef6\u6784\u5efa<\/h4>\n
\nkit.where((w) => {
\n w.where("Status", "1")
\n .or((o) => {
\n o.where("Type", "A")
\n .where("Type", "B");
\n });
\n})<\/p>\n
\nkit.where("Status = '1' AND (Type = 'A' OR Type = 'B')")<\/p>\n4. \u6027\u80fd\u4f18\u5316<\/h4>\n
\n
5. \u4ee3\u7801\u53ef\u8bfb\u6027<\/h4>\n
\n
\nvar users = kit.clear()
\n .select("Id", "Name", "Email")
\n .from("Users")
\n .where("Status", "1")
\n .where("CreateTime", DateTime.Now.AddYears(-1), ">")
\n .orderby("CreateTime desc")
\n .top(100)
\n .query<User>();<\/p>\n
\nvar users = kit.clear().select("Id","Name","Email").from("Users").where("Status","1").where("CreateTime",DateTime.Now.AddYears(-1),">").orderby("CreateTime desc").top(100).query<User>();<\/p>\n6. \u9519\u8bef\u5904\u7406<\/h4>\n
\n
\n .from("Users")
\n .where("Id", userId)
\n .queryRow();<\/p>\n
\n \/\/ \u5904\u7406\u7528\u6237\u6570\u636e
\n} else {
\n \/\/ \u7528\u6237\u4e0d\u5b58\u5728
\n}<\/p>\n7. \u4f7f\u7528\u7c7b\u578b\u8f6c\u6362<\/h4>\n
\nvar users = kit.select("*")
\n .from("Users")
\n .query<User>();<\/p>\n
\nvar dt = kit.select("*").from("Users").query();
\nvar users = new List<User>();
\nforeach (DataRow row in dt.Rows) {
\n users.Add(new User {
\n Id = Convert.ToInt32(row["Id"]),
\n Name = row["Name"].ToString(),
\n \/\/ …
\n });
\n}<\/p>\n
\n\u603b\u7ed3<\/h3>\n
\n
\n\u76ee\u5f55
\n\u6982\u8ff0\u5feb\u901f\u5f00\u59cbSELECT \u67e5\u8be2\u8bed\u53e5WHERE \u6761\u4ef6\u6784\u5efaINSERT\/UPDATE\/DELETE \u64cd\u4f5c\u5206\u9875\u67e5\u8be2\u5b50\u67e5\u8be2\u4e0e\u8fde\u63a5UNION \u67e5\u8be2MERGE INTO \u8bed\u53e5CTE \u9012\u5f52\u67e5\u8be2\u67e5\u8be2\u7ed3\u679c\u8f6c\u6362\u9ad8\u7ea7\u7279\u6027\u6700\u4f73\u5b9e\u8df5 \u6982\u8ff0
\nSQLBuilder \u662f\u4e00\u4e2a\u5f3a\u5927\u7684\u94fe\u5f0f SQL \u6784\u5efa\u5668，\u91c7\u7528\u6d41\u7545\u7684 API \u8bbe\u8ba1，\u8ba9 SQL \u8bed\u53e5\u7684\u6784\u5efa\u53d8\u5f97\u7b80\u5355\u3001\u76f4\u89c2\u4e14\u5b89\u5168\u3002\u5b83\u652f\u6301\u53c2\u6570\u5316\u67e5\u8be2，\u6709\u6548\u9632\u6b62 SQL \u6ce8\u5165\u653b\u51fbÿ<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[895,6712,55,100],"topic":[],"class_list":["post-63626","post","type-post","status-publish","format-standard","hentry","category-server","tag-net","tag-orm","tag-c","tag-100"],"yoast_head":"\n