Abp VNext 数据库字段类型转换 模块

Type Mapping

• SqlServer
  • To CSharp
  • To MaxCompute
  • To PostgreSql
  • To MySql
• MySql
  • To CSharp
  • To MaxCompute
• Oracle
  • To CSharp
• PostgreSql
  • To CSharp
• Sqlitle
  • To CSharp

安装Nuget包

dotnet add package iBestRead.Abp.DbTypeConvert

使用

引用模块

[DependsOn(typeof(AbpDbTypeConvertModule))]
public class DbTypeConvertTestModule : AbpModule
{
  
}

注入服务

private readonly IDbTypeConvert _dbTypeConvert;
public YourApplicationService(IDbTypeConvert dbTypeConvert)
{
    _dbTypeConvert = dbTypeConvert;
}

public void SqlServer_To_CSharp()
{
		_dbTypeConvert.ToCSharpType(DbProvider.SqlServer, "varbinary"); // byte[]
		_dbTypeConvert.ToCSharpType(DbProvider.SqlServer, "text"); // string
		_dbTypeConvert.ToCSharpType(DbProvider.SqlServer, "uniqueidentifier"); // Guid
  	_dbTypeConvert.ToCSharpType(DbProvider.SqlServer, "smalldatetime"); // DateTime
  	_dbTypeConvert.ToCSharpType(DbProvider.SqlServer, "int"); // int
    // ...
}

public void SqlServer_To_MaxCompute()
{
    _dbTypeConvert.ToMaxComputeType(DbProvider.SqlServer, "varbinary"); // BINARY
    _dbTypeConvert.ToMaxComputeType(DbProvider.SqlServer, "text"); // STRING
    _dbTypeConvert.ToMaxComputeType(DbProvider.SqlServer, "uniqueidentifier"); // STRING
    _dbTypeConvert.ToMaxComputeType(DbProvider.SqlServer, "smalldatetime"); // DATETIME
    _dbTypeConvert.ToMaxComputeType(DbProvider.SqlServer, "int"); // INT
    // ...  
}

更多

请参考单元测试