WHAT IS THE DOT NET FRAMEWORK DATA PROVIDER FOR SQL SERVER?

yash Singh

Total Post:15

Points:105
Posted by  yash Singh
 2495  View(s)
Ratings:
Rate this:
what namespace should i use for sql server
  1. Pushpendra Singh

    Post:9

    Points:63
    Re: What is the Dot Net Framework data provider for SQL Server?

    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

  1. Shankar M

    Post:25

    Points:175
    Re: What is the Dot Net Framework data provider for SQL Server?

    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

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!