public HighScore SelectedPlayer(string playerName)
{
using IDbConnection connection = new System.Data.SqlClient.SqlConnection(Helper.ConnString("CardGame"));
var currentPlayer = connection.QueryFirst <HighScore>($"select H.player, H.Score from HighScore as H where H.player = '{playerName}'");
return(currentPlayer);
//return connection.QueryFirst<HighScore>($"select H.player from HighScore as H where H.Id = {id}");
//return connection.Query<HighScore>($"select H.player from HighScore as H where H.Id = {id}");
}
public WarmUp()
{
Console.WriteLine("开启预热");
//预热处理
for (int i = 0; i < 2; i++)
{
using (SqlConnection conn = new SqlConnection(PubConst.connectionString))
{
var list = conn.QueryFirst<Test>("select top 1 * from Test");
conn.Update(new Test());
}
using (SqlSugarClient conn = new SqlSugarClient(PubConst.connectionString))
{
var list = conn.Queryable<Test>().Where(it => 1 == 2).ToList();
conn.Update(new Test());
}
}
Console.WriteLine("预热完毕");
Console.WriteLine("----------------比赛开始-------------------");
}
public HighScore GetSingleHighScore()
{
using IDbConnection connection = new System.Data.SqlClient.SqlConnection(Helper.ConnString("CardGame"));
return(connection.QueryFirst <HighScore>("select * from HighScore"));
}
