private static Contact MapContact(DbDataReader rdr)
{
return new Contact()
{
Id = rdr.Get<int>("ContactId"),
Surname = rdr.Get<string>("Surname"),
Forenames = rdr.Get<string>("Forenames")
};
}
static void ReadDataMulti(DbDataReader reader)
{
var ctr = 1;
while (reader.HasRows)
{
while (reader.Read())
{
Console.WriteLine(ctr == 1
? string.Format("\nExpected - {0} , Got - {1}", "sfk shan", reader.Get<string>("Name")) //First result set - Employee
: string.Format("\nExpected - {0} , Got - {1}", "HR", reader.Get<string>("name")));//Second Result set - Department
break;
}
ctr++;
reader.NextResult();
}
//Note : for test purpose it is skipped to iterate the rest rows
}
static void ReadData(DbDataReader reader)
{
while (reader.Read())
{
Console.WriteLine("\nExpected - {0} , Got - {1}", "HR", reader.Get<string>("name"));
break;
}
}
