Connect to SQL Server using .NET Framework 4.7.2 Web API 2.0 and without using Entity Framework

Question

I have created a Web API built on .NET Framework 4.7.2. I want to be able to communicate with SQL Server without using Entity Framework.

Microsoft.Data.SqlClient and System.Data.SqlClient are not compatible with .NET Framework 4.7.2. I really do not want to use any ORM.

Any suggestions?

SqlConnection and related classes are built into .NET Framework, you don't need to add anything. — Lasse V. Karlsen
– Lasse V. Karlsen, Commented Nov 6, 2020 at 20:29
System.Data.SqlClient does not work with .NET Framework4.7.2. Here is the information on that. github.com/dotnet/efcore/issues/14880 - System.Data.SqlClient 'not supported on this platform' on Framework 4.7.2 — Troy Crowe
– Troy Crowe, Commented Nov 6, 2020 at 21:37

Dale K · Accepted Answer · 2020-11-06 20:50:26Z

1

You can use dapper for example:

var data = new List<DapperTest>();
        using (IDbConnection db = new SqlConnection(ConfigurationManager.ConnectionStrings["Analysis"].ConnectionString))
        {
             data = db.Query<DapperTest>("select * from testTable").ToList();
        }
        return data;

edited Nov 6, 2020 at 20:50

Dale K

28.1k15 gold badges59 silver badges85 bronze badges

answered Nov 6, 2020 at 20:41

Saeideh miri

795 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Troy Crowe Over a year ago

So I stated that I did not want to use an ORM. Also, I see that your code is utilizing SqlConnection which is exactly the problem I am running into. As stated above System.Data.SqlClient, which provides SqlConnection object, is not available in .net framework 4.7.2.

Troy Crowe Over a year ago

github.com/dotnet/efcore/issues/14880 - System.Data.SqlClient 'not supported on this platform' on Framework 4.7.2

Troy Crowe Over a year ago

Okay, I just checked Microsoft documentation and It clearly shows it still included. I don't understand why my application cannot see the SqlConnection object. I have System.Data.SqlClient in my using statements and everything.

Troy Crowe · Accepted Answer · 2020-11-06 21:51:12Z

0

I figured it out. I build a .net Standard library instead of a .net Framework library.

answered Nov 6, 2020 at 21:51

Troy Crowe

1233 silver badges12 bronze badges

Collectives™ on Stack Overflow

Connect to SQL Server using .NET Framework 4.7.2 Web API 2.0 and without using Entity Framework

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related