Simple import of an MS-SQL table into System.Data.DataTable, is this possible?

Question

When checking the official documentation about System.Data.DataSet and System.Data.DataTable, I have the impression that "importing an MS-SQL table into C# classes" happens as follows:

• Open the connection
• Write an SQL query in an SqlCommand, containing the name of the table, the names of the columns: SELECT ProductID, SupplierID FROM dbo.Products (or SELECT *), but still the corresponding SqlDataReader must be run through for getting the values inside the table).

Isn't there some way to say:

DataTable dt_Products = new DataTable(connection, "Products")

... and this DataTable automatically has the right column names, column types, values, autoincrement properties if possible, ... (without needing to pass by SqlCommand, SqlDataReader, ...)?

Answer 1

Maybe what you need is this.

using (var da = new System.Data.SqlClient.SqlDataAdapter("SELECT ProductID, SupplierID FROM dbo.Products", connection)) 
{
 da.Fill(dt_Products);
}