IEnumerator <SqlDataRecord> IEnumerable <SqlDataRecord> .GetEnumerator() { SqlDataRecord sdr = new SqlDataRecord( new SqlMetaData("KeyField", SqlDbType.SmallInt), new SqlMetaData("description", SqlDbType.VarChar, 30), new SqlMetaData("MaxStudents", SqlDbType.Int), new SqlMetaData("DeletedYN", SqlDbType.Bit), new SqlMetaData("UpdateYN", SqlDbType.Bit), new SqlMetaData("OKToDelete", SqlDbType.Bit)); foreach (Room i in this) { sdr.SetSqlInt16(0, i.KeyField); sdr.SetString(1, i.description); sdr.SetSqlNullableInt32(2, i.MaxStudents); sdr.SetBoolean(3, i.DeleteYN); sdr.SetBoolean(4, i.UpdateYN); sdr.SetBoolean(5, i.OKToDelete); yield return(sdr); } }