https://skysigal.com/ 2026-04-16T22:12:31+00:00 https://skysigal.com/ https://skysigal.com/lib/tpl/bootstrap3/images/favicon.ico text/html 2023-11-04T03:39:11+00:00 Anonymous (anonymous@undisclosed.example.com) https://skysigal.com/it/ad/code_first/entities/autogeneration?rev=1699069151&do=diff IT:AD:EF/CodeFirst/Entities/AutoGeneration * (UP) entities index Proccess * Install the latest version of the Entity Framework Power Tool * Restart Visual Studio. * On you assembly: * right click and select Entity Framework/Customize Reverse Engineer Templates text/html 2023-11-04T22:54:56+00:00 Anonymous (anonymous@undisclosed.example.com) https://skysigal.com/it/ad/code_first/entities/classes?rev=1699138496&do=diff IT:AD:Code First:Entities:Classes * (UP) entities index CheckList: Classes Design * MUST: Parameter less constructor * MUST: Not be sealed or abstract * MUST: Have a PK. * Convention: Named Id or <Entity>Id * DataAnnotation: [Key()] (see ) * FluentAPI: text/html 2023-11-04T03:39:13+00:00 Anonymous (anonymous@undisclosed.example.com) https://skysigal.com/it/ad/code_first/entities/complextypes?rev=1699069153&do=diff IT:AD:EF/CodeFirst/Entities/ComplexTypes * (UP) entities index * See: * Complex Types are simply a way of Logically grouping db fields together so that they are easier to manipulate. An example would be: public class User { public int Id { get; set; } public string First {get; set; } ... //Refer to a ComplexType (not same as a 1-1 relationship) //MUST: Cannot be marked Virtual to lazy load it: public Address Address { get; set; } public User { //MUST: Wi… text/html 2023-11-04T03:39:14+00:00 Anonymous (anonymous@undisclosed.example.com) https://skysigal.com/it/ad/code_first/entities/identities?rev=1699069154&do=diff IT:AD:Code First/Entities/Identities * (UP) entities index When we are talking about one database, an int is always the fastest Identifier to choose as they are created in order, therefore appended to the end (compared to a Guid which has to jump all over the table looking to insert it). text/html 2023-11-04T22:54:58+00:00 Anonymous (anonymous@undisclosed.example.com) https://skysigal.com/it/ad/code_first/entities/properties?rev=1699138498&do=diff IT:AD:Code First:Entities:Properties * (UP) entities index CheckList: Class Properties * MUST: mark Scalar Properties as virtual to enable improved Change Tracking (by going from Snapshot CT to Proxy POCO Change Tracking, which is based on IPOCO/IEntityWithChangeTracker