本文整理汇总了C#中FirebirdSql.Data.FirebirdClient.FbConnection.ExecuteScalar方法的典型用法代码示例。如果您正苦于以下问题：C# FbConnection.ExecuteScalar方法的具体用法？C# FbConnection.ExecuteScalar怎么用？C# FbConnection.ExecuteScalar使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类FirebirdSql.Data.FirebirdClient.FbConnection的用法示例。
在下文中一共展示了FbConnection.ExecuteScalar方法的2个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: VersionAlreadyApplied
private static bool VersionAlreadyApplied(FbConnection connection, int version)
{
bool alreadyApplied = false;
bool tableExists = Convert.ToBoolean(connection.ExecuteScalar(@"SELECT count(*) FROM rdb$relations where rdb$relation_name = 'HANGFIRE.SCHEMA';"));
if (tableExists)
alreadyApplied = Convert.ToBoolean(connection.ExecuteScalar(string.Format(@"SELECT 1 FROM ""HANGFIRE.SCHEMA"" WHERE ""VERSION"" = {0};", version)));
return alreadyApplied;
}示例2: CreateExpirationEntry
private static int CreateExpirationEntry(FbConnection connection, FirebirdStorageOptions options, DateTime? expireAt)
{
string insertSqlNull = @"
INSERT INTO """ + options.Prefix + @".COUNTER"" (""KEY"", ""VALUE"", expireat)
VALUES ('key', 1, null)
RETURNING id;";
string insertSqlValue = @"
INSERT INTO """ + options.Prefix + @".COUNTER"" (""KEY"", ""VALUE"", expireat)
VALUES ('key', 1, DATEADD(second, {0:N5}, " + string.Format(CultureInfo.InvariantCulture, @"DATEADD(minute, -{0:N5}*60, current_timestamp))) ", options.UtcOffset) +
"RETURNING id;";
string insertSql = expireAt == null ? insertSqlNull : string.Format(insertSqlValue, ((long)(expireAt.Value - DateTime.UtcNow).TotalSeconds).ToString(CultureInfo.InvariantCulture));
var recordId = connection.ExecuteScalar<int>(insertSql);
return recordId;
}