コード例 #1
0
        public void PropertiesSet()
        {
            TestDetachedQuery tdq = new TestDetachedQuery();

            tdq.SetMaxResults(10).SetFirstResult(5).SetCacheable(true).SetReadOnly(true).SetTimeout(444).SetFlushMode(
                FlushMode.Auto).SetCacheRegion("A_REGION").SetResultTransformer(new AliasToBeanResultTransformer(typeof(NoFoo))).
            SetIgnoreUknownNamedParameters(true).SetComment(MyComment);
            Assert.AreEqual(10, tdq.Selection.MaxRows);
            Assert.AreEqual(5, tdq.Selection.FirstRow);
            Assert.AreEqual(444, tdq.Selection.Timeout);
            Assert.IsTrue(tdq.Cacheable);
            Assert.IsTrue(tdq.ReadOnly);
            Assert.AreEqual(FlushMode.Auto, tdq.FlushMode);
            Assert.AreEqual("A_REGION", tdq.CacheRegion);
            Assert.IsNotNull(tdq.ResultTransformer);
            Assert.IsTrue(tdq.ShouldIgnoredUnknownNamedParameters);
            Assert.That(tdq.Comment, Is.EqualTo(MyComment));

            tdq.SetLockMode("LM1", LockMode.Upgrade);
            tdq.SetLockMode("LM2", LockMode.Write);
            Assert.AreEqual(2, tdq.LockModes.Count);
            Assert.IsTrue(tdq.LockModes.ContainsKey("LM1"));
            Assert.AreEqual(LockMode.Upgrade, tdq.LockModes["LM1"]);
            Assert.IsTrue(tdq.LockModes.ContainsKey("LM2"));
            Assert.AreEqual(LockMode.Write, tdq.LockModes["LM2"]);

            tdq.SetProperties(new Foo("Pallino", "Pinco"));
            tdq.SetProperties(new Foo("Fulano", "De Tal"));
            Assert.AreEqual(2, tdq.OptionalUntypeParams.Count);
            Assert.IsTrue(tdq.OptionalUntypeParams[0].Equals(new Foo("Pallino", "Pinco")));
            Assert.IsTrue(tdq.OptionalUntypeParams[1].Equals(new Foo("Fulano", "De Tal")));

            tdq.SetAnsiString(1, "");
            tdq.SetBinary(2, new byte[] { });
            tdq.SetBoolean(3, false);
            tdq.SetByte(4, 255);
            tdq.SetCharacter(5, 'A');
            tdq.SetDateTime(6, DateTime.MaxValue);
            tdq.SetDecimal(7, 10.15m);
            tdq.SetDouble(8, 8.1f);
            tdq.SetEntity(9, new Foo("Fulano", "De Tal"));
            tdq.SetEnum(10, FlushMode.Auto);
            tdq.SetInt16(11, 1);
            tdq.SetInt32(12, 1);
            tdq.SetInt64(13, 1);
            tdq.SetSingle(14, 1.1f);
            tdq.SetString(15, "");
            tdq.SetTime(16, DateTime.Now);
            tdq.SetTimestamp(17, DateTime.Now);
            tdq.SetGuid(18, Guid.Empty);
            Assert.IsTrue(tdq.PosParams[1].Type.Equals(NHibernateUtil.AnsiString));
            Assert.IsTrue(tdq.PosParams[2].Type.Equals(NHibernateUtil.Binary));
            Assert.IsTrue(tdq.PosParams[3].Type.Equals(NHibernateUtil.Boolean));
            Assert.IsTrue(tdq.PosParams[4].Type.Equals(NHibernateUtil.Byte));
            Assert.IsTrue(tdq.PosParams[5].Type.Equals(NHibernateUtil.Character));
            Assert.IsTrue(tdq.PosParams[6].Type.Equals(NHibernateUtil.DateTime));
            Assert.IsTrue(tdq.PosParams[7].Type.Equals(NHibernateUtil.Decimal));
            Assert.IsTrue(tdq.PosParams[8].Type.Equals(NHibernateUtil.Double));
            Assert.IsTrue(tdq.PosParams[9].Type.Equals(NHibernateUtil.Entity(typeof(Foo))));
            Assert.IsTrue(tdq.PosParams[10].Type.Equals(NHibernateUtil.Enum(typeof(FlushMode))));
            Assert.IsTrue(tdq.PosParams[11].Type.Equals(NHibernateUtil.Int16));
            Assert.IsTrue(tdq.PosParams[12].Type.Equals(NHibernateUtil.Int32));
            Assert.IsTrue(tdq.PosParams[13].Type.Equals(NHibernateUtil.Int64));
            Assert.IsTrue(tdq.PosParams[14].Type.Equals(NHibernateUtil.Single));
            Assert.IsTrue(tdq.PosParams[15].Type.Equals(NHibernateUtil.String));
            Assert.IsTrue(tdq.PosParams[16].Type.Equals(NHibernateUtil.Time));
            Assert.IsTrue(tdq.PosParams[17].Type.Equals(NHibernateUtil.Timestamp));
            Assert.IsTrue(tdq.PosParams[18].Type.Equals(NHibernateUtil.Guid));

            tdq.SetAnsiString("1", "");
            tdq.SetBinary("2", new byte[] { });
            tdq.SetBoolean("3", false);
            tdq.SetByte("4", 255);
            tdq.SetCharacter("5", 'A');
            tdq.SetDateTime("6", DateTime.MaxValue);
            tdq.SetDecimal("7", 10.15m);
            tdq.SetDouble("8", 8.1f);
            tdq.SetEntity("9", new Foo("Fulano", "De Tal"));
            tdq.SetEnum("10", FlushMode.Auto);
            tdq.SetInt16("11", 1);
            tdq.SetInt32("12", 1);
            tdq.SetInt64("13", 1);
            tdq.SetSingle("14", 1.1f);
            tdq.SetString("15", "");
            tdq.SetTime("16", DateTime.Now);
            tdq.SetTimestamp("17", DateTime.Now);
            tdq.SetGuid("18", Guid.Empty);
            Assert.IsTrue(tdq.NamedParams["1"].Type.Equals(NHibernateUtil.AnsiString));
            Assert.IsTrue(tdq.NamedParams["2"].Type.Equals(NHibernateUtil.Binary));
            Assert.IsTrue(tdq.NamedParams["3"].Type.Equals(NHibernateUtil.Boolean));
            Assert.IsTrue(tdq.NamedParams["4"].Type.Equals(NHibernateUtil.Byte));
            Assert.IsTrue(tdq.NamedParams["5"].Type.Equals(NHibernateUtil.Character));
            Assert.IsTrue(tdq.NamedParams["6"].Type.Equals(NHibernateUtil.DateTime));
            Assert.IsTrue(tdq.NamedParams["7"].Type.Equals(NHibernateUtil.Decimal));
            Assert.IsTrue(tdq.NamedParams["8"].Type.Equals(NHibernateUtil.Double));
            Assert.IsTrue(tdq.NamedParams["9"].Type.Equals(NHibernateUtil.Entity(typeof(Foo))));
            Assert.IsTrue(tdq.NamedParams["10"].Type.Equals(NHibernateUtil.Enum(typeof(FlushMode))));
            Assert.IsTrue(tdq.NamedParams["11"].Type.Equals(NHibernateUtil.Int16));
            Assert.IsTrue(tdq.NamedParams["12"].Type.Equals(NHibernateUtil.Int32));
            Assert.IsTrue(tdq.NamedParams["13"].Type.Equals(NHibernateUtil.Int64));
            Assert.IsTrue(tdq.NamedParams["14"].Type.Equals(NHibernateUtil.Single));
            Assert.IsTrue(tdq.NamedParams["15"].Type.Equals(NHibernateUtil.String));
            Assert.IsTrue(tdq.NamedParams["16"].Type.Equals(NHibernateUtil.Time));
            Assert.IsTrue(tdq.NamedParams["17"].Type.Equals(NHibernateUtil.Timestamp));
            Assert.IsTrue(tdq.NamedParams["18"].Type.Equals(NHibernateUtil.Guid));

            tdq.SetParameter(10, 123456m);
            Assert.AreEqual(1, tdq.PosUntypeParams.Count);
            Assert.IsTrue(tdq.PosUntypeParams.ContainsKey(10));

            tdq.SetParameter("Any", 123456m);
            Assert.AreEqual(1, tdq.NamedUntypeParams.Count);
            Assert.IsTrue(tdq.NamedUntypeParams.ContainsKey("Any"));

            tdq.SetParameterList("UntypedList", new int[] { 1, 2, 3 });
            Assert.IsTrue(tdq.NamedUntypeListParams.ContainsKey("UntypedList"));

            tdq.SetParameterList("TypedList", new Int64[] { 1, 2, 3 }, NHibernateUtil.Int64);
            Assert.IsTrue(tdq.NamedListParams.ContainsKey("TypedList"));
            Assert.IsNotNull((tdq.NamedListParams["TypedList"].Value as IEnumerable));
        }
