HagionSoft.Tools.NETStandard 1.1.0

List of Tools:

[UpdatableProperty] attribute

To mark a property to be updated using extension method UpdatePropertiesWith

For example:

public class Movie 
{
    [Key]
    public int Id { get; set; }

    [UpdatableProperty]
    public string Title { get; set; }
  
    [UpdatableProperty]
    public string Genre { get; set; }      

    public integer Year { get; set; }
}

We can then update both Title and Genre property while Year property will be ignored with the extension:

var currentMovie = new Movie();
currentMovie.Title = "title 1";
currentMovie.Genre = "genre 1";
currentMovie.Year = 2000;

var updatedMovie = new Movie();
updatedMovie.Title = "updated title";
updatedMovie.Genre = "action";
updatedMovie.Year = 2019;

//Both Title and Genre in currentMovie will be updated
currentMovie.UpdatePropertiesWith(updatedMovie); 

EFSqlBulkCopy

A wrapper for SqlBulkCopy for EntityFramework.

var movies = new List<Movie>
{
    new Movie()
    {
         Id = 1,
         Title = "Movie 1",
         Genre = "action",
         Year = 2018
    },
    new Movie()
    {
         Id = 2,
         Title = "Movie 2",
         Genre = "comedy",
         Year = 2019
    }
}

var efSqlBulkCopy = new EFSqlBulkCopy<Movie>(dbContext);
//This is optional. 
//If not set, it will first search for [Table] attribute and use its value.
//If not set and no [Table] attribute, it will simply use class name as table name.
efSqlBulkCopy.DestinationTableName = "Movie";
efSqlBulkCopy.WriteToServer(movies);