在使用数据库的过程中,经常会碰到此类需求:生成语句:UPDATE dbo.UserInfo SET UserName = UserName + '_old' WHERE UserID = 1
此次更新,为该功能添加了支持:
组件版本号:V1.0.0.2
//首先定义实体类定义 public class UserInfo { public int UserID { get; set; } public string UserName { get; set; } public string NickName { get; set; } public int Sex { get; set; } public string HeadPic { get; set; } public string Introduction { get; set; } public string Other { get ; set; } public DateTime RegTime { get; set; } } Public string GetSql() { string sql = SqlBuilder<UserInfo>.From(user, "dbo.UserInfo") .Update() .Set(u => u.UserName, u => u.UserName, "+", "_old") .Where(u => u.UserID) .And(u=>u.UserName, MatchType.In, "user1", "user2", "user3") .GetSql(); } //或者 Public string GetSql() { string sql = SqlBuilder.From("dbo.UserInfo") .Update() .Set("UserName", "UserName", "+", "_old") .Where("UserID", 1) .GetSql(); }