In this chapter, we've seen a new way to generate and consume services through the WCF SQL Server Adapter. This new adapter offers us significantly more control over access to our back end database while providing a cleaner metadata browsing and development experience. The reusability of this adapter is compelling and means that a developer well-versed in BizTalk development can seamlessly transfer that data connectivity knowledge to a standard WCF application. Because you can now define SQL Server-based services outside of BizTalk Server, consider whether or not it makes sense to define a particular operation as a standalone service that BizTalk (and others) can consume, or whether you should use the WCF-SQL binding directly within a BizTalk send port. Each situation is different, but it's great to now have such choices.
In the next chapter, we take a look at the new UDDI Server that comes with BizTalk Server 2009.