SqlDataReader GetOrdinal with same name

Question

is need to use GetOrdinal from the SqlDataReader but my query is with joins and contains the same field name multiple times. So I try

SELECT a.Id, b.Id FROM table1 AS a ...

but GetOrdinal seems dont understand the schema alias...GetOrdinal('a.Id')` throws an Exception... is there anyway to archive this?

Answer 1

Give an alias name in your query

SELECT a.Id As EmployeeID, b.Id as ManagerId FROM table1 AS a ..

Now you can use the Alias names in your code to read the value

var employeeIdIndex = reader.GetOrdinal("EmployeeID")