December 2013
Intermediate to advanced
1872 pages
153h 31m
English
book
Microsoft® SQL Server 2012 Unleashed
by Ray Rankins, Paul T. Bertucci, Chris Gallelli, Alex T. Silverstein
Content preview from Microsoft® SQL Server 2012 Unleashed
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
Client Data Access Technologies
The question of which data access technology to use with SQL Server 2012 is a common one, with a seemingly easy answer: You use SNAC because it has all the latest and greatest functionality, all rolled into one. (You learn how to use SNAC in the sections that follow.) A more correct answer is that your choice depends on which software technologies your clients currently use and what their specific needs are.
Your data access options consist of providers and drivers, whose functionality is often encapsulated inside code libraries known as net-libraries (such as SNAC’s sqlncli11.dll). In addition to these net-libraries, supporting services such as MDAC’s OLE DB Core Services are also available, providing useful ...