You cannot achieve it directly because neither eager or lazy loading in EF supports ordering or filtering. Your options are: Sort data in your application after you load them from database Execute separate query to load child records. Once you use separate query you can use OrderBy The second option can be used with explicit … Read more
This is too long question. You should break your problem into multiple separate questions next time. Code-first x Model-first x Database-first You are a database guy so the best approach for you is an incremental database-first approach where you define the stuff in DB (or VS Database tools) and update your model from the database. … Read more
You must use this: public void Refresh(Document instance) { _ctx.Entry<Document>(instance).Reload(); }
By changing pocos to: public class Order { public int OrderId { get; set; } public virtual Quotation Quotation { get; set; } } public class Quotation { public int QuotationId { get; set; } public virtual Order Order { get; set; } } and using these mapping files: public class OrderMap : EntityTypeConfiguration<Order> { … Read more
As per my previous question on how to store TimeSpan in SQL I was advised to store it as seconds or ticks etc. In the end I didn’t map the TimeSpan column as there is no equivalent in SQL server. I simply created a 2nd field which converted the TimeSpan to ticks and stored that … Read more
I believe you just have to do modelBuilder.Entity<Dinner>().Property(x => x.HostedBy).HasColumnName(“colHost”); for all of your columns that you want the db column names to be named differently than their property names. Edit: After some more searching I came across this question. Judging from that and the error you posted, it seems like the mc.Properties() is more … Read more
If you’re using Code First and have (an) existing Migration script(s) and are trying to overwrite a change (i.e. renaming a column) that has since been deleted, then you’ll get that error output. Simplest way is to delete the migration script, Add-Migration via NuGet, and then update the database.
UPDATE I’ve added support for this on Nuget Package – https://github.com/Fodsuk/EntityFrameworkExtras#nuget (EF4,EF5,EF6) Check out the GitHub repository for code examples. Slightly off question, but none the less useful for people trying to pass user-defined tables into a stored procedure. After playing around with Nick’s example and other Stackoverflow posts, I came up with this: class … Read more
Just create your new table as a model and add its entry in DbContext class something like public class TestingContext : DbContext, IDisposable { public DbSet<CallDataRecord> CallDataRecords { get; set; } public DbSet<Attempt> Attempts { get; set; } public DbSet<MyNewModel> MyNewModels { get; set; } Then add-migration and update-database
The fact that the Seed method ran only when the database changed was quite limiting for the database initializers that shipped in EF 4.1. It was limiting because sometimes you needed to update seed data without changing the database, but to make that happen you had to artificially make it seem like the database had … Read more