Add ValueTask support for PipelineBuilder

• Add ExecuteCommandAndCapture/ExecuteCommandAndCaptureAsync for returning CommandResult
• Add ConsoleHelper.PrintOutput extension for CommandResult
• Rename EnsureSuccessfulExitCode to EnsureSuccessExitCode likes HttpResponseMessage.EnsureSuccessStatusCode()

add logging filter so we can specific the logs we do not wanna record

refact HttpRequester with HttpClient

• IHttpRequester
• WebRequestHttpRequester
• HttpClientHttpRequester

Add .NET 8.0 target support

• Add net8.0 target for Common
• Add net6.0 for extensions
  • Castle extensions
  • Serilog extensions

大佬 weihanli.npoi 咋不更新了

Introduce ReadOnlyRepository for query only

for example:

Hello {{name|upper}}


Hello {{ date | date:"yyyy-MM-dd" }}


Hello {{ name | replace:"123":"Abc" | upper }}

• https://angular.io/guide/pipes

数据库MSSQL Server，
使用的查询语句：select ArmId as Id,ArmName as Name from arm
位置：
WeihanLi.Common/Helpers/SecurityHelper.cs

使用两种表达式验证
IsSafeSqlString 方法都是返回false，
该方法不能用于执行sql语句前判断注入吗?

Implement a JSON data builder for Nested JSON support

WeihanLi/dotnet-httpie#55

• support get value from the environment

For example:

var result = TemplateEngine.CreateDefault().RenderAsync("Hello {{$env USERNAME}}");
Console.WriteLine(result);

API changes:

public interface ITemplateRenderer
{
-     Task<string> RenderAsync(TemplateRenderContext template, object globals);
+     Task<string> RenderAsync(TemplateRenderContext template, object? globals = null);
}

Create this issue for tracking the nullable reference types.
Now all projects had enabled nullable reference types, but some API may not as expected, create issue for tracking these API

Built-in ioc support

dependency injection

• 数据库扩展，DataTable 转换为 POCO 时性能需要提升
• 需要提供 PropertyGetter 和 PropertySetter 以及内部缓存

这里应该用 outStream.ToArray not outStream.GetBuffer

Simple command line parser to parse the command line input and avoid issue:
dotnet/command-line-api#1385

Refer to https://github.com/dotnet/command-line-api/blob/b4bbdd2869fb7d500b5d91e32c84cfa69eb3b645/src/System.CommandLine/Parsing/CliParser.cs#L40

Possible implement:

class CommandLineParer
{
    public static IEnumerable<string> SplitCommandLine(string commandLine)
    {
        var memory = commandLine.AsMemory();

        var startTokenIndex = 0;

        var pos = 0;

        var seeking = Boundary.TokenStart;
        var seekingQuote = Boundary.QuoteStart;

        while (pos < memory.Length)
        {
            var c = memory.Span[pos];

            if (char.IsWhiteSpace(c))
            {
                if (seekingQuote == Boundary.QuoteStart)
                {
                    switch (seeking)
                    {
                        case Boundary.WordEnd:
                            yield return CurrentToken();
                            startTokenIndex = pos;
                            seeking = Boundary.TokenStart;
                            break;

                        case Boundary.TokenStart:
                            startTokenIndex = pos;
                            break;
                    }
                }
            }
            else if (c == '\"')
            {
                if (seeking == Boundary.TokenStart)
                {
                    switch (seekingQuote)
                    {
                        case Boundary.QuoteEnd:
                            yield return CurrentToken();
                            startTokenIndex = pos;
                            seekingQuote = Boundary.QuoteStart;
                            break;

                        case Boundary.QuoteStart:
                            startTokenIndex = pos + 1;
                            seekingQuote = Boundary.QuoteEnd;
                            break;
                    }
                }
                else
                {
                    switch (seekingQuote)
                    {
                        case Boundary.QuoteEnd:
                            seekingQuote = Boundary.QuoteStart;
                            break;

                        case Boundary.QuoteStart:
                            seekingQuote = Boundary.QuoteEnd;
                            break;
                    }
                }
            }
            else if (seeking == Boundary.TokenStart && seekingQuote == Boundary.QuoteStart)
            {
                seeking = Boundary.WordEnd;
                startTokenIndex = pos;
            }

            Advance();

            if (IsAtEndOfInput())
            {
                switch (seeking)
                {
                    case Boundary.TokenStart:
                        break;
                    default:
                        yield return CurrentToken();
                        break;
                }
            }
        }

        void Advance() => pos++;

        string CurrentToken()
        {
            return memory.Slice(startTokenIndex, IndexOfEndOfToken()).ToString().Trim('"');
        }

        int IndexOfEndOfToken() => pos - startTokenIndex;

        bool IsAtEndOfInput() => pos == memory.Length;
    }

