御用小本本

參照

Startup Templates/Console | Documentation Center | ABP.IO

指令

• dotnet tool install -g Volo.Abp.Cli
• abp new Acme.MyConsoleApp -t console -csf
• dotnet add Volo.Abp.Dapper
• dotnet add Microsoft.Data.SqlClient
• dotnet add Microsoft.Extensions.Http

Dapper

Entity

public class Order
{
    public Guid Id { get; set; }
    public string OrderNumber { get; set; }
}

Query

using var conn = new SqlConnection("connectionString");
var sql = "SELECT TOP 5 * FROM AppOrders";
var results = conn.Query<Order>(sql).ToList();

P.S. MySql 要用 Nuget 改裝 MySql.Data 然後改用 MySqlConnection

Typed HttpClient

Test Client

public class TestClient
{
    private readonly HttpClient _client;
    public TestClient(HttpClient client)
    {
        _client = client;
    }
    public async Task<string>GetAccountAsync(string name)
    {
        var response = await _client.GetAsync($"/api/abp/multi-tenancy/tenants/by-name/{name}");
        return response.IsSuccessStatusCode ? response.Content.ReadAsStringAsync().Result : null;
    }
}

Module

private void ConfigureHttpClient(ServiceConfigurationContext context, IConfiguration configuration)
{
    context.Services.AddHttpClient<TestClient>(opt =>
    {
        if (Uri.TryCreate(configuration["BaseAddress"], UriKind.Absolute, out var uri))
        {
            opt.BaseAddress = uri;
        }
    });
}

Service

public class HelloWorldService : ITransientDependency
{
    public ILogger<HelloWorldService> Logger { get; set; }
    private readonly TestClient _client;

    public HelloWorldService(TestClient client)
    {
        _client = client;
        Logger = NullLogger<HelloWorldService>.Instance;
    }

    public async Task SayHelloAsync()
    {
        var response = await _client.GetAccountAsync("HelloWorld");
        Logger.LogDebug("Response: {@Response}",response);
    }
}

appsettings.secrets.json

{
  "ConnectionStrings": {
    "Default": "Server=(LocalDb)\\MSSQLLocalDB;Database=TestDb;Trusted_Connection=True"
  },
  "BaseAddress": "https://test-api-dev.azurewebsites.net"
}

結論

public class HelloWorldService : ITransientDependency
{
    public ILogger<HelloWorldService> Logger { get; set; }
    private readonly TestClient _client;
    private readonly IConfiguration _configuration;

    public HelloWorldService(TestClient client, IConfiguration configuration)
    {
        _client = client;
        _configuration = configuration;
        Logger = NullLogger<HelloWorldService>.Instance;
    }

    public async Task SayHelloAsync()
    {
        Logger.LogInformation("Hello World!");
        var connectionString = _configuration.GetConnectionString("Default");
        using var conn = new SqlConnection(connectionString);
        var sql = "SELECT TOP 5 * FROM AppOrders";
        var results = conn.Query<Order>(sql).ToList();
        Logger.LogDebug("{@Orders}",results);
        var orderNumber = results.FirstOrDefault()?.OrderNumber;
        Logger.LogDebug("Number: {@Number}",orderNumber);
        var response = await _client.GetAccountAsync(orderNumber);
        Logger.LogDebug("Response: {@Response}",response);
        Logger.LogInformation("Finish {@Method}!",nameof(SayHelloAsync));
    }
}

範例程式碼

jakeuj/abp-console-samples: Abp console Dapper and HttpClient samples (github.com)