Cosmokey.DALHelper
1.2.0
dotnet add package Cosmokey.DALHelper --version 1.2.0
NuGet\Install-Package Cosmokey.DALHelper -Version 1.2.0
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.
<PackageReference Include="Cosmokey.DALHelper" Version="1.2.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add Cosmokey.DALHelper --version 1.2.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: Cosmokey.DALHelper, 1.2.0"
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package.
// Install Cosmokey.DALHelper as a Cake Addin
#addin nuget:?package=Cosmokey.DALHelper&version=1.2.0
// Install Cosmokey.DALHelper as a Cake Tool
#tool nuget:?package=Cosmokey.DALHelper&version=1.2.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
[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. |
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.
-
net6.0
- Cosmokey.DALModels (>= 1.2.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.