Recommendation is to execute this logic at SQL level. You can write a stored procedure as:
Create Procedure FetchEmpInfo
@EmpNo Int
AS
SELECT * FROM Employee mast, reftable1 r1, reftable2 r2,....reftable15 r3
WHERE
mast.Id IN(@Ids) AND
mast.Id = r1.Id AND
mast.Id = r2.Id AND
.....
mast.Id = r15.Id AND