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?