I am trying to use SQLClient library in the ASP.net Core but cant seem to get it working.  I found this article online advising how to setup but its not working for me: http://blog.developers.ba/using-classic-ado-net-in-asp-net-vnext/

I have a simple console application package.  My project.json looks like this:

    {
      &quot;version&quot;: &quot;1.0.0-*&quot;,
      &quot;description&quot;: &quot;DBTest Console Application&quot;,
      &quot;authors&quot;: [ &quot;&quot; ],
      &quot;tags&quot;: [ &quot;&quot; ],
      &quot;projectUrl&quot;: &quot;&quot;,
      &quot;licenseUrl&quot;: &quot;&quot;,
    
      &quot;compilationOptions&quot;: {
        &quot;emitEntryPoint&quot;: true
      },
    
      &quot;dependencies&quot;: {
        &quot;System.Data.Common&quot;: &quot;4.0.1-beta-23516&quot;,
        &quot;System.Data.SqlClient&quot; :  &quot;4.0.0-beta-23516&quot;
      },
    
      &quot;commands&quot;: {
        &quot;DBTest&quot;: &quot;DBTest&quot;
      },
    
      &quot;frameworks&quot;: {
        &quot;dnx451&quot;: { },
        &quot;dnxcore50&quot;: {
          &quot;dependencies&quot;: {
            &quot;Microsoft.CSharp&quot;: &quot;4.0.1-beta-23516&quot;,
            &quot;System.Collections&quot;: &quot;4.0.11-beta-23516&quot;,
            &quot;System.Console&quot;: &quot;4.0.0-beta-23516&quot;,
            &quot;System.Linq&quot;: &quot;4.0.1-beta-23516&quot;,
            &quot;System.Threading&quot;: &quot;4.0.11-beta-23516&quot;
          }
        }
      }
    }


And I try the following code:

    using System;
    using System.Data.SqlClient;
    
    namespace DBTest
    {
        public class Program
        {
            public static void Main(string[] args)
            {
                using (SqlConnection con = new SqlConnection(ConnStr)) {
                    con.Open();
                    try {
                        using (SqlCommand command = new SqlCommand(&quot;SELECT * FROM SAMPLETABLE&quot;, con)) {
                            command.ExecuteNonQuery();
                        }
                    }
                    catch {
                        Console.WriteLine(&quot;Something went wrong&quot;);
                    }
                }
    
                Console.Read();
            }
        }
    }


But get the following errors:

[![enter image description here][1]][1]

Anyone else got this working?


  [1]: http://i.stack.imgur.com/3psE9.png

All Sqlclient Solutions on Gang of Coders

Total of 1 Sqlclient Solutions

How to use SqlClient in ASP.NET Core?