Starting here https://marketplace.visualstudio.com/items?itemName=aspnet.blazor

Download dotnet core 3 

https://dotnet.microsoft.com/download/thank-you/dotnet-sdk-3.0.100-preview3-windows-x64-installer

 dotnet core samples page https://github.com/dodyg/practical-aspnetcore

        private async Task CallServiceAsync()

        {

            string schedulerServiceName = "fabric:/DataServices/Scheduler";

            var resolver = ServicePartitionResolver.GetDefault();

            var partition = await resolver.ResolveAsync(new Uri(schedulerServiceName), ServicePartitionKey.Singleton, CancellationToken.None);

            var endpoints = JObject.Parse(partition.GetEndpoint().Address)["Endpoints"];

            var endpoint = endpoints[""].ToString().TrimEnd('/');

            string method = "/api/scheduler/classes/sync";

            var client = new HttpClient();

            client.DefaultRequestHeaders.Accept.Clear();

            client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));

            var getTask = client.GetAsync(endpoint + method);

            var msg = await getTask;

        }

        private async Task CallServiceAsync()

        {

            string schedulerServiceName = "fabric:/DataServices/Scheduler";

            var resolver = ServicePartitionResolver.GetDefault();

            var partition = await resolver.ResolveAsync(new Uri(schedulerServiceName), ServicePartitionKey.Singleton, CancellationToken.None);

            var endpoints = JObject.Parse(partition.GetEndpoint().Address)["Endpoints"];

            var endpoint = endpoints[""].ToString().TrimEnd('/');

            string method = "/api/scheduler/classes/sync";

            var client = new HttpClient();

            client.DefaultRequestHeaders.Accept.Clear();

            client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));

            var getTask = client.GetAsync(endpoint + method);

            var msg = await getTask;

        }

    {
      "type": "node",
      "request": "launch",
      "name": "Jest All",
      "program": "${workspaceFolder}/node_modules/.bin/jest",
      "args": ["--runInBand"],
      "console": "integratedTerminal",
      "internalConsoleOptions": "neverOpen",
      "windows": {
        "program": "${workspaceFolder}/node_modules/jest/bin/jest",
      }
    }

Find your duplicates

  SELECT    [col1], [col2], COUNT(*)

  FROM      [db].[mstar].[table1]

  GROUP BY  [col1], [col2]

  HAVING    COUNT(*) > 1

THEN

begin transaction

SET NOCOUNT ON

SET ROWCOUNT 1

while 1 = 1

 BEGIN

   DELETE  

   FROM [mstar].[InvalidFundShareClassAttribute]

   WHERE [FundShareClassId]+ [CustomState] IN

        (SELECT  [FundShareClassId]+ [CustomState]

         FROM    [mstar].[InvalidFundShareClassAttribute]

         GROUP BY [FundShareClassId]+ [CustomState]

         HAVING  COUNT(*) > 1)

      IF @@Rowcount = 0

      BREAK ;

end;

 SET ROWCOUNT 0

 rollback;

or commit;

There is another way

;WITH CTE AS 
(
    SELECT EmpName, ROW_NUMBER() OVER 
    (
        PARTITION BY EmpName ORDER BY EmpID
    ) RowNumber
    FROM  dbo.Employee
)
SELECT *FROM CTE WHERE RowNumber > 1
Then

;WITH CTE AS 
(
SELECT EmpName, ROW_NUMBER() OVER 
(
    PARTITION BY EmpName ORDER BY EmpID
) RowNumber
FROM  dbo.Employee
)
DELETE FROM CTE WHERE RowNumber > 1

Find your duplicates

  SELECT    [col1], [col2], COUNT(*)

  FROM      [db].[mstar].[table1]

  GROUP BY  [col1], [col2]

  HAVING    COUNT(*) > 1

THEN

begin transaction

SET NOCOUNT ON

SET ROWCOUNT 1

while 1 = 1

 BEGIN

   DELETE  

   FROM [mstar].[InvalidFundShareClassAttribute]

   WHERE [FundShareClassId]+ [CustomState] IN

        (SELECT  [FundShareClassId]+ [CustomState]

         FROM    [mstar].[InvalidFundShareClassAttribute]

         GROUP BY [FundShareClassId]+ [CustomState]

         HAVING  COUNT(*) > 1)

      IF @@Rowcount = 0

      BREAK ;

end;

 SET ROWCOUNT 0

 rollback;

or commit;

There is another way

;WITH CTE AS 
(
    SELECT EmpName, ROW_NUMBER() OVER 
    (
        PARTITION BY EmpName ORDER BY EmpID
    ) RowNumber
    FROM  dbo.Employee
)
SELECT *FROM CTE WHERE RowNumber > 1
Then

;WITH CTE AS 
(
SELECT EmpName, ROW_NUMBER() OVER 
(
    PARTITION BY EmpName ORDER BY EmpID
) RowNumber
FROM  dbo.Employee
)
DELETE FROM CTE WHERE RowNumber > 1