internal void Update() { var sb = new System.Text.StringBuilder(); sb.AppendLine("UPDATE users SET"); sb.AppendLine(" name = @name"); sb.AppendLine(",real_name = @real_name"); sb.AppendLine(",age = @age"); sb.AppendLine(",height = @height"); sb.AppendLine(",weight = @weight"); sb.AppendLine(",blood_type = @blood_type"); sb.AppendLine(",race = @race"); sb.AppendLine(",guild_name = @guild_name"); sb.AppendLine(",hobby = @hobby"); sb.AppendLine(",character_voice = @character_voice"); sb.AppendLine(",birth_month = @birth_month"); sb.AppendLine(",birth_day = @birth_day"); sb.AppendLine("WHERE"); sb.AppendLine("cd = @cd"); var param = new Dictionary <string, object> { { "name", this.Name }, { "real_name", this.RealName }, { "age", this.Age }, { "height", this.Height }, { "weight", this.Weight }, { "blood_type", this.BloodType }, { "race", this.Race }, { "guild_name", this.GuildName }, { "hobby", this.Hobby }, { "character_voice", this.CV }, { "birth_month", this.BirthMonth }, { "birth_day", this.BirthDay } }; using (var q = new SQLiteQuery()) using (var trans = q.BeginTransaction()) { try { q.ExecuteNonQuery(sb.ToString(), param); trans.Commit(); } catch { trans.Rollback(); throw; } } }
internal void Delete() { var sb = new System.Text.StringBuilder(); sb.AppendLine("DELETE FROM users"); sb.AppendLine("WHERE"); sb.AppendLine("cd = @CD"); using (var q = new SQLiteQuery()) using (var trans = q.BeginTransaction()) { try { q.ExecuteNonQuery(sb.ToString(), new Dictionary <string, object> { { "cd", this.Cd } }); trans.Commit(); } catch { trans.Rollback(); throw; } } }