http://www.skysigal.com/ 2026-05-25T23:25:54+00:00 http://www.skysigal.com/ http://www.skysigal.com/lib/tpl/bootstrap3/images/favicon.ico text/html 2023-11-04T03:23:55+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.skysigal.com/it/ad/ef/databasefirst?rev=1699068235&do=diff IT:AD:EF:DatabaseFirst * (UP) ef index ---------- * Use when working with an existing Db. * Otherwise, prefer either: * IT:AD:EF:DatabaseFirst, and use it create a Db: * Model * IT:AD:Code First if it is a POC, or you can live without StoredProcs till EF6. * The good news it that with EF5, EntityContext is superceded by DbContext. Yay! text/html 2023-11-04T03:23:56+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.skysigal.com/it/ad/ef/glossary?rev=1699068236&do=diff IT:AD:EF/Glossary * (UP) ef index #### DbContext ModelBuilder Fluent In CodeFirst, one can define the schema of the database in two ways -- either by tagging the attributes of entities with attributes such as [Key] or [MaxLength(50)] etc...or using delegate syntax, within a text/html 2023-11-04T22:24:53+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.skysigal.com/it/ad/ef/home?rev=1699136693&do=diff IT:AD:EF * (UP) ef index * See: * IT:AD:EF Core * IT:AD:EF:FAQ * IT:AD:EF:HowTo * IT:AD:EF:Transactions * IT:AD:EF:DatabaseFirst * IT:AD:EF:ModelFirst * IT:AD:Code First * IT:AD:EF:Queries * See also: * IT:AD:SQL Server * IT:AD:Data/Regarding Data, Clay Tablets and Camels Notes Questions * Pg 12: Can Object Service track objects not derived from EntityObject? Resources * Cool resource: http://social.technet.microsoft.com/wiki/contents/articles/3737.entity-framework-faq… text/html 2023-11-04T03:23:57+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.skysigal.com/it/ad/ef/modefirst?rev=1699068237&do=diff IT:AD:EF:ModelFirst * (UP) ef index Benefits / Considerations * Benefits: * Considerations: * IT:AD:Code First offers more options to private set; and use logic than anything available via STE and T4. Self Tracking Entities (STEs) * Benefits: * More productive than POCOs text/html 2023-11-04T22:24:53+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.skysigal.com/it/ad/ef/modelfirst_ste_over_wcf?rev=1699136693&do=diff How's it's done: * Create a WCF app to host .svc endpoints Need to make a Model: * Add/New Item.../C#/Data/ADO.NET Entity Data Model * Follow through... * Result is “something.edmx” * Problems: * Models inherit from EF4 classes, not POCO text/html 2023-11-04T03:23:57+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.skysigal.com/it/ad/ef/queries?rev=1699068237&do=diff IT:AD:EF:Queries * (UP) ef index ---------- ## Loading of Graphs (Lazy v. Explicit Loading of related tables) ## Related entities can be loaded implicitly (lazy loading) or explicitly. See Queries ## Returning Anonymous / 'mini-Entities' ## As expressed here: one can return smaller objects: text/html 2023-11-04T03:23:58+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.skysigal.com/it/ad/ef/transactions?rev=1699068238&do=diff IT:AD:EF:Transactions * (UP) ef index ---------- Essentials * TransactionScope only affects the database. All it does is rollback the SQL, not the values in memory. Resources * http://bit.ly/tS1lta text/html 2023-11-04T22:24:54+00:00 Anonymous (anonymous@undisclosed.example.com) http://www.skysigal.com/it/ad/ef/validation?rev=1699136694&do=diff Validation is automatically done on Save, but can be triggered early: public static void Validation() { using (var context = new CompanyContext()) { var manager = new Manager() { Name = string.Empty }; context.Managers.Add(manager);