.Net平臺下相容.NET Standard 2.0，一個實現以Lambda表達式轉轉換標準SQL語句，使用強類型操作數據的輕量級ORM工具，在減少魔法字串同時，通過靈活的Lambda表達式組合，實現業務數據查詢的多樣性。 ...
*本文中所用類聲明見上一篇博文《輕量ORM-SqlRepoEx （三）Select語句》中Customers類
一、增加記錄
1、工廠一個實例倉儲
var repository = RepoFactory.Create<Customers>();
2、使用實例增加
Customers customers = new Customers { CustomerID = "YOUR1", CompanyName = "你的公司名1", Phone = "13900000000" };
repository.Insert().For(customers).Go();
當前增加的SQL語句：
INSERT[dbo].[Customers]([CustomerID], [CompanyName], [ContactName], [ContactTitle], [Address], [City], [Region], [PostalCode], [Country], [Phone], [Fax])
VALUES('YOUR1', '你的公司名1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '13900000000', NULL);
3、指定列值增加
repository.Insert().With(m => m.CustomerID, "YOUR1")
.With(m => m.CompanyName, "你的公司名1")
.With(m => m.Phone, "13900000001").Go();
當前增加的SQL語句：
INSERT[dbo].[Customers]
([CustomerID], [CompanyName], [Phone])
VALUES('YOUR1', '你的公司名1', '13900000001');
4、註意事項：
（1）、如果有自增加欄位，需要在對應屬性增加[IdentityFiled] 特性
如： [IdentityFiled]
public string CustomerID { get; set; }
（2）則生成時有 IdentityFiled 特性是的SQL語句
INSERT [dbo].[Customers]([CompanyName], [ContactName], [ContactTitle], [Address], [City], [Region], [PostalCode], [Country], [Phone], [Fax])
VALUES('你的公司名', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1390000000', NULL);
SELECT [CustomerID], [CompanyName], [ContactName], [ContactTitle], [Address], [City], [Region], [PostalCode], [Country], [Phone], [Fax]
FROM [dbo].[Customers]
WHERE [CustomerID] = SCOPE_IDENTITY();
（3）指定列值增加時有 IdentityFiled 特性是的SQL語句
INSERT [dbo].[Customers]([CustomerID], [CompanyName], [Phone])
VALUES('YOUR1', '你的公司名1', '13900000001');
SELECT [CustomerID], [CompanyName], [Phone]
FROM [dbo].[Customers]
WHERE [CustomerID] = SCOPE_IDENTITY();
關於相關特性會在後續博文中介紹
二、更新記錄
1、工廠一個實例倉儲
var repository = RepoFactory.Create<Customers>();
2、使用實例更新
Customers customers = new Customers { CustomerID = "YOURC", CompanyName = "你的公司名", Phone = "1390000000" };
repository.Update().For(customers).Go();
生成的SQL語句
UPDATE [dbo].[Customers]
SET [CustomerID] = 'YOURC', [CompanyName] = '你的公司名', [ContactName] = NULL, [ContactTitle] = NULL, [Address] = NULL, [City] = NULL, [Region] = NULL, [PostalCode] = NULL, [Country] = NULL, [Phone] = '1390000000', [Fax] = NULL WHERE [CustomerID] = 'YOURC', [CompanyName] = '你的公司名';
3、指定列值更新
repository.Update()
.Set(m => m.CompanyName, "你的公司名100")
.Set(m => m.Phone, "13900000023").Where(m => m.CustomerID == "YOUR1").Go())
生成的SQL語句
UPDATE [dbo].[Customers]
SET [CompanyName] = '你的公司名100', [Phone] = '13900000023'
WHERE ([dbo].[Customers].[CustomerID] = 'YOUR1');
三、刪除記錄
1、工廠一個實例倉儲
var repository = RepoFactory.Create<Customers>();
2、使用實例刪除
Customers customers = new Customers { CustomerID = "YOURC", CompanyName = "你的公司名", Phone = "1390000000" };
repository.Delete().For(customers).Go();
生成的SQL語句
DELETE [dbo].[Customers] WHERE [CustomerID] = 'YOURC', [CompanyName] = '你的公司名';
3、指定條件刪除
repository.Delete().Where(m => m.CustomerID == "YOUR1").Go();
生成的SQL語句
DELETE [dbo].[Customers]
WHERE ([dbo].[Customers].[CustomerID] = 'YOUR1');
