# AuditLogContract
> Tracon documentation. Tracon is a .NET package family that adds a control
> plane on Microsoft Agent Framework, published as NuGet packages that run
> inside your own ASP.NET Core application.
>
> Page: https://tracon.dev/api/tracon.testing.contracts.storage.auditlogcontract/
> Summary: AuditLogContract: Behavior tests for the IAuditLog contract.
Behavior tests for the [IAuditLog](/api/tracon.iauditlog/) contract.
```csharp
public abstract class AuditLogContract : TenantIsolationContract, IAsyncLifetime, IAsyncDisposable
```
## Remarks
Every implementation must pass the same scenarios.
## Constructors
### AuditLogContract\(\)
```csharp
protected AuditLogContract()
```
## Properties
### Log
The log under test.
```csharp
protected IAuditLog Log { get; }
```
#### Property Value
[IAuditLog](/api/tracon.iauditlog/)
### QualifiedAuditLogTable
The fully qualified `audit_log` table reference this provider's raw SQL should use.
```csharp
protected virtual string QualifiedAuditLogTable { get; }
```
#### Property Value
[string](https://learn.microsoft.com/dotnet/api/system.string)
### SupportsRawTamper
Whether this store's backing state can be tampered with directly (SQL providers only).
```csharp
protected virtual bool SupportsRawTamper { get; }
```
#### Property Value
[bool](https://learn.microsoft.com/dotnet/api/system.boolean)
## Methods
### Action\_and\_entity\_filter\_works\(\)
```csharp
[Fact]
public Task Action_and_entity_filter_works()
```
#### Returns
[Task](https://learn.microsoft.com/dotnet/api/system.threading.tasks.task)
### Concurrent\_writes\_for\_one\_tenant\_produce\_a\_single\_valid\_chain\(\)
```csharp
[Fact]
public Task Concurrent_writes_for_one_tenant_produce_a_single_valid_chain()
```
#### Returns
[Task](https://learn.microsoft.com/dotnet/api/system.threading.tasks.task)
### CountAsync\(string, CancellationToken\)
Reports how many records the given tenant sees through the listing endpoint.
```csharp
protected override ValueTask CountAsync(string tenantId, CancellationToken cancellationToken)
```
#### Parameters
`tenantId` [string](https://learn.microsoft.com/dotnet/api/system.string)
The reading tenant.
`cancellationToken` [CancellationToken](https://learn.microsoft.com/dotnet/api/system.threading.cancellationtoken)
The token every store call inside the hook must be handed; see
[TenantIsolationContract.SeedAsync](/api/tracon.testing.contracts.storage/).
#### Returns
[ValueTask](https://learn.microsoft.com/dotnet/api/system.threading.tasks.valuetask\-1)<[int](https://learn.microsoft.com/dotnet/api/system.int32)\>
The number of records seen.
### Deleting\_a\_row\_directly\_is\_detected\_as\_a\_gap\(\)
```csharp
[Fact]
public Task Deleting_a_row_directly_is_detected_as_a_gap()
```
#### Returns
[Task](https://learn.microsoft.com/dotnet/api/system.threading.tasks.task)
### Entries\_are\_returned\_newest\_to\_oldest\(\)
```csharp
[Fact]
public Task Entries_are_returned_newest_to_oldest()
```
#### Returns
[Task](https://learn.microsoft.com/dotnet/api/system.threading.tasks.task)
### Entry\_with\_unknown\_actor\_carries\_null\(\)
```csharp
[Fact]
public Task Entry_with_unknown_actor_carries_null()
```
#### Returns
[Task](https://learn.microsoft.com/dotnet/api/system.threading.tasks.task)
### ExecuteRawAsync\(string\)
Runs raw SQL against the backing store. Only called when [AuditLogContract.SupportsRawTamper](/api/tracon.testing.contracts.storage.auditlogcontract/#Tracon_Testing_Contracts_Storage_AuditLogContract_SupportsRawTamper) is [true](https://learn.microsoft.com/dotnet/csharp/language-reference/builtin-types/bool).
```csharp
protected virtual ValueTask ExecuteRawAsync(string sql)
```
#### Parameters
`sql` [string](https://learn.microsoft.com/dotnet/api/system.string)
#### Returns
[ValueTask](https://learn.microsoft.com/dotnet/api/system.threading.tasks.valuetask)
### ExistsAsync\(string, object\)
Reports whether the record is visible from the given tenant's viewpoint.
```csharp
protected override ValueTask ExistsAsync(string tenantId, object key)
```
#### Parameters
`tenantId` [string](https://learn.microsoft.com/dotnet/api/system.string)
The reading tenant.
`key` [object](https://learn.microsoft.com/dotnet/api/system.object)
The key returned by [TenantIsolationContract.SeedAsync](/api/tracon.testing.contracts.storage/).
#### Returns
[ValueTask](https://learn.microsoft.com/dotnet/api/system.threading.tasks.valuetask\-1)<[bool](https://learn.microsoft.com/dotnet/api/system.boolean)\>
[true](https://learn.microsoft.com/dotnet/csharp/language-reference/builtin-types/bool) if the record is visible.
### First\_entry\_of\_a\_tenant\_carries\_no\_previous\_hash\(\)
```csharp
[Fact]
public Task First_entry_of_a_tenant_carries_no_previous_hash()
```
#### Returns
[Task](https://learn.microsoft.com/dotnet/api/system.threading.tasks.task)
### FormatIdForRawSql\(Guid\)
Formats an id for embedding in raw SQL. A provider that stores a
[Guid](https://learn.microsoft.com/dotnet/api/system.guid) as text and compares case-sensitively (SQLite, in
uppercase) must override the default (lowercase
[Guid.ToString](https://learn.microsoft.com/dotnet/api/system.guid)).
```csharp
protected virtual string FormatIdForRawSql(Guid id)
```
#### Parameters
`id` [Guid](https://learn.microsoft.com/dotnet/api/system.guid)
#### Returns
[string](https://learn.microsoft.com/dotnet/api/system.string)
### Limit\_constrains\_the\_result\(\)
```csharp
[Fact]
public Task Limit_constrains_the_result()
```
#### Returns
[Task](https://learn.microsoft.com/dotnet/api/system.threading.tasks.task)
### No\_leakage\_between\_tenants\(\)
```csharp
[Fact]
public Task No_leakage_between_tenants()
```
#### Returns
[Task](https://learn.microsoft.com/dotnet/api/system.threading.tasks.task)
### Null\_tenant\_follows\_the\_ambient\_tenant\_when\_it\_changes\(\)
```csharp
[Fact]
public Task Null_tenant_follows_the_ambient_tenant_when_it_changes()
```
#### Returns
[Task](https://learn.microsoft.com/dotnet/api/system.threading.tasks.task)
### Null\_tenant\_resolves\_to\_the\_ambient\_tenant\_and\_does\_not\_leak\_others\(\)
```csharp
[Fact]
public Task Null_tenant_resolves_to_the_ambient_tenant_and_does_not_leak_others()
```
#### Returns
[Task](https://learn.microsoft.com/dotnet/api/system.threading.tasks.task)
### Second\_entry\_links\_to\_the\_first\(\)
```csharp
[Fact]
public Task Second_entry_links_to_the_first()
```
#### Returns
[Task](https://learn.microsoft.com/dotnet/api/system.threading.tasks.task)
### SeedAsync\(string, string, CancellationToken\)
Writes a sample record for the given tenant.
```csharp
protected override ValueTask