public void TestGuesser_IntFloatString() { MicrosoftSQLTypeTranslater tt = new MicrosoftSQLTypeTranslater(); Guesser t = new Guesser(); t.AdjustToCompensateForValue("-1000"); Assert.AreEqual("int", t.GetSqlDBType(tt)); t.AdjustToCompensateForValue("1.1"); Assert.AreEqual("decimal(5,1)", t.GetSqlDBType(tt)); t.AdjustToCompensateForValue("A"); Assert.AreEqual("varchar(6)", t.GetSqlDBType(tt)); }
public void ExampleUsage_Types() { var tag = DicomDictionary.Default["PatientAddress"]; DatabaseTypeRequest type = DicomTypeTranslater.GetNaturalTypeForVr(tag.DictionaryEntry.ValueRepresentations, tag.DictionaryEntry.ValueMultiplicity); Assert.AreEqual(typeof(string), type.CSharpType); Assert.AreEqual(64, type.MaxWidthForStrings); TypeTranslater tt = new MicrosoftSQLTypeTranslater(); Assert.AreEqual("varchar(64)", tt.GetSQLDBTypeForCSharpType(type)); tt = new OracleTypeTranslater(); Assert.AreEqual("varchar2(64)", tt.GetSQLDBTypeForCSharpType(type)); }