Mercurial > pub > bltoolkit
diff UnitTests/CS/Data/ExecuteListT.cs @ 0:f990fcb411a9
Копия текущей версии из github
author | cin |
---|---|
date | Thu, 27 Mar 2014 21:46:09 +0400 |
parents | |
children |
line wrap: on
line diff
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/UnitTests/CS/Data/ExecuteListT.cs Thu Mar 27 21:46:09 2014 +0400 @@ -0,0 +1,85 @@ +using System.Collections.Generic; +using BLToolkit.Reflection; +using NUnit.Framework; + +using BLToolkit.Data; + +namespace Data +{ + [TestFixture] + public class ExecuteListT + { + public class SimpleObject + { + public SimpleObject() + { + } + + public SimpleObject(InitContext context) + { + if (context.Parameters != null) + { + Assert.AreEqual(2, context.Parameters.Length); + Assert.AreEqual("123", context.Parameters[0]); + Assert.AreEqual("456", context.Parameters[1]); + } + } + + private int _key; public int Key { get { return _key; } set { _key = value; } } + private string _value; public string Value { get { return _value; } set { _value = value; } } + } + + [Test] + public void Test() + { + using (DbManager db = new DbManager()) + { + List<SimpleObject> list = new List<SimpleObject>(); + + db +#if MSSQL || SQLCE + .SetCommand(@" + SELECT 0 as [Key], 'value0' as Value UNION + SELECT 1 as [Key], 'value1' as Value UNION + SELECT 2 as [Key], 'value2' as Value") + +#else // ORACLE || FIREBIRD || ACCESS + + .SetCommand(@" + SELECT 0 as ""Key"", 'value0' as ""Value"" FROM Dual UNION + SELECT 1 as ""Key"", 'value1' as ""Value"" FROM Dual UNION + SELECT 2 as ""Key"", 'value2' as ""Value"" FROM Dual") +#endif + .ExecuteList<SimpleObject>(list); + + Assert.IsTrue(list.Count > 0); + } + } + + [Test] + public void ParamsTest() + { + using (DbManager db = new DbManager()) + { + List<SimpleObject> list = db +#if MSSQL || SQLCE + .SetCommand(@" + SELECT 0 as [Key], 'value0' as Value UNION + SELECT 1 as [Key], 'value1' as Value UNION + SELECT 2 as [Key], 'value2' as Value") + +#else // ORACLE || FIREBIRD || ACCESS + + .SetCommand(@" + SELECT 0 as ""Key"", 'value0' as ""Value"" FROM Dual UNION + SELECT 1 as ""Key"", 'value1' as ""Value"" FROM Dual UNION + SELECT 2 as ""Key"", 'value2' as ""Value"" FROM Dual") +#endif + .ExecuteList<SimpleObject>("123", "456"); + + Assert.IsNotEmpty(list); + Assert.IsInstanceOf(typeof(SimpleObject), list[0]); + } + } + } +}