In entity framework 6.0, the Database class has a property Action<string> Log. so setting up logging is as easy as: context.Database.Log = Console.WriteLine; For more advanced needs you can set up an interceptor.
I managed to solve it by creating a FakeDbSet<T> class that implements IDbSet<T> public class FakeDbSet<T> : IDbSet<T> where T : class { ObservableCollection<T> _data; IQueryable _query; public FakeDbSet() { _data = new ObservableCollection<T>(); _query = _data.AsQueryable(); } public virtual T Find(params object[] keyValues) { throw new NotImplementedException(“Derive from FakeDbSet<T> and override Find”); } public … Read more
I was able to resolve this by adding the class generic type constraint to the extension method. I’m not sure why it works, though. public static T GetById<T>(this IQueryable<T> collection, Guid id) where T : class, IEntity { //… }
Please try this to refresh a single entity: Context.Entry<T>(entity).Reload() Edit: To get fresh data for a collection of entities is worth trying to dispose the DbContext instance after each request.
You have to ensure that Start is greater than or equal to SqlDateTime.MinValue (January 1, 1753) – by default Start equals DateTime.MinValue (January 1, 0001).
Put this in your custom DbContext class: protected override void OnModelCreating(DbModelBuilder modelBuilder) { modelBuilder.Entity<Estate>().ToTable(“Estate”); } If your tables are not created on startup, this is why. You need to tell the DbContext about them in the OnModelCreating method override. You can either do custom per-entity mappings here, or separate them out into separate EntityTypeConfiguration<T> classes.
Ladislav’s answer updated to use DbContext (introduced in EF 4.1): public void ChangePassword(int userId, string password) { var user = new User() { Id = userId, Password = password }; using (var db = new MyEfContextName()) { db.Users.Attach(user); db.Entry(user).Property(x => x.Password).IsModified = true; db.SaveChanges(); } }
You can have multiple contexts for single database. It can be useful for example if your database contains multiple database schemas and you want to handle each of them as separate self contained area. The problem is when you want to use code first to create your database – only single context in your application … Read more
NOTE: This answer talks about the Entity Framework’s DbContext, but it is applicable to any sort of Unit of Work implementation, such as LINQ to SQL’s DataContext, and NHibernate’s ISession. Let start by echoing Ian: Having a single DbContext for the whole application is a Bad Idea. The only situation where this makes sense is … Read more