请将php代码转换为c#代码

<?php

    //connection information
    $host = "localhost";
    $user = "root";
    $password = "your_mysql_password_here";
    $database = "test";
    $param = $_GET["term"];

    //make connection
    $server = mysql_connect($host, $user, $password);
    $connection = mysql_select_db($database, $server);

    //query the database
    $query = mysql_query("SELECT * FROM friends WHERE name REGEXP '^$param'");

    //build array of results
    for ($x = 0, $numrows = mysql_num_rows($query); $x < $numrows; $x++) {
        $row = mysql_fetch_assoc($query);

        $friends[$x] = array("name" => $row["name"]);
    }

    //echo JSON to page
    $response = $_GET["callback"] . "(" . json_encode($friends) . ")";
    echo $response;

    mysql_close($server);

?>

请帮助我......

Please help me......