Summary
This chapter has delivered a fairly critical analysis across the gamut of .NET data access APIs and tools that Microsoft has released over more than the past decade, with guidance to help you intelligently distinguish between them. We walked through numerous examples and demonstrated coding techniques for working with each of them, and also provided important guidelines to keep in mind as you do.
We started by explaining the continued relevance of conventional ADO.NET—both raw data access obects and DataSets—alongside newer technologies. You started with raw connections, commands, readers, adapters, and DataSets to run direct SQL statements and execute stored procedures in SQL Server. You also learned about explicit and implicit transactions ...
Get Programming Microsoft® SQL Server® 2012 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
