src/02_Data/Data.Abstractions/Adapter/DbAdapterAbstract.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Data;
using System.Text;
using Mkh.Data.Abstractions.Descriptors;
using Mkh.Data.Abstractions.Options;
using Mkh.Utils.Helpers;

namespace Mkh.Data.Abstractions.Adapter;

/// <summary>
/// 数据库适配器抽象类
/// </summary>
public abstract class DbAdapterAbstract : IDbAdapter
{
    protected static SequentialGuidGenerator GuidGenerator = new();

    public abstract DbProvider Provider { get; }

    public DbOptions Options { get; set; }

    public virtual char LeftQuote => '"';

    public virtual char RightQuote => '"';

    public virtual char ParameterPrefix => '@';

    public virtual string IdentitySql => "";

    public virtual bool SqlLowerCase => false;

    public virtual string BooleanTrueValue => "1";

    public virtual string BooleanFalseValue => "0";

    public string AppendQuote(string value)
    {
        var val = value?.Trim();
        if (val != null && SqlLowerCase)
            val = val.ToLower();

        return $"{LeftQuote}{val}{RightQuote}";
    }

    public void AppendQuote(StringBuilder sb, string value)
    {
        sb.Append(AppendQuote(value));
    }

    public string AppendParameter(string parameterName)
    {
        return $"{ParameterPrefix}{parameterName}";
    }

    public void AppendParameter(StringBuilder sb, string parameterName)
    {
        sb.Append(AppendParameter(parameterName));
    }

    public abstract IDbConnection NewConnection(string connectionString);