What you are looking for can be achieved by setting up an optional association between Guest and Language entities: protected override void OnModelCreating(ModelBuilder modelBuilder) { modelBuilder.Entity<Guest>() .HasOptional(p => p.PreferredLanguage) .WithMany() .HasForeignKey(p => p.LanguageID); } Unit Test: using (var context = new Context()) { var language = new Language() { LanguageName = “en” }; var guest … Read more
I’ve struggled with this for almost the entire day and of course I wait to ask here just before finally figuring it out! In addition to implementing the One to One as demonstrated in that blog, I also then needed to use the fluent api in order to specify the Many to Many since the … Read more
This is now fully supported, check out the latest source or grab the package from nuget. You will need the MiniProfiler.EF package if you are using nuget. (1.9.1 and up) Supporting this involved a large set of modifications to the underlying proxy object to support acting as EF code first proxies. To add this support: … Read more
You should supply the SqlParameter instances in the following way: context.Database.SqlQuery<myEntityType>( “mySpName @param1, @param2, @param3”, new SqlParameter(“param1”, param1), new SqlParameter(“param2”, param2), new SqlParameter(“param3”, param3) );