Cosmokey.DALHelper
1.0.0
See the version list below for details.
dotnet add package Cosmokey.DALHelper --version 1.0.0
NuGet\Install-Package Cosmokey.DALHelper -Version 1.0.0
<PackageReference Include="Cosmokey.DALHelper" Version="1.0.0" />
paket add Cosmokey.DALHelper --version 1.0.0
#r "nuget: Cosmokey.DALHelper, 1.0.0"
// Install Cosmokey.DALHelper as a Cake Addin
#addin nuget:?package=Cosmokey.DALHelper&version=1.0.0
// Install Cosmokey.DALHelper as a Cake Tool
#tool nuget:?package=Cosmokey.DALHelper&version=1.0.0
[Table("sys_table")] public class SysConnectionDbEntity : BaseEntity { [MaxLength(1024)] public string Name { get; set; } = ""; }
internal class UserMysqlDB : IUseDb
{
public static IUseDb UseDb = new UserMysqlDB();
public DbContextOptionsBuilder Use(DbContextOptionsBuilder optionsBuilder, string connectionString)
{
return optionsBuilder.UseMySQL(connectionString);
}
}
internal class DbConnections
{
public DbWayConnection? Setting { get; set; }
}
internal class SSOSettingContext : BaseContext
{
public SSOSettingContext(IUseDb useDb, string connStr) : base(useDb, connStr) { }
public static SSOSettingContext Create(IUseDb useDb, string connStr)
{
return new SSOSettingContext(useDb, connStr);
}
public virtual DbSet<SysConnectionDbEntity>? SysConnection { get; set; }
}
internal class SysConnectionRepository : EFContextFactory<SysConnectionDbEntity, SSOSettingContext>
{
public SysConnectionRepository(
OperaterModel loginUser,
ILogger<SysConnectionRepository> logger,
IOptionsMonitor<DbConnections> dbConnections
) : base(loginUser, logger, dbConnections.CurrentValue.Setting, UserMysqlDB.UseDb, SSOSettingContext.Create)
{
}
public SysConnectionRepository(
OperaterModel loginUser,
ILogger<SysConnectionRepository> logger,
DbConnections dbConnections
) : base(loginUser, logger, dbConnections.Setting, UserMysqlDB.UseDb, SSOSettingContext.Create)
{
}
}
string strConn = string.Format("server={0};port={1};user id={2};persistsecurityinfo=True;database=dev_setting;password={3};CharSet=utf8", "127.0.0.1", "3306", "root", "ping123456");
var wayConnection = new DbWayConnection() { Read = strConn, Write = strConn }; var dbConnections = new DbConnections() { Setting = wayConnection };
SysConnectionRepository repository = new SysConnectionRepository(new OperaterModel() { Account = "sys", UserID = "sys", UserName = "sys" }, null, dbConnections);
var list = await repository.GetAllAsync();
Product | Versions Compatible and additional computed target framework versions. |
---|---|
.NET | net6.0 is compatible. net6.0-android was computed. net6.0-ios was computed. net6.0-maccatalyst was computed. net6.0-macos was computed. net6.0-tvos was computed. net6.0-windows was computed. net7.0 was computed. net7.0-android was computed. net7.0-ios was computed. net7.0-maccatalyst was computed. net7.0-macos was computed. net7.0-tvos was computed. net7.0-windows was computed. net8.0 was computed. net8.0-android was computed. net8.0-browser was computed. net8.0-ios was computed. net8.0-maccatalyst was computed. net8.0-macos was computed. net8.0-tvos was computed. net8.0-windows was computed. |
-
net6.0
- Cosmokey.DALModels (>= 1.0.0)
- Microsoft.EntityFrameworkCore (>= 6.0.8)
- Microsoft.EntityFrameworkCore.Relational (>= 6.0.8)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.