Adding EntityFramework.Extended to the project

Question

I've added EntityFramework.Extended (link) to my project using NuGet. Now I'm facing one single problem; how can I use it's Update function with my dbContext?

Answer 1

Import namespace using EntityFramework.Extensions and use Update (sample from Update method description):

dbContext.Users.Update(
         u => u.Email.EndsWith(emailDomain),
         u => new User { IsApproved = false, LastActivityDate = DateTime.Now });

Answer 2

You specify Where predicate for Update like so:

context.tblToUpdate
       .Update(entry => condition, entryWithnewValues => new tblToUpdate{});

Answer 3

Update with:

YourDbContext context=new YourDbContext();
//update all tasks with status of 1 to status of 2
context.YourModels.Update(
    t => t.StatusId == 1, 
    t2 => new Task {StatusId = 2});

//example of using an IQueryable as the filter for the update
var yourmodel = context.YourModels.Where(u => u.FirstName == "firstname");
context.YourModels.Update(yourmodel , u => new YourModel {FirstName = "newfirstname"});

You should have a class that inherits DbContext and has public DbSets like:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Data.Entity;

namespace YourNamespace.Models
{
    public class YourDBContext: DbContext
    {
         public DbSet<YourModel> YourModels { get; set; }
    }
}

Nothing special is required for using EntityFramework.Extended

Answer 4

The Extensions methods on DbContext are now gone away.

The Extensions methods supported are only on IQueryable