jernejk

public async Task InsertTweetStoreProc(string username, string message, CancellationToken ct = default)
{
    using (_logger.BeginScope(new Dictionary<string, object> { { "EFQueries", "GetTweetsLog" } }))
    {
        _ = await _context.Database
            .ExecuteSqlRawAsync(
                "InsertTweet @Username, @Message",
                new SqlParameter("Username", username),
                new SqlParameter("Message", message));
    }

jernejk

@EventType = 0xE9507561

jernejk

public async Task InsertTweetStoreProc(string username, string message, CancellationToken ct = default)
{
    using (_logger.BeginScope(new Dictionary<string, object> { { "EFQueries", "InsertTweetStoreProc" } }))
    {
        _ = await _context.Database
            .ExecuteSqlRawAsync(
                "InsertTweet @Username, @Message",
                new SqlParameter("Username", username),
                new SqlParameter("Message", message));
    }

jernejk

param(
    [Parameter()]
    [ValidateNotNullOrEmpty()]
    [string] $ResourceGroup = $null,

    [Parameter()]
    [ValidateNotNullOrEmpty()]
    [string] $ResourceLocation = 'EastUS',

    # F0 is free and S0 is paid SKU

jernejk

public async Task<IEnumerable<Tweet>> GetTweetsWithExtraLogs(CancellationToken ct = default)
{
    using (_logger.BeginScope(new Dictionary<string, object> { { "EFQueries", "GetTweetsLog" } }))
    {
        return await _context.Tweets
            .TagWith("GetTweets + LogContext")
            .ToListAsync(ct)
            .ConfigureAwait(false);
    }
}

jernejk

public Task InsertTweetStoreProc(string username, string message, CancellationToken ct = default)
{
    using (_logger.BeginScope(new Dictionary<string, object> { { "EFQueries", "InsertTweetStoreProc" } }))
    {
        _ = _context.Tweets
            .FromSqlRaw(
                "InsertTweet @Username, @Message",
                new SqlParameter("Username", username),
                new SqlParameter("Message", message))
            // A hack to make STORE PROC work when they don't return anything.

jernejk

public async Task InsertTweet(string username, string message, CancellationToken ct = default)
{
    using (_logger.BeginScope(new Dictionary<string, object> { { "EFQueries", "InsertTweet" } }))
    {
        _context.Tweets.Add(new Tweet
        {
            Username = username,
            Message = message,
            CreatedUtc = DateTime.UtcNow
        });

jernejk

using (_logger.BeginScope(new Dictionary<string, object> { { "EFQueries", "GetTweets" } }))
{
    var tweets = await _twitterService.GetTweets(ct);
}
 
// Same query as before.
public async Task<IEnumerable<Tweet>> GetTweets(CancellationToken ct = default)
{
    return await _context.Tweets
        .ToListAsync(ct)

jernejk

public async Task<IEnumerable<Tweet>> GetTweetsWithQueryTags(CancellationToken ct = default)
{
    return await _context.Tweets
        .TagWith("GetTweets")
        .ToListAsync(ct)
        .ConfigureAwait(false);
}

jernejk

public async Task InsertTweetWithoutLogScope(string username, string message, CancellationToken ct = default)
{
    _context.Tweets.Add(new Tweet
    {
        Username = username,
        Message = message
    });

    await _context.SaveChangesAsync(ct);
}