StoreGeneratedPattern attribute in SSDL from Entity Designer - by Fabio Vassura

Status : 

  External<br /><br />
		This item may be valid but belongs to an external system out of the direct control of this product team.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 774005 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 12/11/2012 2:11:25 AM
Access Restriction Public


Hi, we have the same problem described in KB2561001 with a new MVC 4 project using VS2012, EF 5 and ODP.NET for Oracle 11.

Everytime we "generate database from model", the ssdl part on edmx file loses the "storedGeneratedPatter=Identity" attribute.

Are you planning an hotfix for VS2012 and EF 5 supporting Oracle too?
Sign in to post a comment.
Posted by Microsoft on 3/11/2013 at 4:08 PM
I can repro the problem but only on Oracle. The long and the short of it is it’s a problem with the Oracle provider.


If you set things up the way you’re supposed to on Oracle (see e.g. the Model First part of this page then you set Database Generation Workflow as “Generate Oracle Via T4 (TPT)” and DDL Generation Template as “ (VS)”. If you have these set and do Model First then I can repro the the problem.

The “Generate Oracle Via T4 (TPT).xaml” is in $(VisualStudio)\Common7\IDE\Extensions\Microsoft\Entity Framework Tools\DBGen. It specifies a class “Oracle.VSDevTools.OracleVSGTPT_CsdlToSsdlActivity” in assembly Oracle.VSDevTools. It is this class which is responsible for generating the SSDL from the CSDL. This seems to be broken in that it is not generating the SSDL SGP attribute. (There is a similar class for TPH – and that seems to be broken too).

Workarounds : None

If, even though the connection is for Oracle, you set Database Generation Workflow as the default “TablePerTypeStrategy.xaml” and DDL Generation Template as the default “ (VS)” then SGP generation works OK but you lose more important stuff about the types / precision etc of the SSDL properties and you are generating DDL for SQL Server.

If you have already generated the SSDL you can, even with Database Generation Workflow = “Generate Oracle Via T4 (TPT)” and change the SGP directly on the C-side property using the Properties Window. This will change the SGP on the S-side property to match, but the moment you do “Generate DB from Model” the S-side SGP attribute will disappear again.

We are forwarding the issue on to Oracle to see if they can update the class.
Posted by Microsoft on 12/11/2012 at 7:05 PM
Thank you for submitting feedback on Visual Studio and .NET Framework. Your issue has been routed to the appropriate VS development team for investigation. We will contact you if we require any additional information.
Posted by Microsoft on 12/11/2012 at 2:50 AM
Thank you for your feedback, we are currently reviewing the issue you have submitted. If this issue is urgent, please contact support directly(