You could delete a row in SQL 2008 using the DELETE statement, which removes one or more rows in a table or view.

C# 8.0 and .NET Core 3.0 – Modern Cross-Platform Development: Build applications with C#, .NET Core, Entity Framework Core, ASP.NET Core, and ML.NET using Visual Studio Code, 4th Edition
ASP.NET Core 3 and Angular 9: Full stack web development with .NET Core 3.1 and Angular 9, 3rd Edition
C# in Depth, 4th Edition

The following example deletes all rows from the CarPriceHistory table in which the value in the RegularPrice column is more than 20000.00.

USE AllCars;
DELETE FROM Cars.CarPriceHistory
WHERE RegularPrice > 20000.00;

Your hosting company should support SQL 2008 hosting to host ASP.NET with MS SQL 2008.