本文整理汇总了C#中System.Data.SqlClient.SqlCommand.ExecuteNonQueryRetryOnDeadlock方法的典型用法代码示例。如果您正苦于以下问题:C# SqlCommand.ExecuteNonQueryRetryOnDeadlock方法的具体用法?C# SqlCommand.ExecuteNonQueryRetryOnDeadlock怎么用?C# SqlCommand.ExecuteNonQueryRetryOnDeadlock使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类System.Data.SqlClient.SqlCommand
的用法示例。
在下文中一共展示了SqlCommand.ExecuteNonQueryRetryOnDeadlock方法的3个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: BlockSentimentToDb
public static void BlockSentimentToDb(SqlConnection connection, long docId, short blockNum, int positives, int negatives, int noTokens)
{
using (SqlCommand cmd = new SqlCommand(null, connection))
{
cmd.CommandTimeout = 300;
cmd.CommandText = ClBlockSentiment;
double polarity = 1.0 * (positives - negatives) / (positives + negatives);
// Console.WriteLine("\n -------------------"+entityUri);
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@document_id", docId);
cmd.Parameters.AddWithValue("@block_id", blockNum);
cmd.Parameters.AddWithValue("@positives", positives);
cmd.Parameters.AddWithValue("@negatives", negatives);
cmd.Parameters.AddWithValue("@polarity", polarity);
cmd.Parameters.AddWithValue("@tokens", noTokens);
try
{
cmd.ExecuteNonQueryRetryOnDeadlock(); //Execute the command
}
catch (Exception ex)
{
string errorMessage = String.Format("\nError inserting block sentiment: \n\t\t DocumentId:{0} \n\t\t BlockNum{1}", docId, blockNum);
throw new Exception(ex + errorMessage);
}
}
}
示例2: TermToDb
/// <summary>
/// Inserts the data about the actual term (string) from teh document
/// </summary>
public static void TermToDb(SqlConnection connection, long occurrenceId, string term)
{
using (SqlCommand cmd = new SqlCommand(null, connection))
{
cmd.CommandTimeout = 300;
cmd.CommandText = ClTerm;
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@occurrence_id", occurrenceId);
cmd.Parameters.AddWithValue("@term", Shorten(term, 400));
try
{
cmd.ExecuteNonQueryRetryOnDeadlock(); //Execute the command
}
catch (Exception)
{
Console.WriteLine("\nTerm insert exception : occurrence_id \t" + occurrenceId + " \t" + term);
}
}
}
示例3: SentenceSentimentToDb
public static void SentenceSentimentToDb(SqlConnection connection, long docId, short blockNum, short sentenceNum, int positives, int negatives, int noTokens)
{
using (SqlCommand cmd = new SqlCommand(null, connection))
{
cmd.CommandTimeout = 300;
cmd.CommandText = ClSentenceSentiment;
double polarity = 1.0 * (positives - negatives) / (positives + negatives);
// Console.WriteLine("\n -------------------"+entityUri);
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@document_id", docId);
cmd.Parameters.AddWithValue("@block_id", blockNum);
cmd.Parameters.AddWithValue("@sentence_id", sentenceNum);
cmd.Parameters.AddWithValue("@positives", positives);
cmd.Parameters.AddWithValue("@negatives", negatives);
cmd.Parameters.AddWithValue("@polarity", polarity);
cmd.Parameters.AddWithValue("@tokens", noTokens);
cmd.ExecuteNonQueryRetryOnDeadlock(); //Execute the command
}
}