problème avec StringBuilder

bonjour,
quelle est la différence entre ces deux codes

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 
public Tournee GetTournne(int id)
        {
            Tournee _tournee = null;
            Database db = new OracleDatabase(OracleConnectionString);
            StringBuilder str = new StringBuilder();
 
            str.Append("select TOU_ID, TOU_LIBELLE,tou_Code,AGE_ID,AGE_CTRL_ID,TOU_SECT,TOU_INFORMATION,SEC_ID from O2_TOURNEE where tou_id=:ID");
            DbCommand cmd = db.GetSqlStringCommand(str.ToString());
            db.AddInParameter(cmd, "ID", DbType.Int32, id);
 
 
            using (IDataReader reader = db.ExecuteReader(cmd))
            {
                if (reader.Read())
                {
                    _tournee = new Tournee();
                    _tournee.TourId = OutilData.GetIntFromReader(reader, "TOU_ID");
                    _tournee.TourLibelle = OutilData.GetStringFromReader(reader, "TOU_LIBELLE");
                    _tournee.TourCode = OutilData.GetStringFromReader(reader, "tou_Code");
                    _tournee.AGE_ID = OutilData.GetIntFromReader(reader, "AGE_ID");
                    _tournee.AGE_CTRL_ID = OutilData.GetIntFromReader(reader, "AGE_CTRL_ID");
                    _tournee.TOU_SECT = OutilData.GetStringFromReader(reader, "TOU_SECT");
                    _tournee.TOU_INFORMATION = OutilData.GetStringFromReader(reader, "TOU_INFORMATION");
                    _tournee.SEC_ID = OutilData.GetIntFromReader(reader, "SEC_ID");
 
                }
            }
            return _tournee;
 
        }

et le 2ème

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
public Tournee GetTournne(int id)
        {
            Tournee _tournee = null;
            Database db = new OracleDatabase(OracleConnectionString);
            StringBuilder str = new StringBuilder();
            str.Append("select TOU_ID,");
            str.Append("TOU_LIBELLE,");
            str.Append("tou_Code,");
            str.Append("AGE_ID,");
            str.Append("AGE_CTRL_ID,");
            str.Append("TOU_SECT,");
            str.Append("TOU_INFORMATION,");
            str.Append("SEC_ID");
            str.Append("from O2_TOURNEE");
            str.Append("where tou_id=:ID");
 
            DbCommand cmd = db.GetSqlStringCommand(str.ToString());
            db.AddInParameter(cmd, "ID", DbType.Int32, id);
 
 
            using (IDataReader reader = db.ExecuteReader(cmd))
            {
                if (reader.Read())
                {
                    _tournee = new Tournee();
                    _tournee.TourId = OutilData.GetIntFromReader(reader, "TOU_ID");
                    _tournee.TourLibelle = OutilData.GetStringFromReader(reader, "TOU_LIBELLE");
                    _tournee.TourCode = OutilData.GetStringFromReader(reader, "tou_Code");
                    _tournee.AGE_ID = OutilData.GetIntFromReader(reader, "AGE_ID");
                    _tournee.AGE_CTRL_ID = OutilData.GetIntFromReader(reader, "AGE_CTRL_ID");
                    _tournee.TOU_SECT = OutilData.GetStringFromReader(reader, "TOU_SECT");
                    _tournee.TOU_INFORMATION = OutilData.GetStringFromReader(reader, "TOU_INFORMATION");
                    _tournee.SEC_ID = OutilData.GetIntFromReader(reader, "SEC_ID");
 
                }
            }
            return _tournee;
 
        }

Tout le code est similaire sauf la partie de StringBuilder,
en fait le 1er code tourne sans problème mais le deuxième ne tourne pas comme si la methode "Append" ne veux pas qu'on l'utilise plusieurs fois :lol:

quel est le problème s'il vous plait?