public long GetId(string screenName)
{
// synchronized read
var sql = "select Id from " + TableName + " where LOWER(ScreenName) = @ScreenName limit 1;";
try
{
using (Descriptor.AcquireReadLock())
using (var con = Descriptor.GetConnection())
{
return(con.Query <long>(sql, new { ScreenName = screenName.ToLower() })
.SingleOrDefault());
}
}
catch (Exception ex)
{
throw DatabaseConnectionHelper.WrapException(ex, "GetId", sql);
}
}
private DatabaseManagement GetValueCore(long id)
{
// synchronized read
var sql = this.CreateSql("Id = @Id");
try
{
using (Descriptor.AcquireReadLock())
using (var con = Descriptor.GetConnection())
{
return(con.Query <DatabaseManagement>(sql, new { Id = id })
.SingleOrDefault());
}
}
catch (Exception ex)
{
throw DatabaseConnectionHelper.WrapException(ex, "GetValueCore", sql);
}
}
