How to use SqlException in .NET CORE?

Question

asp.net-core ef-core-2.1 entity-framework-core exception exception-handling

In my old project with .Net Framework use from

 using System.Data.SqlClient;

and

if (ex.GetType() == typeof(SqlException))
{
    return ErrorMessage((SqlException)ex);
}

and now in .NET CORE Does not know Code above

How to use typeof(SqlException) in .NET CORE?

View more on Stack Overflow

TÃ¢n · Accepted Answer · 11/24/2018 9:48:28 AM

In .Net Core version, you need to install this package before using it: Microsoft.EntityFrameworkCore.SqlServer

Install-Package Microsoft.EntityFrameworkCore.SqlServer -Version 2.1.4

try
{
    // code goes here...    
}
catch (SqlException sqlEx)
{
    // code goes here...
}
catch (Exception ex)
{
    // other exception...
}