Advertisement
magnusbakken

Untitled

Oct 18th, 2017
208
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 1.29 KB | None | 0 0
  1.         public static async Task<int> DeleteAsync<TEntity>(
  2.             public static async Task<int> DeleteAsync<TEntity>(
  3.             this DbContext context,
  4.             Expression<Func<TEntity, bool>> predicate,
  5.             CancellationToken cancellationToken = default(CancellationToken))
  6.             where TEntity : class
  7.         {
  8.             var objectContext = ((IObjectContextAdapter)context).ObjectContext;
  9.             var command = (ObjectQuery)objectContext.CreateObjectSet<TEntity>().Where(predicate).Select(o => new { });
  10.             var querySql = command.ToTraceString();
  11.             var deleteSql = "DELETE [Extent1] " + querySql.Substring(querySql.IndexOf("FROM"));
  12.             var parameters = command.Parameters
  13.                 .Select(parameter => new SqlParameter(parameter.Name, parameter.Value))
  14.                 .Cast<object>();
  15.  
  16.             return await context.Database.ExecuteSqlCommandAsync(deleteSql, cancellationToken, parameters);
  17.         }
  18.  
  19.         public static Task<int> DeleteAsync<TEntity, TKey>(
  20.             this DbContext context,
  21.             IEnumerable<TKey> ids,
  22.             Expression<Func<TEntity, TKey>> idSelector,
  23.             CancellationToken cancellationToken = default(CancellationToken))
  24.             where TEntity : class
  25.         {
  26.         }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement