Yozian.EFCorePlus 1.1.0

partial updated and scheam description scripts generation

Install-Package Yozian.EFCorePlus -Version 1.1.0
dotnet add package Yozian.EFCorePlus --version 1.1.0
<PackageReference Include="Yozian.EFCorePlus" Version="1.1.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add Yozian.EFCorePlus --version 1.1.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

Features

  • Update entity without fetch and can specify columns to be updated.
  • Provide schema description & extension method to generate update scheam desciription sql scripts

Partial field update example


    var book = new Book()
            {
                Id = 1 // it should exits Id = 1 in the database
            };

    book.Name = "The Phoenix Project";
    book.Author = "fake-yozian";

    dbContext.Update(
        book,
        x => x.Name
        );

    // when the SaveChanges called, only the [Name] column will be updated.
    dbContext.SaveChanges();

Generate Schema description, Extension method of IModel


        // it's recommanded doing after migration or data seed.

        var schemaDescriptionScripts = dbContext
            .Model
            .GenerateInsertOrUpdateDescriptionScripts(SqlType.SqlServer);
        
        // if the command won't exceed the maximun query line limits, you could join the scritps and execute once.
        schemaDescriptionScripts.ForEach(script =>
        {
            // excute command to database
            dbContext.Database.ExecuteCommand(script);

        });


feel free for pull request

Features

  • Update entity without fetch and can specify columns to be updated.
  • Provide schema description & extension method to generate update scheam desciription sql scripts

Partial field update example


    var book = new Book()
            {
                Id = 1 // it should exits Id = 1 in the database
            };

    book.Name = "The Phoenix Project";
    book.Author = "fake-yozian";

    dbContext.Update(
        book,
        x => x.Name
        );

    // when the SaveChanges called, only the [Name] column will be updated.
    dbContext.SaveChanges();

Generate Schema description, Extension method of IModel


        // it's recommanded doing after migration or data seed.

        var schemaDescriptionScripts = dbContext
            .Model
            .GenerateInsertOrUpdateDescriptionScripts(SqlType.SqlServer);
        
        // if the command won't exceed the maximun query line limits, you could join the scritps and execute once.
        schemaDescriptionScripts.ForEach(script =>
        {
            // excute command to database
            dbContext.Database.ExecuteCommand(script);

        });


feel free for pull request

This package is not used by any popular GitHub repositories.

Version History

Version Downloads Last updated
1.1.0 194 1/15/2019