    private enum Boundary
    {
        TokenStart,
        WordEnd,
        QuoteStart,
        QuoteEnd
    }
}

• 查询多条数据的时候先转了datatable，然后才转的 Entity

• 抽象 DataReader 数据到 Entity 的转换，支持更多数据类型，如简单类型 int/long/string，甚至更为复杂的对象如 Dictionary 等，并去掉 TEntity new() 限制，可以参考 dapper 实现

• https://github.com/WeihanLi/WeihanLi.Common/blob/dev/src/WeihanLi.Common/Extensions/DbCommandExtension.tt#L30

• https://github.com/WeihanLi/WeihanLi.Common/blob/dev/src/WeihanLi.Common/Extensions/DbCommandExtension.tt#L38

• add logging event
• add logging formatter
• add logging enricher
• add logging builder

Currently, we only support one field orderBy, while in some scenes, we may need to order by multi fields.

Add the following methods to IRepository interface:
int Update(TEntity entity, params Expression<Func<TEntity, object>>[] propertyExpressions);
int Update(TEntity entity, params string[] propertyNames);
Task UpdateAsync(TEntity entity, Expression<Func<TEntity, object>>[] propertyExpressions, CancellationToken cancellationToken = default);
Task UpdateAsync(TEntity entity, string[] propertyNames, CancellationToken cancellationToken = default);

Purpose:
Make application service layer depend the IRepository instead of the IEFRepository layer so it decouples the domain service and the infrusture.

Update SecurityHelper.Random for a thread safe one

Add CancellationToken support for CommandExecutor.ExecuteAsync/CommandExecutor.ExecuteAndCaptureAsync

SqlBulkCopy支持设置 BulkCopyTimeout

• Currently, the event needs a strong-typed event instance that implements IEventBase, maybe we could remove the constraint to make it much easier to use.
• Secondly, maybe we could add headers/properties support for better flexibility
• Event data serializer customize to support distributed events（not needed for local event processing）
• It would be great to support routing(out of scope)

https://github.com/cloudevents/spec/blob/v1.0.2/cloudevents/spec.md

add AOP abstracts and implement for AspectCore and Castle

https://github.com/adamralph/simple-exec/pull/601/files#diff-132c1b1e73b99f5cf1a0326771282ea66bea33f79a976fc6cb117f8fd2bb8810L26

• Built-In IoC
• Built-In AOP
• Built-In Repository
• Built-In Logging
• Built-In TOTP implement
• Built-In EventBus
• Built-In PipelineBuilder
• Built-In Cron
• #120
• #121
• #170
• And More ...

Ado.Net 默认的超时时间是 30s，有一些比较复杂或者数据量较大的查询可能会超过30s，需要提供一个参数支持手动设置 timeout 以方便调用

There are many warnings for AOT, let's fix them

https://devblogs.microsoft.com/dotnet/creating-aot-compatible-libraries/

Add ITenantIdProvider likes IUserIdProvider

Add ContextAccessor to easily use context like IHttpContextAccessor