LibrameStandard.EntityFrameworkCore.MsSqlServer 4.20.1808.271

LibrameStandard

Install LibrameStandard (The New Version: 4.20.1808.271)

To install LibrameStandard, run the following command in the Package Manager Console

PM> Install-Package LibrameStandard

Use DependencyInjection

var services = new ServiceCollection();

Register LibrameStandard

services.AddLibrameStandard(options =>
{
    // Algorithm Extension
    options.PostConfigureAlgorithm = opts => { ... };
    // Drawing Extension
    options.PostConfigureDrawing = opts => { ... };
    // Entity Extension
    options.PostConfigureEntity = opts => { ... };
    // Network Extension
    options.PostConfigureNetwork = opts => { ... };
    // Platform Extension
    options.PostConfigurePlatform = opts => { ... };
});

Build ServiceProvider

var serviceProvider = services.BuildServiceProvider();

1 Algorithm Extension

Configure Extension

......
options.PostConfigureAlgorithm = opts =>
{
    // Reset key string refer to ResetAlgorithmExtensionOptionsTests.cs
    opts.Identifier = "...";
};
......

Use Extension

// Hash Algorithm
var hash = serviceProvider.GetRequiredService<IHashAlgorithm>();
var md5 = hash.Md5("str");
var sha1 = hash.Sha1("str");
......

// HMAC Hash Algorithm
var hmacHash = serviceProvider.GetRequiredService<IHmacHashAlgorithm>();
var hmacmd5 = hmacHash.HmacMd5("str");
var hmacsha1 = hmacHash.HmacSha1("str");
......

// Symmetry Algorithm
var sym = serviceProvider.GetRequiredService<ISymmetryAlgorithm>();
var aes = sym.ToAes("str");
// sym.FromAes(aes);
......

// Rsa AsymmetryAlgorithm
var asym = serviceProvider.GetRequiredService<IRsaAsymmetryAlgorithm>();
var rsa = asym.ToRsa("str");
// asym.FromRsa(rsa);

2 Drawing Extension (based SkiaSharp)

Use Extension

// Captcha
var captcha = DateTime.Now.ToString("HHmm");
var drawing = serviceProvider.GetRequiredService<ICaptchaDrawing>();
var savePath = drawing.Paths.AppPath.AppendPath(@"..\..\temp\captcha.png");
// await drawing.DrawFile(captcha, savePath);

// Scale: Single file
var drawing = serviceProvider.GetRequiredService<IScaleDrawing>();
var imagePath = drawing.Paths.AppPath.AppendPath(@"..\..\temp\eso1004a.jpg");
// await drawing.DrawFile(imagePath);
......

// Watermark
var drawing = serviceProvider.GetRequiredService<IWatermarkDrawing>();
var imagePath = drawing.Paths.AppPath.AppendPath(@"..\..\temp\eso1004a.jpg");
var savePath = drawing.Paths.AppPath.AppendPath(@"..\..\temp\eso1004a-watermark.png");
// await drawing.DrawFile(imagePath, savePath);

3 Entity Extension

Install Extensions

PM> Install-Package LibrameStandard.EntityFrameworkCore.MsSqlServer

Configure Extension

......
options.PostConfigureEntity = opts =>
{
    opts.DbSources.Add(new EntityExtensionOptions.DbSourceOptions
    {
        // Register MSSQLServer EntityProvider
        EntityProviderTypeName = typeof(MsSqlServerEntityProvider).AsAssemblyQualifiedNameWithoutVCP(),
        EntityProviderOptionsBuilderFactory = nameof(MsSqlServerEntityProviderOptionsBuilderFactory),

        Connection = new EntityExtensionOptions.ConnectionOptions
        {
            DefaultString = TestHelper.DefaultSqlServerConnectionString,
            
            // If use read/write separation, otherwise, keep empty
            WriteString = TestHelper.DefaultSqlServerWriteConnectionString,
            // Enable or Disable
            WriteSeparation = true
        },

        // Configure SQLServer DbContext contain many references Entities
        // or extract SQLServer DbContext contain many DbSet<Entity> properties
        Automapping = new EntityExtensionOptions.AutomappingOptions
        {
            EntityTypeNames = new List<string>
            {
                typeof(Article).AsAssemblyQualifiedNameWithoutVCP()
            },
            // If ArticleMap in the same assembly (with Article), you can ignore it
            //EntityConfiguratorAssemblies = new List<string>
            //{
                //typeof(Article).AsAssemblyName().Name
            //}
        }
    });
};
......

......
services.AddLibrameStandard(options => {...}, (extensions, options) =>
{
    // Use MSSQLServer (Supported InMemory/MsSqlServer/MySql/Sqlite)
    extensions.AddStandardExtensionsWithEfCore(options).ApplyMsSqlServer();
});
......

Note: Support Databases
Database | EntityProviderTypeName | EntityProviderOptionsBuilderFactory | Assembly | WriteSeparation
- | :-: | :-: | :-: | -: 
MsSqlServer | MsSqlServerEntityProvider| MsSqlServerEntityProviderOptionsBuilderFactory | LibrameStandard.EntityFrameworkCore.MsSqlServer | True 
MySql | DefaultEntityProvider| MySqlEntityProviderOptionsBuilderFactory | LibrameStandard.EntityFrameworkCore.MySql | BUG 
Sqlite | DefaultEntityProvider| SqliteEntityProviderOptionsBuilderFactory | LibrameStandard.EntityFrameworkCore.Sqlite | False 
InMemory | DefaultEntityProvider| InMemoryEntityProviderOptionsBuilderFactory | LibrameStandard.EntityFrameworkCore.InMemory | False