public void GetProviderSpecificTests()
{
DataTableReader rdr = dt.CreateDataReader ();
while (rdr.Read ()) {
object[] values = new object [rdr.FieldCount];
object[] pvalues = new object [rdr.FieldCount];
rdr.GetValues (values);
rdr.GetProviderSpecificValues (pvalues);
for (int i = 0; i < rdr.FieldCount; ++i) {
Assert.AreEqual(values [i], pvalues [i], "#1");
Assert.AreEqual(rdr.GetValue (i), rdr.GetProviderSpecificValue (i), "#2");
Assert.AreEqual(rdr.GetFieldType (i), rdr.GetProviderSpecificFieldType (i), "#3");
}
}
}
public bool Example()
{
using (DataTableReader reader = Table.CreateDataReader()) {
while (reader.Read())
{
// Access via the fields name or ordinal position
var aValue = (int)reader [0];
var bValue = (int)reader ["idAnotherTable"];
if (aValue < 0 || bValue < 0 || aValue.GetType() != typeof(int) || bValue.GetType() != typeof(int))
{
throw new Exception("An Issue");
}
// Access should be preferred through strongly typed values
var isNull = reader.IsDBNull(0);
if (isNull)
{
throw new Exception("An Issue");
}
var aString = reader.GetString(1);
if (aString.Length == 0 || aString.GetType() != typeof(string))
{
throw new Exception("An Issue");
}
var anInt = reader.GetInt32(2);
if (anInt == 0 || anInt.GetType() != typeof(int))
{
throw new Exception("An Issue");
}
var aDecimal = reader.GetDecimal(3);
if (aDecimal == 0 || aDecimal.GetType() != typeof(decimal))
{
throw new Exception("An Issue");
}
// Access the .NET field type or the data providers type
Type aType = reader.GetFieldType(0);
Type bType = reader.GetProviderSpecificFieldType(0);
if (aType != typeof(int) || bType != typeof(int))
{
throw new Exception("An Issue");
}
// Access field name and ordinal position
var fieldName = reader.GetName(1);
int position = reader.GetOrdinal("StringField");
if (fieldName != "StringField" || position != 1)
{
throw new Exception("An Issue");
}
}
return(true);
}
}