C# PHP Pra C#

[desconto]

Pessoal , tudo bem? eu tenho um sistema de sorteio em php , porem tenho que muda para c#
Alguem poderia me dizer como eu executo isso dentro do C#?

$query = "SELECT
                *
                FROM
                silks_sorteio
                ORDER BY id DESC
                LIMIT 1
                ";
                        
$result = mysql_query($query);
$rel = mysql_fetch_array($result);
$ultimo_char =  $rel['CharName'];
        mysql_query("TRUNCATE TABLE char_on");
        $query =  "SELECT 
        CharID, CharName16
        FROM SRO_VT_SHARD.dbo._Char
        WHERE Deleted != 1";
        $result = mssql_query($query);
        $chares = "";
        while ($res = mssql_fetch_array($result)) {
                $charid = $res['CharID'];
                $charname = $res['CharName16'];
                $query2 = "SELECT TOP(1) * FROM LOG_DB.dbo._LogEventChar WHERE CharID = '$charid' AND EventID IN (4, 6) ORDER BY EventTime DESC";
                $result2 = mssql_query($query2);
                $rel2 = mssql_fetch_array($result2);
                $evento = $rel2['EventID'];
                $tempo = $rel2['EventTime'];
                if($evento == 4){
                $query3 = "INSERT INTO 
                Char_On
                (CharName) value('$charname')";
                $result3 = mysql_query($query3)or die(mysql_error()); 
                }
        }
                $query = "SELECT id FROM char_on LIMIT 1";
                $result = mysql_query($query);
                $rel = mysql_fetch_array($result);
                $primeiro_id = $rel[id];
                
                $query = "SELECT id FROM char_on ORDER BY id DESC LIMIT 1";
                $result = mysql_query($query);
                $rel = mysql_fetch_array($result);
                $ultimo_id = $rel[id];
                
                $sortiado  =rand($primeiro_id, $ultimo_id);
                $query = "SELECT * FROM char_on WHERE id = $sortiado";
                $result = mysql_query($query);
                $rel = mysql_fetch_array($result);
                $char_sortiado = $rel['CharName'];
                //echo "<script type='text/javascript'>console.info('$char_sortiado')</script>";
                while($char_sortiado == $ultimo_char && $char_sortiado != "Bragi" && $char_sortiado != "Test"){
                $sortiado  =rand($primeiro_id, $ultimo_id);
                $query = "SELECT * FROM char_on WHERE id = $sortiado";
                $result = mysql_query($query);
                $rel = mysql_fetch_array($result);
                $char_sortiado = $rel['CharName'];
                echo "<script type='text/javascript'>console.info('$char_sortiado')</script>";
                }
                if($char_sortiado != $ultimo_char && $char_sortiado != "Bragi" && $char_sortiado != "Test"){
                
                
                $query = "SELECT UserJID FROM SRO_VT_ACCOUNT.dbo.SR_ShardCharNames WHERE CharName = '$char_sortiado'";
                $result = mssql_query($query);
                $rel = mssql_fetch_array($result);
                $user_jid = $rel['UserJID'];
                
                
                
                $query = "SELECT StrUserID FROM SRO_VT_ACCOUNT.dbo.Tb_User WHERE JID = $user_jid";
                $result = mssql_query($query);
                $rel = mssql_fetch_array($result);
                $user_id = $rel['StrUserID'];
                $query = "SELECT Top(1) BuyNo FROM SRO_VT_ACCOUNT.dbo.SK_SilkBuyList ORDER BY BuyNo DESC";
                $result = mssql_query($query);
                $rel = mssql_fetch_array($result);
                $BuyNo = $rel['BuyNo']+1;
                $quantiade_sortiada = rand(1, $sorteio['quantidade']); 

while ($res = mssql_fetch_array($result)) {
                $charid = $res['CharID'];
                $charname = $res['CharName16'];
                $query2 = "SELECT TOP(1) * FROM LOG_DB.dbo._LogEventChar WHERE CharID = '$charid' AND EventID IN (4, 6) ORDER BY EventTime DESC";
                $result2 = mssql_query($query2);
                $rel2 = mssql_fetch_array($result2);
                $evento = $rel2['EventID'];
                $tempo = $rel2['EventTime'];
                if($evento == 4){
                $query3 = "INSERT INTO 
                Char_On
                (CharName) value('$charname')";
                $result3 = mysql_query($query3)or die(mysql_error()); 
                }
        } 

essa parte é a mais dificil pois tem uma query dentro do while e eu tentei fazer com o c# e não consegui .

na verdade não consegui fazer nada ainda :/

[Dano]

procura sobre CRUD C# com MySql.

[desconto]

Eu tentei fazer Uma SQLCommand e fazer outro Command dentro do while porem sem sucesso alguem sabe como eu deveria agir?