Does C# support ADO.Net to access Data ?

Question

Trying to create a Data dll usnin C# in VS2019. Does C# support ADO.Net ?

Answer 1

Hello Edward,

C# is the language. you can create console, desktop, web application etc with the help of c# language.

to use ADO.NET you need to use below system namespaces.

using System.Data;
using System.Configuration;
using System.Data.SqlClient;

private void GetData()
{
    string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
    string query = "SELECT * FROM Customers";
    using (SqlConnection con = new SqlConnection(constr))
    {
        using (SqlDataAdapter sda = new SqlDataAdapter(query, con))
        {
            using (DataTable dt = new DataTable())
            {
                sda.Fill(dt);
                // use DataAdapter to bind data to grid or you can utilize as per requirement.
            }
        }
    }
}

 

Thanks

Answer 2

Hello Edward,

Yes. it will work for VS2019. 

Answer 3

Does this work for VS2019? also thank you for the quick response.