I have created a class in VB.NET 2005 that will return data for a given Employee ID, which involves calling a few web services to return the needed data. I have successfully used this class in a few of my windows form projects.
What I would like to do now is find a way to integrate this class into SQL Server 2005. For example, I will have a table with a column that contains a list of IDs. I would like to be able to use my class to return data for those IDs. My requirements include checking the table with IDs on a daily basis.
Some of my research indicates that I will need to learn CLR. Is this correct? Can anyone recommend a book or website that will help me learn what I need to do?
Any help would be appreciated, thanks.
What I would like to do now is find a way to integrate this class into SQL Server 2005. For example, I will have a table with a column that contains a list of IDs. I would like to be able to use my class to return data for those IDs. My requirements include checking the table with IDs on a daily basis.
Some of my research indicates that I will need to learn CLR. Is this correct? Can anyone recommend a book or website that will help me learn what I need to do?
Any help would be appreciated, thanks.