tag:blogger.com,1999:blog-1944926148473713281.post590091212097316062..comments2024-03-11T04:42:50.934-07:00Comments on News, tips, tricks and more about DevExpress Application Framework (XAF) directly from the lab: Looking for practical experiences with both DevExpress XPO & ADO.NET Entity FrameworkDennis Garavskyhttp://www.blogger.com/profile/05439634942797151905noreply@blogger.comBlogger7125tag:blogger.com,1999:blog-1944926148473713281.post-71326959976451055582017-02-09T01:14:42.757-08:002017-02-09T01:14:42.757-08:00@Kirsten: XPO also allows defining data model memb...@Kirsten: XPO also allows defining data model members, relationships and attributes dynamically: https://documentation.devexpress.com/#eXpressAppFramework/CustomDocument113583Dennis Garavskyhttps://www.blogger.com/profile/05439634942797151905noreply@blogger.comtag:blogger.com,1999:blog-1944926148473713281.post-82899087495144949032017-01-23T13:50:25.651-08:002017-01-23T13:50:25.651-08:00The advantage of code first EF is that the databas...The advantage of code first EF is that the database relationships can be set up by overriding the OnModelCreating code of the DBContext and using FluentAPI https://msdn.microsoft.com/en-us/library/jj591617(v=vs.113).aspx I am hopeful that I can even get away with using the WithRequired relationship, which is very important to me. Orphan detail records are highly undesirable, and thus it is best to lock them out at the level of the SQL Server database structureKirstenhttps://www.blogger.com/profile/10182611817300533535noreply@blogger.comtag:blogger.com,1999:blog-1944926148473713281.post-69757322449868452032015-07-20T18:32:05.517-07:002015-07-20T18:32:05.517-07:00well, for performance reason, we sometimes use ILi...well, for performance reason, we sometimes use IList instead of XPCollection. That is, [aggregated] does not work, except we have set CASCADING DELETE in the database level<br />mukhlimhttps://www.blogger.com/profile/09239653259680662495noreply@blogger.comtag:blogger.com,1999:blog-1944926148473713281.post-74159705986624775552015-07-20T08:03:03.277-07:002015-07-20T08:03:03.277-07:00@Mukhlim: XPO already provides the Aggregated attr...@Mukhlim: XPO already provides the Aggregated attribute for that purpose (https://documentation.devexpress.com/#CoreLibraries/clsDevExpressXpoAggregatedAttributetopic). If your suggestion was about EF, it is better to forward it to Microsoft as we will unlikely implement this at our framework level, because this feature clearly deserves to be done at the ORM level.<br />As for your last comment, I would greatly appreciate you posting an XPO example where AggregatedAttribute cannot handle what you wanted so we could be in a better position to offer you alternative technical solutions or consider ones for the XPO future if this scenario is not easily possible in the current version.Dennis Garavskyhttps://www.blogger.com/profile/05439634942797151905noreply@blogger.comtag:blogger.com,1999:blog-1944926148473713281.post-82196094842078742152015-07-18T07:41:31.846-07:002015-07-18T07:41:31.846-07:00if possible please add attributes like this on col...if possible please add attributes like this on collection:<br /><br />[IsCascadeUpdate(true), IsCascadeDelete(true)]<br /><br />those should affect database tables phisically as we sometime need to process directly using SQL<br /><br />mukhlimhttps://www.blogger.com/profile/09239653259680662495noreply@blogger.comtag:blogger.com,1999:blog-1944926148473713281.post-35542663039698323512015-01-04T07:24:08.749-08:002015-01-04T07:24:08.749-08:00@mukhlim: would you please elaborate a bit more on...@mukhlim: would you please elaborate a bit more on your scenario and describe your current solutions, if any?Dennis Garavskyhttps://www.blogger.com/profile/05439634942797151905noreply@blogger.comtag:blogger.com,1999:blog-1944926148473713281.post-84002117258017809862015-01-02T08:55:15.271-08:002015-01-02T08:55:15.271-08:00please provide more data annotation attributes lik...please provide more data annotation attributes like that produce 'cascading update and delete' in phisical tables. mukhlimhttps://www.blogger.com/profile/09239653259680662495noreply@blogger.com