コード例 #2
0
		public void PropertiesSet()
		{
			TestDetachedQuery tdq = new TestDetachedQuery();
			tdq.SetMaxResults(10).SetFirstResult(5).SetCacheable(true).SetReadOnly(true).SetTimeout(444).SetFlushMode(
				FlushMode.Auto).SetCacheRegion("A_REGION").SetResultTransformer(new AliasToBeanResultTransformer(typeof(NoFoo))).
				SetIgnoreUknownNamedParameters(true).SetComment(MyComment);
			Assert.AreEqual(10, tdq.Selection.MaxRows);
			Assert.AreEqual(5, tdq.Selection.FirstRow);
			Assert.AreEqual(444, tdq.Selection.Timeout);
			Assert.IsTrue(tdq.Cacheable);
			Assert.IsTrue(tdq.ReadOnly);
			Assert.AreEqual(FlushMode.Auto, tdq.FlushMode);
			Assert.AreEqual("A_REGION", tdq.CacheRegion);
			Assert.IsNotNull(tdq.ResultTransformer);
			Assert.IsTrue(tdq.ShouldIgnoredUnknownNamedParameters);
			Assert.That(tdq.Comment, Is.EqualTo(MyComment));

			tdq.SetLockMode("LM1", LockMode.Upgrade);
			tdq.SetLockMode("LM2", LockMode.Write);
			Assert.AreEqual(2, tdq.LockModes.Count);
			Assert.IsTrue(tdq.LockModes.ContainsKey("LM1"));
			Assert.AreEqual(LockMode.Upgrade, tdq.LockModes["LM1"]);
			Assert.IsTrue(tdq.LockModes.ContainsKey("LM2"));
			Assert.AreEqual(LockMode.Write, tdq.LockModes["LM2"]);

			tdq.SetProperties(new Foo("Pallino", "Pinco"));
			tdq.SetProperties(new Foo("Fulano", "De Tal"));
			Assert.AreEqual(2, tdq.OptionalUntypeParams.Count);
			Assert.IsTrue(tdq.OptionalUntypeParams[0].Equals(new Foo("Pallino", "Pinco")));
			Assert.IsTrue(tdq.OptionalUntypeParams[1].Equals(new Foo("Fulano", "De Tal")));

			tdq.SetAnsiString(1, "");
			tdq.SetBinary(2, new byte[] { });
			tdq.SetBoolean(3, false);
			tdq.SetByte(4, 255);
			tdq.SetCharacter(5, 'A');
			tdq.SetDateTime(6, DateTime.MaxValue);
			tdq.SetDecimal(7, 10.15m);
			tdq.SetDouble(8, 8.1f);
			tdq.SetEntity(9, new Foo("Fulano", "De Tal"));
			tdq.SetEnum(10, FlushMode.Auto);
			tdq.SetInt16(11, 1);
			tdq.SetInt32(12, 1);
			tdq.SetInt64(13, 1);
			tdq.SetSingle(14, 1.1f);
			tdq.SetString(15, "");
			tdq.SetTime(16, DateTime.Now);
			tdq.SetTimestamp(17, DateTime.Now);
			tdq.SetGuid(18, Guid.Empty);
			Assert.IsTrue(tdq.PosParams[1].Type.Equals(NHibernateUtil.AnsiString));
			Assert.IsTrue(tdq.PosParams[2].Type.Equals(NHibernateUtil.Binary));
			Assert.IsTrue(tdq.PosParams[3].Type.Equals(NHibernateUtil.Boolean));
			Assert.IsTrue(tdq.PosParams[4].Type.Equals(NHibernateUtil.Byte));
			Assert.IsTrue(tdq.PosParams[5].Type.Equals(NHibernateUtil.Character));
			Assert.IsTrue(tdq.PosParams[6].Type.Equals(NHibernateUtil.DateTime));
			Assert.IsTrue(tdq.PosParams[7].Type.Equals(NHibernateUtil.Decimal));
			Assert.IsTrue(tdq.PosParams[8].Type.Equals(NHibernateUtil.Double));
			Assert.IsTrue(tdq.PosParams[9].Type.Equals(NHibernateUtil.Entity(typeof(Foo))));
			Assert.IsTrue(tdq.PosParams[10].Type.Equals(NHibernateUtil.Enum(typeof(FlushMode))));
			Assert.IsTrue(tdq.PosParams[11].Type.Equals(NHibernateUtil.Int16));
			Assert.IsTrue(tdq.PosParams[12].Type.Equals(NHibernateUtil.Int32));
			Assert.IsTrue(tdq.PosParams[13].Type.Equals(NHibernateUtil.Int64));
			Assert.IsTrue(tdq.PosParams[14].Type.Equals(NHibernateUtil.Single));
			Assert.IsTrue(tdq.PosParams[15].Type.Equals(NHibernateUtil.String));
			Assert.IsTrue(tdq.PosParams[16].Type.Equals(NHibernateUtil.Time));
			Assert.IsTrue(tdq.PosParams[17].Type.Equals(NHibernateUtil.Timestamp));
			Assert.IsTrue(tdq.PosParams[18].Type.Equals(NHibernateUtil.Guid));

			tdq.SetAnsiString("1", "");
			tdq.SetBinary("2", new byte[] { });
			tdq.SetBoolean("3", false);
			tdq.SetByte("4", 255);
			tdq.SetCharacter("5", 'A');
			tdq.SetDateTime("6", DateTime.MaxValue);
			tdq.SetDecimal("7", 10.15m);
			tdq.SetDouble("8", 8.1f);
			tdq.SetEntity("9", new Foo("Fulano", "De Tal"));
			tdq.SetEnum("10", FlushMode.Auto);
			tdq.SetInt16("11", 1);
			tdq.SetInt32("12", 1);
			tdq.SetInt64("13", 1);
			tdq.SetSingle("14", 1.1f);
			tdq.SetString("15", "");
			tdq.SetTime("16", DateTime.Now);
			tdq.SetTimestamp("17", DateTime.Now);
			tdq.SetGuid("18", Guid.Empty);
			Assert.IsTrue(tdq.NamedParams["1"].Type.Equals(NHibernateUtil.AnsiString));
			Assert.IsTrue(tdq.NamedParams["2"].Type.Equals(NHibernateUtil.Binary));
			Assert.IsTrue(tdq.NamedParams["3"].Type.Equals(NHibernateUtil.Boolean));
			Assert.IsTrue(tdq.NamedParams["4"].Type.Equals(NHibernateUtil.Byte));
			Assert.IsTrue(tdq.NamedParams["5"].Type.Equals(NHibernateUtil.Character));
			Assert.IsTrue(tdq.NamedParams["6"].Type.Equals(NHibernateUtil.DateTime));
			Assert.IsTrue(tdq.NamedParams["7"].Type.Equals(NHibernateUtil.Decimal));
			Assert.IsTrue(tdq.NamedParams["8"].Type.Equals(NHibernateUtil.Double));
			Assert.IsTrue(tdq.NamedParams["9"].Type.Equals(NHibernateUtil.Entity(typeof(Foo))));
			Assert.IsTrue(tdq.NamedParams["10"].Type.Equals(NHibernateUtil.Enum(typeof(FlushMode))));
			Assert.IsTrue(tdq.NamedParams["11"].Type.Equals(NHibernateUtil.Int16));
			Assert.IsTrue(tdq.NamedParams["12"].Type.Equals(NHibernateUtil.Int32));
			Assert.IsTrue(tdq.NamedParams["13"].Type.Equals(NHibernateUtil.Int64));
			Assert.IsTrue(tdq.NamedParams["14"].Type.Equals(NHibernateUtil.Single));
			Assert.IsTrue(tdq.NamedParams["15"].Type.Equals(NHibernateUtil.String));
			Assert.IsTrue(tdq.NamedParams["16"].Type.Equals(NHibernateUtil.Time));
			Assert.IsTrue(tdq.NamedParams["17"].Type.Equals(NHibernateUtil.Timestamp));
			Assert.IsTrue(tdq.NamedParams["18"].Type.Equals(NHibernateUtil.Guid));

			tdq.SetParameter(10, 123456m);
			Assert.AreEqual(1, tdq.PosUntypeParams.Count);
			Assert.IsTrue(tdq.PosUntypeParams.ContainsKey(10));

			tdq.SetParameter("Any", 123456m);
			Assert.AreEqual(1, tdq.NamedUntypeParams.Count);
			Assert.IsTrue(tdq.NamedUntypeParams.ContainsKey("Any"));

			tdq.SetParameterList("UntypedList", new int[] { 1, 2, 3 });
			Assert.IsTrue(tdq.NamedUntypeListParams.ContainsKey("UntypedList"));

			tdq.SetParameterList("TypedList", new Int64[] { 1, 2, 3 }, NHibernateUtil.Int64);
			Assert.IsTrue(tdq.NamedListParams.ContainsKey("TypedList"));
			Assert.IsNotNull((tdq.NamedListParams["TypedList"].Value as IEnumerable));
		}