That answer didn’t work for me (in EF 4.1). To make this work, I added DatabaseGenerated attribute to my key column: public class FacebookUser { [Key] [DatabaseGenerated(DatabaseGeneratedOption.None)] public long FacebookId { get; set; } // … } Hope this helps someone.
Have you set Identity StoreGeneratedPattern? You can do it in the OnModelCreating method: modelBuilder.Entity<Foo>().Property(o => o.Id).HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity); or using the DataAnnotation attributes: public class Foo { [DatabaseGenerated(DatabaseGeneratedOption.Identity)] public Guid Id {get;set;} public string Name {get;set;} }
For that you can use the Select method: PersonQuery.Include(x => x.Addresses.Select(a => a.Mailbox)); You can find other examples in here and here.
You must use this: public void Refresh(Document instance) { _ctx.Entry<Document>(instance).Reload(); }
You can specify the column order in the attributes, for instance: public class MyEntity { [Key, Column(Order=0)] public int MyFirstKeyProperty { get; set; } [Key, Column(Order=1)] public int MySecondKeyProperty { get; set; } [Key, Column(Order=2)] public string MyThirdKeyProperty { get; set; } // other properties } If you are using the Find method of a … Read more
You should supply the SqlParameter instances in the following way: context.Database.SqlQuery<myEntityType>( “mySpName @param1, @param2, @param3”, new SqlParameter(“param1”, param1), new SqlParameter(“param2”, param2), new SqlParameter(“param3”, param3) );