MS-SCCSTR Protocol intro - .NET Framework

[Pages:34]MS-SCCSTR Protocol intro

Bin Guo

SQL OIPI Test Development Team

Agenda

1 Introduction of MS-SCCSTR 2 Relationship to Protocols 3 Connection String Syntax 4 Keyword Classification & Example 5 Resource

? Introduction of MS-SCCSTR

Introduction

[MS-SCCSTR]: SqlClient Connection String Structure The SqlClient Connection String structure specifies the format

of the connection strings that are used by Microsoft .NET Framework applications that connect to Microsoft SQL Server by using the Microsoft .NET Framework Data Provider for SQL Server ("SqlClient").

Introduction

Data Source=localhost; Initial Catalog=AdventureWorks2014; Integrated Security=SSPI; Persist Security Info=false

A connection string is a series of arguments, delimited by a semicolon, that describe the location of a database and how to connect to it.

What is SqlClient and where is it?

Database and Web Service Applications

SqlClient

Microsoft .NET Framework Data Provider for SQL Server

OLE DB

Data Provider for OLE DB

Data Provider for ODBC

Data Provider 1

Database / Other Data

Sources

Data Provider 2

ODBC

ODBC Driver 1 ODBC Driver 2

Client Access Library

SqlClient accesses a SQL Server directly

SqlClient

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download