Why can’t Entity Framework see my Stored Procedure’s column information?
Try adding this line to the beginning of your stored procedure: SET FMTONLY OFF You can remove this after you have finished importing.
entity-framework-4
EF Mapping and metadata information could not be found for EntityType Error
For anyone else dealing with the error, I think it’s worth mentioning some scenarios that I’ve found that cause this (extremely unhelpful) error: Misspelled properties (case-sensitive!) Properties missing in the POCO class Type mismatches between the POCO and entity-type (e.g., int instead of long) Enums in the POCO (EF doesn’t support enums right now as …
using Guid as PK with EF4 Code First
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;} }
adding List of objects to Context in ef
From EntityFramework 6 you can use DbSet.AddRange Method (IEnumerable) like this db.companies.AddRange(newCompanies);
Possible to default DateTime field to GETDATE() with Entity Framework Migrations?
You can use DateCreated = c.DateTime(nullable: false, defaultValueSql: “GETDATE()”) Usage: public partial class MyMigration : DbMigration { public override void Up() { CreateTable(“dbo.Users”, c => new { Created = c.DateTime(nullable: false, defaultValueSql: “GETDATE()”), }) .PrimaryKey(t => t.ID); … Update 2012-10-10: As requested by Thiago in his comment, I add a little extra context. The code …
SQL ‘time’ type in Entity Framework Code First
If you want to use Time type in database you will have to use TimeSpan with 24 hour cycle in your application. DateTime is not representation of time.
Asp.Net Web API Error: The ‘ObjectContent`1’ type failed to serialize the response body for content type ‘application/xml; charset=utf-8’
I would suggest Disable Proxy Creation only in the place where you don’t need or is causing you trouble. You don’t have to disable it globally you can just disable the current DB context via code… [HttpGet] [WithDbContextApi] public HttpResponseMessage Get(int take = 10, int skip = 0) { CurrentDbContext.Configuration.ProxyCreationEnabled = false; var lista = …
Add the where clause dynamically in Entity Framework
You can use a beautiful thing called PredicateBuilder. Use it like this var pr = PredicateBuilder.False<User>(); foreach (var name in names) { pr = pr.Or(x => x.Name == name && x.Username == name); } return query.AsExpandable().Where(pr);
Entity Framework/SQL2008 – How to Automatically Update LastModified fields for Entities?
I know I’m a little late to the party, but I just solved this for a project I’m working on and thought I’d share my solution. First, to make the solution more re-usable, I created a base class with the timestamp properties: public class EntityBase { public DateTime? CreatedDate { get; set; } public DateTime? …
Refresh entity instance with DbContext
You must use this: public void Refresh(Document instance) { _ctx.Entry<Document>(instance).Reload(); }