Biztalk Wcf Sql Adapter: How To Receive Records From A Database With One-to-many Relationships

I have seen many tutorials going over how to use the WCF SQL adapter in a BizTalk receive port to pull in data from a SQL Server database. However, I have been unable to find any r

Solution 1:

Your stored procedure should look something like this.

SELECT [TeamName] 
FROM [Team]
WHERE [TeamID] =@NewTeamIDSELECT [PlayerName]
FROM [Player]
WHERE [TeamID] =@NewTeamIDSELECT [SponsorName] 
FROM [Sponsor]
WHERE [TeamID] =@NewTeamID

Then generate the schema from that via Consume Adapter Service. You will get a schema with three record sets which you can then map to a nicer schema.