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; } }