public void SimpleUpdateExpressionMethodTest2() { using (var connect = GetOpenConnection()) { // 匿名对象1 var entity1 = new { CustomerName = "hello", CustomerCity = "x1" }; var updater1 = connect.Update <CustomersEntity>(entity1) .Where(c => c.CustomerID == 2); string sql1 = updater1.SQL; Assert.Equal(sql1, "Update Customers2 SET CustomerName=@CustomerName,CustomerCity=@CustomerCity Where CustomerID = 2"); // 匿名对象2 CustomersEntity entity2 = new CustomersEntity { CustomerName = "hello", CustomerCity = "x1", CustomerNumber = "x123" }; var updater2 = connect.Update <CustomersEntity>(new { entity2.CustomerName, entity2.CustomerCity }) .Where(c => c.CustomerID == 2); string sql2 = updater2.SQL; Assert.Equal(sql2, "Update Customers2 SET CustomerName=@CustomerName,CustomerCity=@CustomerCity Where CustomerID = 2"); // 实体对象/全字段更新且忽略标记了Computed特性的属性 var updater3 = connect.Update <CustomersEntity>(entity2) .Where(c => c.CustomerID == 2); string sql3 = updater3.SQL; } }
public void SetActiveTest2() { using (var connect = GetOpenConnection()) { var customer = new CustomersEntity() { CustomerID = 2, IsActive = false }; bool s = connect.SetActive(customer); Assert.Equal(s, true); } }
public void UpdateCustomer() { using (var connect = GetOpenConnection()) { var customer = new CustomersEntity() { CustomerID = 1, CustomerName = "A1", CustomerCity = "x1", CustomerNumber = "9999" }; //更新实体,不能只更新某些字段 bool s = connect.Update(customer); Assert.Equal(s, true); } }
public void QueryWithSortCustomer() { CustomersEntity entity = null; DapperSort sort = new DapperSort() { new Sort(index: 1, field: nameof(entity.CustomerCity), sortType: ESortType.Asc), new Sort(index: 0, field: nameof(entity.CustomerName), sortType: ESortType.Desc) }; using (var connect = GetOpenConnection()) { var customer = connect.Query <CustomersEntity>(c => c.CustomerID == 1, null, sort); } }
public void InsertCustomer() { using (var connect = GetOpenConnection()) { int count = connect.QuerySingle <int>("select count(1) from Customers2"); var customer = new CustomersEntity() { CustomerName = "A1", CustomerCity = "x1", CustomerNumber = "9999" }; long id = connect.Insert(customer); Assert.Equal(id - 2, count); } }