Limitation of ExecuteScalar/ExecuteReader

i came across a strange situation, when i am fixing a issue. I developed a windows service application in which xml data is loaded into database directly.