I call SQL stored procedures slightly differently in .NET Core to the way I did in .NET framework as I now pass the connection string through as an argument and I need to remember to add the System.Data.SqlClient NuGet package.

public static List<string> GetBlogSummaries(string connectionString)
{
	List<string> headers = new List<string>();
	
	using (SqlConnection connection = new SqlConnection(connectionString))
	{
		using (SqlCommand command = new SqlCommand("sp__get_required_headers"))
		{
			command.CommandType = System.Data.CommandType.StoredProcedure;
			command.Connection = connection;
			
			connection.Open();
			
			SqlDataReader reader = command.ExecuteReader();
			
			if (reader.HasRows)
			{
				while (reader.Read())
				{
					headers.Add(reader[0].ToString());
				}
			}
			
			reader.Close();
			
			connection.Close();
		}
	}
	
	return headers;
}

0 Comments

Leave a Reply

Avatar placeholder

Your email address will not be published.