How to get rid of the red lines?

Question

Dear All,

The following code is copied from a webpage. How to get rid of the red lines?

Answer 1

Here is what will work

Project file

<Project Sdk="Microsoft.NET.Sdk">
<PropertyGroup>
	<OutputType>Exe</OutputType>
	<TargetFramework>net6.0</TargetFramework>
	<ImplicitUsings>enable</ImplicitUsings>
	<Nullable>enable</Nullable>
</PropertyGroup>
<ItemGroup>
	<PackageReference Include="Microsoft.Data.SqlClient" Version="5.1.0" />
</ItemGroup>

Code

using System.Data;
using Microsoft.Data.SqlClient;

namespace AutomationApp;

internal class Program
{

    static void Main(string[] args)
    {
        RunStoredProc();
    }

    private static void RunStoredProc()
    {
        using var conn = new SqlConnection() { ConnectionString = "TODO" };
        using var cmd = new SqlCommand("SelectAllTrainers",conn)
        {
            CommandType = CommandType.StoredProcedure
        };
        conn.Open();
        cmd.ExecuteNonQuery();
    }
}

Answer 2

Are you using .NET Core 7? If not the first line for the connection needs to be a using statement not a using declaration.