Esempio n. 1
0
        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));
        }