public static void AddSpouse(Entities.GameClient client1, Entities.GameClient client2) { client1.SpouseDatabaseUID = client2.DatabaseUID; client2.SpouseDatabaseUID = client1.DatabaseUID; using (var sql = new SqlHandler(Program.Config.ReadString("GameConnectionString"))) { using (var cmd = new SqlCommandBuilder(sql, SqlCommandType.UPDATE, true)) { cmd.AddWhereValue("PlayerID", client1.DatabaseUID); cmd.AddUpdateValue("PlayerSpouseID", client2.DatabaseUID); cmd.Finish("DB_Players"); } sql.Execute(); sql.Forward(Program.Config.ReadString("GameConnectionString"), ""); using (var cmd = new SqlCommandBuilder(sql, SqlCommandType.UPDATE, true)) { cmd.AddWhereValue("PlayerID", client2.DatabaseUID); cmd.AddUpdateValue("PlayerSpouseID", client1.DatabaseUID); cmd.Finish("DB_Players"); } sql.Execute(); } }