title: SqlDataAdapter missing in a ASP.NET Core project
body: <p>I'm trying to get a connection to a database without Entity Framework, using ADO.NET in a .NET Core 1.0 project.</p>
  
  <pre><code>using System;
  using System.Collections.Generic;
  using System.Linq;
  using System.Threading.Tasks;
  using ASP_NETCore3.Models;
  using System.Data;
  using System.Data.SqlClient;
  //using System.Configuration;
  
  namespace ASP_NETCore3.Repository
  {
      public class LineasRepository
      {
          private SqlConnection con;
  
          private void connection()
          {
              //TODO: Implementar variables de confuracion obtiendolas desde appsettings.json
              string constr = "Data Source=mylocaldb\\sql08;Initial Catalog=empresas;User id=user;Password=secret;Integrated Security=SSPI;";
              con = new SqlConnection(constr);
          }
  
          public List&lt;LineasModel&gt; GetAllLineas()
          {
              connection();
              List&lt;LineasModel&gt; LineasList = new List&lt;LineasModel&gt;();
              SqlCommand com = new SqlCommand("select * from CATLIN", con);
              com.CommandType = CommandType.Text;
              SqlDataAdapter da = new SqlDataAdapter(com);
              DataTable dt = new DataTable();
              con.Open();
              da.Fill(dt);
              con.Close();
  
              LineasList = (from DataRow dr in dt.Rows
  
                         select new LineasModel()
                         {
                             cod_lin = Convert.ToInt32(dr["COD_LIN"]),
                             nom_lin = Convert.ToString(dr["NOM_LIM"]),
                             margen = Convert.ToString(dr["MARGEN"]),
                         }).ToList();
  
  
              return EmpList;
          }
      }
  }
  </code></pre>
  
  <p>As you can see, I can use System.Data.SqlClient, but for some reason compiler says that SqlDataAdapter is missing.</p>
  
  <p>What can I do? It can be fixed installing another packages from NuGet?</p>