Home > DeveloperSection > Forums > What is the Dot Net Framework data provider for SQL Server?
yash Singh
yash Singh

Total Post:15

Points:105
Posted on    November-10-2010 1:12 AM

 ADO.Net ADO.Net 
Ratings:


 2 Reply(s)
 2070  View(s)
Rate this:
what namespace should i use for sql server


Pushpendra Singh

Total Post:9

Points:63
Posted on    November-10-2010 1:50 AM

The  .net framework data provider for SQL Server is the optimized data provider for Microsoft SQL Server 7 or later. It is recommended to use SQL Server data provider to access the SQL Server databse.

Use fallowing namespace for sql server

System.Data.SqlClient

Shankar M

Total Post:25

Points:175
Posted on    April-14-2013 9:14 PM

Hi Yash,

The namespace to be used for SQL Server Data Provider is using System.Data.SqlClient;

using System.Data;            // Use ADO.NET namespace
using System.Data.SqlClient;  // Use SQL Server data provider

Thanks,
Shankar

Don't want to miss updates? Please click the below button!

Follow MindStick