public void TestStringFormat() { string v; v = SqlFormat.StringFormatLike("Coucou ", withTrim: false); AssertAreEqual(v, "'Coucou '", "Chaine Like1"); v = SqlFormat.StringFormatLike("Coucou ", withTrim: false, avant: true); AssertAreEqual(v, "'%Coucou '", "Chaine Like2"); v = SqlFormat.StringFormatLike("Coucou ", withTrim: false, apres: true); AssertAreEqual(v, "'Coucou %'", "Chaine Like3"); v = SqlFormat.StringFormatLike("Coucou ", withTrim: false, avant: true, apres: true); AssertAreEqual(v, "'%Coucou %'", "Chaine Like4"); v = SqlFormat.StringFormatLike("Coucou ", avant: false, apres: true, withTrim: true); AssertAreEqual(v, "'Coucou%'", "Chaine Like5"); v = SqlFormat.StringFormatLike("Coucou ", withTrim: true, unicode: true); AssertAreEqual(v, "N'Coucou'", "Chaine Like6"); v = SqlFormat.StringFormat("Coucou les petits ", maxLength: 6); AssertAreEqual(v, "'Coucou'", "Chaine 7"); v = SqlFormat.StringFormat(" ", nullable: true); AssertAreEqual(v, "NULL", "Chaine 8.1"); v = SqlFormat.StringFormat(" ", nullable: false); AssertAreEqual(v, "''", "Chaine 8.2"); v = SqlFormat.StringFormat(string.Empty, nullable: true); AssertAreEqual(v, "NULL", "Chaine 9"); v = SqlFormat.StringFormat(null, nullable: true); AssertAreEqual(v, "NULL", "Chaine 10"); v = SqlFormat.StringFormat(null, 255, nullable: true); AssertAreEqual(v, "NULL", "Chaine 10"); v = SqlFormat.StringFormat("Rock n'roll", unicode: true); AssertAreEqual(v, "N'Rock n''roll'", "Chaine 11"); }