Oh wow, nevermind. I’m dumb. In the Nuget package manager console there is a dropdown menu at the top labeled “Default Project:”. Make sure you set that to the project you want to run the command against. Hopefully this helps someone else avoid my embarrassing mistake.
We changed our code from: dbMgConfig.AutomaticMigrationDataLossAllowed = false; var mg = new DbMigrator(dbMgConfig); mg.Update(null); to dbMgConfig.AutomaticMigrationDataLossAllowed = true; var mg = new DbMigrator(dbMgConfig); var scriptor = new MigratorScriptingDecorator(mg); string script = scriptor.ScriptUpdate(sourceMigration: null, targetMigration: null); throw new Exception(script); so that we could observe what changes DbMigrator is attempting on the remote server. In the case … Read more
On the package manager console type: Get-Help Update-Database Relevant part: Update-Database [-SourceMigration <String>] [-TargetMigration <String>] [-Script] [-Force] [-ProjectName <String>] [-StartUpProjectName <String>] [-ConfigurationTypeName <String>] [-ConnectionStringName <String>] [<Com monParameters>] So you can do a Update-Database -ConnectionStringName “MyConnectionString” and it should work like a charm. You also have a MigrateDatabaseToLatestVersion database initializer, if you set it (via Database.SetInitializer()), … Read more
I believe you should be able to do this: HasRequired(t => t.Agent).WithMany().HasForeignKey(t => t.AgentId)
You create custom initializer, which inherits from DropCreateDatabaseIfModelChanges or DropCreateDatabaseAlways interface. Like: public class EntitiesContextInitializer : DropCreateDatabaseIfModelChanges<-YourDbContext-> And then you overwrite Seed method like: protected override void Seed(YourDbContext context) Whole example might look like: public class EntitiesContextInitializer : DropCreateDatabaseIfModelChanges<EntitiesContext> { protected override void Seed(EntitiesContext context) { List<Role> roles = new List<Role> { new Role {Id=1, … Read more
Would something like this linq query work for you.. ? var matches = from m in db.Customers where m.Name.Contains(key) select m; this should also work I edited my answer. Contains is mapped to LIKE ‘%@p0%’ which is case insensitive
You should be able to call Debugger.Launch() in your code. The just-in-time debugger should prompt you to attach a debugger when it hits that line.
There is a conflict between your foreign key property in class Dettaglio… public virtual int IDTEST { get; set; } …which has a non-nullable type (int) and therefore cannot be optional and your mapping… this.HasOptional(t => t.TEST_TABLE) //… …where you want the relationship to be optional. If you indeed want an optional relationship use a … Read more
You can annotate that property with DatabaseGenerated(DatabaseGeneratedOption.Identity). EF allows only single identity column per table. public class Foo { [Key] public Guid Id { get; set; } [DatabaseGenerated(DatabaseGeneratedOption.Identity)] public long Bar { get; set; } }
If you don’t want to use fluent syntax, there are three other ways of implementing the reference using data annotations (Personally I prefer data annotations as they seem easier to read and are written just above the property they are affecting): 1.1) Use ForeignKey (with an associated property) – version 1 [Table(“WIDGETENTITIES”)] public class WidgetEntity … Read more