public static void SetLastLoginTime(string username) { var t = APDBDef.ResUser; var query = APQuery.update(t) .set(t.LastLoginTime, DateTime.Now) .set(t.LoginCount, APSqlThroughExpr.Expr("LoginCount + 1")) .where (t.UserName == username); using (var db = new APDBDef()) { db.ExecuteNonQuery(query); } }