Tanneryd.BulkOperations.EF6 1.2.3

This extension provides bulk insert, bulk update and bulk select. Bulk insert supports complete entity hierarchies, maintaining foreign key relationsships.

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

Tanneryd.BulkOperations.EF6

A nuget package that extends the DbContext in EF6 with bulk operations for both inserts and updates.

Getting Started

Background

Read the CodeProject article Bulk operations using Entity Framework if you are interested in some background.

Prerequisites

The extension is built for, and requires, Entity Framework 6 and .NET 4.5 or later.

Installing

Install the nuget package Tanneryd.BulkOperations.EF6. This will make the following methods available on the DbContext.

API

Insert
public class BulkInsertRequest<T>
{
    public IList<T> Entities { get; set; }
    public SqlTransaction Transaction { get; set; }
    public bool UpdateStatistics { get; set; } = false;
    public bool Recursive { get; set; } = false;
    public bool AllowNotNullSelfReferences { get; set; } = false;
    public bool SortUsingClusteredIndex { get; set; } = true;
}
  • When UpdateStatistics is set the command "UPDATE STATISTICS <tablename> WITH ALL" will be executed after the insert.
  • When Recursive is set to true the entire entity hierarchy will be inserted.
  • When AllowNotNullSelfReferences is set to true, entities with self referencing foreign keys declared as NOT NULL will be properly inserted. But, this will only work if the database user has the required privileges to execute ALTER TABLE <table name> NOCHECK CONSTRAINT ALL and ALTER TABLE <table name> CHECK CONSTRAINT ALL.
  • When SortUsingClusteredIndex is set to true the entities will be sorted according to the clustered index of the target table.
 public static BulkOperationResponse BulkInsertAll<T>(
     this DbContext ctx,
     BulkInsertRequest<T> request)
Update
public class BulkUpdateRequest
{
    public IList Entities { get; set; }
    public string[] UpdatedColumnNames { get; set; }
    public string[] KeyMemberNames { get; set; }
    public SqlTransaction Transaction { get; set; }
    public bool InsertIfNew { get; set; }
}
  • If UpdatedColumnNames is an empty list all non-key mapped columns will be updated, otherwise only the columns specified.
  • If KeyMemberNames is an empty list the primary key columns will be used to select which rows to update, otherwise the columns specified will be used.
 public static BulkOperationResponse BulkUpdateAll(
     this DbContext ctx,
     BulkUpdateRequest request)
Select
Select
SelectExisting

The select-existing feature provides a way to identify the subset of existing or non-existing items in a local collection where an item is considered as existing if it is equal to an entity saved in the database according to a set of defined key properties. This provides a very efficient way of figuring out which items in your local collection needs to be inserted and which to be updated. The item collection can be of the same type as the EF entity but it does not have to be.

public class BulkSelectRequest<T>
{
	public BulkSelectRequest(string[] keyPropertyNames, 
				 IList<T> items = null,
				 SqlTransaction transaction = null)
	{
        KeyPropertyMappings = keyPropertyNames.Select(n => new KeyPropertyMapping
            {
                ItemPropertyName = n,
                EntityPropertyName = n
            })
            .ToArray();
        Items = items;
        Transaction = transaction;
    }
    public IList<T> Items { get; set; }
    public KeyPropertyMapping[] KeyPropertyMappings { get; set; }
    public SqlTransaction Transaction { get; set; }
   

    public BulkSelectRequest()
    {
        KeyPropertyMappings = new KeyPropertyMapping[0];
        Items = new T[0];
    }
}

public class KeyPropertyMapping
{
    public string ItemPropertyName { get; set; }
    public string EntityPropertyName { get; set; }

    public static KeyPropertyMapping[] IdentityMappings(string[] names)
    {
        return names.Select(n => new KeyPropertyMapping
        {
            ItemPropertyName = n,
            EntityPropertyName = n
        }).ToArray();
    }
}
/// <summary>
/// Given a set of entities we return the subset of these entities
/// that already exist in the database, according to the key selector
/// used.
/// </summary>
/// <typeparam name="T1">The item collection type</typeparam>
/// <typeparam name="T2">The EF entity type</typeparam>
/// <param name="ctx"></param>
/// <param name="request"></param>
public static IList<T1> BulkSelectExisting<T1,T2>(
    this DbContext ctx,
    BulkSelectRequest<T1> request)
{
    return DoBulkSelectExisting<T1, T2>(ctx, request);
}

Release history

1.2.3 (2019-03-29)
  • Bugfix: Join tables with Guid keys misbehaved.
  • Added method BulkDeleteNotExisting
1.2.2 (2018-12-01)
  • Bugfix: BulkSelect did not work properly with null columns.
  • Bugfix: Contexts using lazy loading and thus dynamic proxies did not work as expected.
  • Bugfix: Tables with Guid primary keys did not work as expected in some situations.

Built With

  • Visual Studio 2017
  • .NET Framework 4.5
  • Entity Framework 6.2.0

Versioning

We use SemVer for versioning. For the versions available, see the tags on this repository.

Authors

  • Måns Tånneryd

License

This project is licensed under the Apache License - see the LICENSE.md file for details.

Tanneryd.BulkOperations.EF6

A nuget package that extends the DbContext in EF6 with bulk operations for both inserts and updates.

Getting Started

Background

Read the CodeProject article Bulk operations using Entity Framework if you are interested in some background.

Prerequisites

The extension is built for, and requires, Entity Framework 6 and .NET 4.5 or later.

Installing

Install the nuget package Tanneryd.BulkOperations.EF6. This will make the following methods available on the DbContext.

API

