本文整理汇总了C#中System.Data.SQLite.SQLiteDataReader.Dispose方法的典型用法代码示例。如果您正苦于以下问题:C# SQLiteDataReader.Dispose方法的具体用法?C# SQLiteDataReader.Dispose怎么用?C# SQLiteDataReader.Dispose使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类System.Data.SQLite.SQLiteDataReader
的用法示例。
在下文中一共展示了SQLiteDataReader.Dispose方法的4个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: GetHighScores
public Dictionary<String, long> GetHighScores()
{
Dictionary<String, long> topResults = new Dictionary<String, long>();
dbConnection.Open();
reader = this.selectTopScores.ExecuteReader();
while (reader.Read())
{
topResults.Add(reader["name"].ToString(), (long)reader["result"]);
}
reader.Dispose();
dbConnection.Close();
return topResults;
}
示例2: getLowestHighscore
/// <summary>
/// Database has table with highscore. This method will search for lowest result. If there is smaller number of maximum allowed top scores it will return -1
/// </summary>
/// <param name="maximumTopScores"></param>
/// <returns></returns>
public long getLowestHighscore(int maximumTopScores)
{
long numberOfScores = -1;
long lowestScore = -1;
dbConnection.Open();
reader = selectLowestResult.ExecuteReader();
int counter = 0;
while (reader.Read())
{
lowestScore = (long)reader["result"];
counter++;
}
reader.Dispose();
dbConnection.Close();
if (numberOfScores < maximumTopScores)
{
return -1;
}
return lowestScore;
}
示例3: InsertHighScore
public void InsertHighScore(String name, long result, int maximumTopScores)
{
insertHighscoreCommand.Parameters.Add(new SQLiteParameter("param1", name));
insertHighscoreCommand.Parameters.Add(new SQLiteParameter("param2", result));
dbConnection.Open();
int insertRes = insertHighscoreCommand.ExecuteNonQuery();
// leave only TOP maximumTopScores
reader = selectTopScores.ExecuteReader();
List<long> topResults = new List<long>();
while (reader.Read())
{
topResults.Add((long)(reader["result"]));
}
reader.Dispose();
long resultToRemove = -1;
if (topResults.Count > maximumTopScores)
{
// read resultOfLast and go to next first that is different (maybe in some cases maximumTopScores and next one will have same result)
long resultOfLast = topResults[maximumTopScores-1];
for (int i = maximumTopScores - 1; i < topResults.Count; i++)
{
if (!topResults[i].Equals(resultOfLast))
{
resultToRemove = topResults[i];
}
}
}
if (resultToRemove != -1)
{
removeInvalidHighscores.Parameters.Add(new SQLiteParameter("param1", resultToRemove));
int deleteRes = removeInvalidHighscores.ExecuteNonQuery();
}
dbConnection.Close();
}
示例4: FreeQuery
public void FreeQuery( SQLiteDataReader dataReader )
{
dataReader.Dispose();
}