I have an EmployeeID column in my Sql-Table, which is also synchronized with a SharePoint list created in SharePoint Designer from “External Content Type”. Active Directory accounts at our company also have an EmployeeID field. As the page loads, how can I read the users Login name, query the Active Directory for the EmployeeID and filter the list using the retrieved EmployeID in SharePoint foundation.
P.S. I was able to do this with a Silverlight Webpart and a WCF Servie but I need to do this in native SharePoint.