This is exception caused by SQL server when you have multiple paths of cascade deletes. If you delete your PaymentTerm it will trigger cascade delete on all three relations. This will blow up when creating either SalesOrder or Invoice. EF creates by default all one-to-many relations with ON DELETE CASCADE you can remap your specific … Read more
These answers are good and do work, however I have always felt using Empty and not creating a new List is cleaner: Enumerable.Empty<Thing>().AsQueryable();
As others have pointed out you need two properties, but you may be interested to know that you can make one of the properties private and still map it to the database: private string isActive { get; set; } [System.ComponentModel.DataAnnotations.Schema.NotMapped] public bool IsActive { get { return isActive == “Y”; } set { isActive = … Read more
I was just thinking about what find actually does. @lazyberezovsky is right include and find cant be used in conjunction with each other. I think this is quite deliberate and here’s why: The Find method on DbSet uses the primary key value to attempt to find an entity tracked by the context. If the entity … Read more
Very, very rough idea: foreach (var property in dbEntityEntry.Entity.GetType().GetProperties()) { DbPropertyEntry propertyEntry = dbEntityEntry.Property(property.Name); if (propertyEntry.IsModified) { Log.WriteAudit(“Entry: {0} Original :{1} New: {2}”, property.Name, propertyEntry.OriginalValue, propertyEntry.CurrentValue); } } I have no clue if this would really work in detail, but this is something I would try as a first step. Of course there could be … Read more
The problem with your connection string here is: <add name=”TrempimModel” connectionString=”data source=.\SQLEXPRESS;Integrated Security=SSPI; AttachDBFilename=|DataDirectory|aspnetdb.sdf; User Instance=true” providerName=”System.Data.SqlClient” /> You’re basically defining what “server” you’re connecting to – but you’re not saying what database inside the file to connect to. Also – the file extension for SQL Server Express database files is .mdf (not .sdf – … Read more
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 … Read more
This is currently supported on Mac. First you need to install dotnet-ef dotnet tool install –global dotnet-ef To install a specific version of the tool, use the following command: dotnet tool install –global dotnet-ef –version 3.1.4 Add the “dotnet-ef” tools directory on the PATH environment variable. export PATH=”$PATH:/Users/’your user folder’/.dotnet/tools” Open a command line, go … Read more
Let’s assume that you have a collection of the properties to be excluded: var excluded = new[] { “property1”, “property2” }; With EF5 on .NET 4.5 you can do this: var entry = context.Entry(obj); entry.State = EntityState.Modified; foreach (var name in excluded) { entry.Property(name).IsModified = false; } This uses a new feature of EF5 on … Read more
This is now possible in EF Core 5.0 using the ExcludeFromMigrations() method, but strangely enough you have to call the ToTable() method and then use the TableBuilder. Announcing Entity Framework Core (EFCore) 5.0 RC1 public class ReportingContext : DbContext { public DbSet<User> Users { get; set; } protected override void OnModelCreating(ModelBuilder modelBuilder) { modelBuilder.Entity<User>().ToTable(nameof(Users), t … Read more