tag:blogger.com,1999:blog-4155628149386914837.post6374702515512721726..comments2024-01-01T20:54:44.562+07:00Comments on KristoferA's blog: Inferring Foreign Key Constraints in Entity Framework ModelsKristoferAhttp://www.blogger.com/profile/01779909152712388764noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-4155628149386914837.post-12142460763853288202015-05-10T20:06:50.872+07:002015-05-10T20:06:50.872+07:00Hi I was wondering if this is still what you'd...Hi I was wondering if this is still what you'd recommend for adding FK constraints to legacy databases? I currently am rewriting an application to .net and am looking for something to help add FK constraints to a database that does not have any currently. The naming conventions are there, but not the mappings. Entity Framework is what im trying to use, but I continue to get errors about mapping fragments. Anonymoushttps://www.blogger.com/profile/05875941280833360873noreply@blogger.comtag:blogger.com,1999:blog-4155628149386914837.post-82465531691849994692015-05-10T20:06:41.371+07:002015-05-10T20:06:41.371+07:00Hi I was wondering if this is still what you'd...Hi I was wondering if this is still what you'd recommend for adding FK constraints to legacy databases? I currently am rewriting an application to .net and am looking for something to help add FK constraints to a database that does not have any currently. The naming conventions are there, but not the mappings. Entity Framework is what im trying to use, but I continue to get errors about mapping fragments. Anonymoushttps://www.blogger.com/profile/05875941280833360873noreply@blogger.comtag:blogger.com,1999:blog-4155628149386914837.post-59891530512690239072010-12-27T11:39:29.338+07:002010-12-27T11:39:29.338+07:00@Fernando,
Unfortunately the EDMX files (and DBML...@Fernando,<br /><br />Unfortunately the EDMX files (and DBML files) contain only enough information to restore the signature of a stored procedure. The queries and other code in the stored procedure are not included in the model, so completely restoring stored procedures and db-side functions from a EF or L2S model is not possible.KristoferAhttps://www.blogger.com/profile/01779909152712388764noreply@blogger.comtag:blogger.com,1999:blog-4155628149386914837.post-77415694139605636142010-12-24T20:18:35.352+07:002010-12-24T20:18:35.352+07:00Very interesting, but when will include an option ...Very interesting, but when will include an option to recover (restored) the stored procedures generated by the diagram dbml, to the SQL database deleted or damaged. (Generate SQL Scripts to Stored Procedure for restored)?<br /> I think it is a good product, but if it had this option would be indispensable to every developer.<br /><br /> Atte. Fernando La RosaFernando La Rosahttps://www.blogger.com/profile/15066073435337764611noreply@blogger.comtag:blogger.com,1999:blog-4155628149386914837.post-24135445318646904262010-12-24T20:16:20.829+07:002010-12-24T20:16:20.829+07:00Very interesting, but when will include an option ...Very interesting, but when will include an option to recover (restored) the stored procedures generated by the diagram dbml, to the SQL database deleted or damaged. (Generate SQL Scripts to Stored Procedure for restored)?<br /> I think it is a good product, but if it had this option would be indispensable to every developer.<br /><br /> Atte. Fernando La RosaAnonymousnoreply@blogger.com