Insert
public class BulkInsertRequest<T>
{
    public IList<T> Entities { get; set; }
    public SqlTransaction Transaction { get; set; }
    public bool UpdateStatistics { get; set; } = false;
    public bool Recursive { get; set; } = false;
    public bool AllowNotNullSelfReferences { get; set; } = false;
    public bool SortUsingClusteredIndex { get; set; } = true;
}
  • When UpdateStatistics is set the command "UPDATE STATISTICS <tablename> WITH ALL" will be executed after the insert.
  • When Recursive is set to true the entire entity hierarchy will be inserted.
  • When AllowNotNullSelfReferences is set to true, entities with self referencing foreign keys declared as NOT NULL will be properly inserted. But, this will only work if the database user has the required privileges to execute ALTER TABLE <table name> NOCHECK CONSTRAINT ALL and ALTER TABLE <table name> CHECK CONSTRAINT ALL.
  • When SortUsingClusteredIndex is set to true the entities will be sorted according to the clustered index of the target table.
 public static BulkOperationResponse BulkInsertAll<T>(
     this DbContext ctx,
     BulkInsertRequest<T> request)
Update
public class BulkUpdateRequest
{
    public IList Entities { get; set; }
    public string[] UpdatedColumnNames { get; set; }
    public string[] KeyMemberNames { get; set; }
    public SqlTransaction Transaction { get; set; }
    public bool InsertIfNew { get; set; }
}
  • If UpdatedColumnNames is an empty list all non-key mapped columns will be updated, otherwise only the columns specified.
  • If KeyMemberNames is an empty list the primary key columns will be used to select which rows to update, otherwise the columns specified will be used.
 public static BulkOperationResponse BulkUpdateAll(
     this DbContext ctx,
     BulkUpdateRequest request)
Select
Select
SelectExisting

The select-existing feature provides a way to identify the subset of existing or non-existing items in a local collection where an item is considered as existing if it is equal to an entity saved in the database according to a set of defined key properties. This provides a very efficient way of figuring out which items in your local collection needs to be inserted and which to be updated. The item collection can be of the same type as the EF entity but it does not have to be.

public class BulkSelectRequest<T>
{
	public BulkSelectRequest(string[] keyPropertyNames, 
				 IList<T> items = null,
				 SqlTransaction transaction = null)
	{
        KeyPropertyMappings = keyPropertyNames.Select(n => new KeyPropertyMapping
            {
                ItemPropertyName = n,
                EntityPropertyName = n
            })
            .ToArray();
        Items = items;
        Transaction = transaction;
    }
    public IList<T> Items { get; set; }
    public KeyPropertyMapping[] KeyPropertyMappings { get; set; }
    public SqlTransaction Transaction { get; set; }
   

    public BulkSelectRequest()
    {
        KeyPropertyMappings = new KeyPropertyMapping[0];
        Items = new T[0];
    }
}

public class KeyPropertyMapping
{
    public string ItemPropertyName { get; set; }
    public string EntityPropertyName { get; set; }

    public static KeyPropertyMapping[] IdentityMappings(string[] names)
    {
        return names.Select(n => new KeyPropertyMapping
        {
            ItemPropertyName = n,
            EntityPropertyName = n
        }).ToArray();
    }
}
/// <summary>
/// Given a set of entities we return the subset of these entities
/// that already exist in the database, according to the key selector
/// used.
/// </summary>
/// <typeparam name="T1">The item collection type</typeparam>
/// <typeparam name="T2">The EF entity type</typeparam>
/// <param name="ctx"></param>
/// <param name="request"></param>
public static IList<T1> BulkSelectExisting<T1,T2>(
    this DbContext ctx,
    BulkSelectRequest<T1> request)
{
    return DoBulkSelectExisting<T1, T2>(ctx, request);
}

Release history

1.2.3 (2019-03-29)
  • Bugfix: Join tables with Guid keys misbehaved.
  • Added method BulkDeleteNotExisting
1.2.2 (2018-12-01)
  • Bugfix: BulkSelect did not work properly with null columns.
  • Bugfix: Contexts using lazy loading and thus dynamic proxies did not work as expected.
  • Bugfix: Tables with Guid primary keys did not work as expected in some situations.

Built With

  • Visual Studio 2017
  • .NET Framework 4.5
  • Entity Framework 6.2.0

Versioning

We use SemVer for versioning. For the versions available, see the tags on this repository.

Authors

  • Måns Tånneryd

License

This project is licensed under the Apache License - see the LICENSE.md file for details.

Release Notes

Bugfixes: Join tables with Guid keys misbehaved.

Version History

Version Downloads Last updated
1.2.3 432 3/29/2019
1.2.3-beta6 305 2/12/2019
1.2.3-beta5 54 2/10/2019
1.2.3-beta4 55 2/9/2019
1.2.3-beta3 66 2/2/2019
1.2.3-beta2 98 1/16/2019
1.2.3-beta1 80 1/13/2019
1.2.2 3,269 12/1/2018
1.2.1 1,920 9/24/2018
1.2.1-rc2 92 9/17/2018
1.2.1-rc1 93 9/12/2018
1.2.0 282 9/5/2018
1.2.0-rc2 124 8/24/2018
1.2.0-rc1 119 8/16/2018
1.2.0-beta5 411 7/11/2018
1.2.0-beta4 152 6/12/2018
1.2.0-beta3 189 5/12/2018
1.2.0-beta2 222 5/2/2018
1.2.0-beta1 152 4/23/2018
1.1.0 3,651 4/20/2018
1.1.0-beta7 153 4/18/2018
1.1.0-beta6 166 4/16/2018
1.1.0-beta5 276 4/13/2018
1.1.0-beta4 169 4/13/2018
1.1.0-beta 210 4/12/2018