I would think that your easiest method, would be to change the definition of your EntitySet in your StorageModel to tell it to regard it as a table, as opposed to a database-view. Looking at the XML definition, where it says <EntitySet Name=”Products” store:Type=”Views” .. you change that to <EntitySet Name=”Products” store:Type=”Tables” .. (Note the … Read more
What was causing the problem? Enumerables! Take a look at the EDIT section in my question for the solution. EDIT: posting the updated code here as answer. The problem was in the way I used enumerables. Bottom line is you should never trust lazy loading when you need consistent results right away. public class Request … Read more
If this error is appearing in an IIS app such as ASP.NET, then there is a high probability that you are missing a binding redirect in the web.config. When you install from Nuget, you should see a binding redirect in the web.config. If you deploy the application to another machine but fail to set up … Read more
I’ve also gotten this problem in my EF one-many deals where the one has a List of the many property and my mapping didn’t specify that property. For example take: public class Notification { public long ID { get; set; } public IList<NotificationRecipient> Recipients { get; set; } } then public class NotificationRecipient { public … Read more
Entity Framework has no support for triggers, although you can certainly manually execute a statement that would create a trigger, but you would need to do this after the table was created (if using migrations). You can use the technique specified by Ladislav in EF 4.1 code-first adding a trigger to a table Take note … Read more
This is the proper way of creating a PK without Identity Autoincrement enabled: [Key] [DatabaseGenerated(DatabaseGeneratedOption.None)] public string FooId { get; set; }
As noted in the comments, add using System.Data.Entity (under the Entity Framework package) to get the QueryableExtensions. For .NET Core, these methods are under Microsoft.EntityFrameworkCore
No, you can’t get a IQueryable from SqlQuery*, this is because what IQueryable is doing is building a SQL string dynamically based on what select and where filters you put in. Because in SqlQuery you are providing the string Entity Framework can not generate that dynamic string. Your options are either dynamically build the string … Read more
It’s not important that how many DbContexts you have(In entity framework 6). Just put connection strings in appConfig or webConfig of startup project. Then you’re ready to go. Example of appConfig with two connectionString with Ef 6.01 & Sql Compact 4.0 <configSections> <section name=”entityFramework” type=”System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089″ requirePermission=”false” /> </configSections> <connectionStrings> <add name=”MainDb” … Read more
Now with pictures (as it took me about an hour of trial and fail) Get DotPeek from Jetbrains (Standalone version) Open DotPeek -> File -> Open -> browse to your project bin folder and open EntityFramework.dll Right mouse button on EntityFramework then choose Generate Pdb… Go to folder where you exported it and open EntityFramework.pdb … Read more