Notes it:ad:code_first

IT:AD:Code First:CodeMigration

Anonymous (anonymous@undisclosed.example.com) — 2023-11-04T03:22:11+00:00

IT:AD:Code First:CodeMigration * (UP) code_first index "Note: An interesting thing to note is that this is the first time I've noticed MS using the Package Manager Console for far more that Packaging. They're using it as a completely new way to script up VS operations. Worth Keeping an eye on future developments in this direction.

IT:AD:Code First:DataAnnotations

Anonymous (anonymous@undisclosed.example.com) — 2023-11-04T03:22:12+00:00

IT:AD:Code First:DataAnnotations * (UP) code_first index Summary "Important: the use of `DataAnnotations` is not recommended in anything but a POC. * Domain Entities should be in their own assembly. * Decorating domain with Attributes drag in -- and therefore to all assemblies referring to domain entities (ie everywhere)

IT:AD:Code First:Initialization

Anonymous (anonymous@undisclosed.example.com) — 2023-11-04T03:22:13+00:00

IT:AD:Code First:Initialization * (UP) code_first index Notes IDatabaseInitializer * When the db is first created, it creates a Db table called EdmMetadata. * Schema is simple: [Id | ModelHash], with a clustered index on Id. That appears to be it. * Changes to the entity schema will cause:

IT:AD:Code First:Seeding

Anonymous (anonymous@undisclosed.example.com) — 2023-11-04T22:22:15+00:00

IT:AD:Code First:Seeding * (UP) code_first index Define the Database Initializer Somewhere early, define this: Database.SetInitializer(new MyInitializer()); This will be a custom implementation of IDatabaseInitializer that enherits from a well-known strategy: //Invoke *early*, eg from a Boottrapper: //Database.SetInitializer(new GraphInitializer()); public class MyInitializer : DropCreateDatabaseIfModelChanges { ... protected override void Seed(GraphContext …

IT:AD:Code First:DbContext

Anonymous (anonymous@undisclosed.example.com) — 2023-11-04T03:22:12+00:00

IT:AD:Code First:DbContext * (UP) code_first index An EF DbContext is an “occasionally-connected”, “in-memory” representation of the remote database. In other words, in its simplest form, a DbContext is rather like a DataSet of the whole database, keeping track of changes made to its in-mem tables, and only committing those changes back to the database when the

IT:AD:Code First:Deployment

Anonymous (anonymous@undisclosed.example.com) — 2023-11-04T03:22:13+00:00

IT:AD:Code First:Deployment * (UP) code_first index Deployment Warning: Code first has no change tracking story. The process to follow is: * Read this -- might be useful: * For the future: * See 'Code First Migrations' () Db Initialization Excellent in depth analysis of the steps happening under the covers: *

IT:AD:EF/CodeFirst/Entities

Anonymous (anonymous@undisclosed.example.com) — 2023-11-04T03:22:15+00:00

IT:AD:EF/CodeFirst/Entities * (UP) code_first index CheckList * MSDN:Conventions * MSDN:Code First Data Annotations * (v=vs.103).aspx * Important: For Automapper to populate Navigation properties, etc. the properties must have a set. They can be protected, or private (Automapper can handle that, but they have to be there.

IT:AD:Code First:FAQs

Anonymous (anonymous@undisclosed.example.com) — 2023-11-04T03:22:16+00:00

IT:AD:Code First:FAQs * (UP) code_first index Questions * What's marking a property virtual do? * That makes Scalar properties * Makes Collection Navigation Properties lazy-loadable. * Is FK detection (for relationships) case sensitive? * No.

IT:AD:Code First:FluentAPI

Anonymous (anonymous@undisclosed.example.com) — 2023-11-04T22:22:16+00:00

IT:AD:Code First:FluentAPI * (UP) code_first index Example: public class OurDbContext : DbContext { protected override void OnModelCreating(ModelBuilder modelBuilder) { modelBuilder.Entity().Property(dp => dp.Name).IsRequired(); modelBuilder.Entity().HasKey(ma => ma.ManagerCode); modelBuilder.Entity().Property(ma => ma.Name) .IsConcurrencyToken(true) .IsVariableLength() .HasMaxLength(20); } }

IT:AD:Code First:Glossary

Anonymous (anonymous@undisclosed.example.com) — 2023-11-04T22:22:16+00:00

IT:AD:Code First:Glossary * (UP) code_first index * Navigation Property: provides a way to navigate a relationship to either: * Reference Object (if multiplicity is: 1 or 0-1) * Collection (if multiplicity: 0-n)

IT:AD:Code First

Anonymous (anonymous@undisclosed.example.com) — 2023-11-04T03:22:17+00:00

IT:AD:Code First * (UP) code_first index IT:AD:Code First:FAQs * IT:AD:Code First:Glossary * * IT:AD:Code First:HowTo * See also: * IT:AD:LiquidBase ... Errata * ACiD * Advantages: * The most DDD of all options (more so than IT:AD:EF:DatabaseFirst, ). * Considerations: * Can begin work with Entities before a Db even exists. * Deployment is a different story.

it:ad:code_first:issues

Anonymous (anonymous@undisclosed.example.com) — 2023-11-04T22:22:17+00:00

Error message: modelBuilder.Entity() .HasOptional(m=>m.WorkflowStep) .WithMany() .HasForeignKey(m=>m.WorkflowStepFK); //IsRequired public virtual int WorkflowStepFK { get; set; } public virtual WorkflowStep WorkflowStep { get; set; } \tSystem.Data.Entity.Edm.EdmAssociationType: : Multiplicity conflicts with the referential constraint in Role 'RoutingRule_WorkflowStep_Targe…

IT:AD:Code First:Migrations

Anonymous (anonymous@undisclosed.example.com) — 2023-11-04T03:22:19+00:00

IT:AD:Code First:Migrations * (UP) code_first index "Note: An interesting thing to note is that this is the first time I've noticed MS using the Package Manager Console for far more that Packaging. They're using it as a completely new way to script up VS operations. Worth Keeping an eye on future developments in this direction.

IT:AD:Code First:Querying

Anonymous (anonymous@undisclosed.example.com) — 2023-11-04T03:22:20+00:00

IT:AD:Code First:Querying * (UP) * See also: * IT:AD:EF:Querying * WARNING: Stored procs are not officially supported in EF5 -- they are on the roadmap for [EF6]{} Process Using EF5: * The basics are: * http://stackoverflow.com/questions/4845246/does-entity-framework-code-first-support-stored-procedures * http://blogs.msdn.com/b/wriju/archive/2011/05/14/code-first-4-1-using-stored-procedure-…

IT:AD:Code First

Anonymous (anonymous@undisclosed.example.com) — 2023-11-04T03:22:20+00:00

IT:AD:Code First * (UP) code_first index ---------- Example public class EFRepository : IGraphRepository> { private readonly GraphContext _graphContext = new GraphContext(); public void Persist(params GraphVertex[] vertices) { foreach(GraphVertex vertex in vertices) { bool isDetached = ((int)_graphContext.Entry(vertex).State).BitIsSet((int)EntityState.Modified); if (v…