public void ScalarDestinationTest()
{
TestAccessor ta = TestAccessor.CreateInstance();
int id1;
int id2;
id1 = ta.ScalarDestination1(out id2);
Assert.AreEqual(id1, 12345);
Assert.AreEqual(id2, 12345);
ta.ScalarDestination2(out id2);
Assert.AreEqual(id2, 12345);
id1 = (int)ta.ScalarDestination3(out id2);
Assert.AreEqual(id1, 12345);
Assert.AreEqual(id2, 12345);
id2 = 0;
id1 = ta.ScalarDestination4(ref id2);
Assert.AreEqual(id1, 12345);
Assert.AreEqual(id2, 12345);
id2 = 0;
ta.ScalarDestination5(ref id2);
Assert.AreEqual(id2, 12345);
id2 = 0;
id1 = (int)ta.ScalarDestination6(ref id2);
Assert.AreEqual(id1, 12345);
Assert.AreEqual(id2, 12345);
}
public void OutputParameter2Test()
{
TestAccessor ta = TestAccessor.CreateInstance();
string expectedValue = "54321";
string actualValue = ta.Scalar_OutputParameter2();
Assert.AreEqual(expectedValue, actualValue);
}
public void DataReader3Test()
{
TestAccessor ta = TestAccessor.CreateInstance();
string expectedValue = "54321";
string actualValue = ta.Scalar_DataReader3();
Assert.AreEqual(expectedValue, actualValue);
}
public void OutputParameterTest()
{
TestAccessor ta = TestAccessor.CreateInstance();
int expectedValue = 12345;
int actualValue = ta.Scalar_OutputParameter();
Assert.AreEqual(expectedValue, actualValue);
}
public void DataReaderTest()
{
TestAccessor ta = TestAccessor.CreateInstance();
int expectedValue = 12345;
int actualValue = ta.Scalar_DataReader();
Assert.AreEqual(expectedValue, actualValue);
}
public void AffectedRowsTest()
{
TestAccessor ta = TestAccessor.CreateInstance();
int expectedValue = -1;
int actualValue = ta.Scalar_AffectedRows();
Assert.AreEqual(expectedValue, actualValue);
}
public void ScalarNullableDestinationTest()
{
TestAccessor ta = TestAccessor.CreateInstance();
int?id1;
int?id2 = -1;
id1 = ta.ScalarNullableDestination(ref id2);
Assert.AreEqual(id1, id2);
}
public void ScalarNullableEnumDestinationTest()
{
TestAccessor ta = TestAccessor.CreateInstance();
TestEnum?refVal = null;
TestEnum?outVal = ta.ScalarNullableEnumDestination(ref refVal);
Assert.That(outVal, Is.EqualTo(TestEnum.Value));
Assert.That(refVal, Is.EqualTo(TestEnum.Value));
}
public void GenericsSelectIDsTest()
{
using (DbManager db = new DbManager())
{
TestAccessor ta = TestAccessor.CreateInstance();
List <int> list = ta.GenericsSelectIDs(db);
Assert.IsNotNull(list);
Assert.IsNotEmpty(list);
}
}
public void XmlDocTest()
{
using (DbManager db = new DbManager())
{
TestAccessor ta = TestAccessor.CreateInstance();
XmlDocument xmlDocument = ta.GetXmlDoc(db, 2);
Assert.IsNotNull(xmlDocument);
Assert.IsNotNull(xmlDocument.DocumentElement);
Assert.AreEqual("strvalue", xmlDocument.DocumentElement.GetAttribute("strattr"));
}
}
public void ReturnParameterTest()
{
using (DbManager db = new DbManager())
{
TestAccessor ta = TestAccessor.CreateInstance();
int expectedValue = 12345;
int actualValue = ta.Scalar_ReturnParameter(db);
Assert.AreEqual(expectedValue, actualValue);
}
}
public void OutputParameter3Test()
{
using (DbManager db = new DbManager())
{
TestAccessor ta = TestAccessor.CreateInstance();
string expectedValue = "54321";
string actualValue = ta.Scalar_OutputParameter3(db);
Assert.AreEqual(expectedValue, actualValue);
}
}
public void SelectLastNamesTest()
{
using (DbManager db = new DbManager())
{
TestAccessor ta = TestAccessor.CreateInstance();
ArrayList list = ta.SelectLastNames(db);
Assert.IsNotNull(list);
Assert.IsNotEmpty(list);
Assert.IsTrue(list[0] is string);
}
}
public void DataReader2Test()
{
using (DbManager db = new DbManager())
{
TestAccessor ta = TestAccessor.CreateInstance();
string expectedValue = "54321";
string actualValue = ta.Scalar_DataReader2(db);
Assert.AreEqual(expectedValue, actualValue);
}
}
public void XmlTest()
{
using (DbManager db = new DbManager())
{
TestAccessor ta = TestAccessor.CreateInstance();
XmlReader xml = ta.GetXml(db, 2);
xml.MoveToContent();
Assert.IsTrue(xml.ReadToDescendant("element"));
Assert.AreEqual("strvalue", xml.GetAttribute("strattr"));
}
}
public void AccessorTest()
{
using (DbManager db = new DbManager())
{
string paramName = (string)db.DataProvider.Convert("name", ConvertType.NameToQueryParameter);
string fieldName = (string)db.DataProvider.Convert("FirstName", ConvertType.NameToQueryField);
TestAccessor ta = (TestAccessor)TestAccessor.CreateInstance(typeof(TestAccessor), db);
string actual;
ta.SelectJohn(out actual, paramName, fieldName);
Assert.AreEqual("John", actual);
}
}
public void AffectedRowsTest()
{
using (DbManager db = new DbManager())
{
TestAccessor ta = TestAccessor.CreateInstance();
#if ACCESS
int expectedValue = 0;
#else
int expectedValue = -1;
#endif
int actualValue = ta.Scalar_AffectedRows(db);
Assert.AreEqual(expectedValue, actualValue);
}
}
public void StreamTest()
{
using (DbManager db = new DbManager())
{
TestAccessor ta = TestAccessor.CreateInstance();
Stream s = ta.GetStream(db, 2);
Byte[] bytes = new byte[16];
Assert.IsNotNull(s);
Assert.AreEqual(s.Length, bytes.Length);
Assert.AreEqual(s.Read(bytes, 0, bytes.Length), bytes.Length);
TypeAccessor.WriteConsole(bytes);
}
}
public void OutputParameterRegressionTest()
{
using (DbManager db = new DbManager())
{
TestAccessor ta = TestAccessor.CreateInstance();
int expectedIntValue = 12345;
int actualIntValue;
string expectedStringValue = "54321";
string actualStringValue;
ta.Scalar_OutputParameterRegression(db,
out actualIntValue, out actualStringValue);
Assert.AreEqual(expectedIntValue, actualIntValue);
Assert.AreEqual(expectedStringValue, actualStringValue);
}
}