Open Discussion & Feature Requestshttp://www.ormfoundation.org/forums/10.aspxThis is where you can discuss your suggestions for functions that are not provided by the current release of the NORMA tool. You can also ask questions on how to use the tool.enCommunityServer 2007.1 (Build: 20917.1142)Re: Guid (uniqueidentifier) datatype, column casehttp://www.ormfoundation.org/forums/thread/3062.aspxMon, 02 Jul 2012 23:20:04 GMT9d039735-a311-4a8d-9c49-a0bb2572af9e:3062Matthew Curland0http://www.ormfoundation.org/forums/thread/3062.aspxhttp://www.ormfoundation.org/forums/commentrss.aspx?SectionID=10&PostID=3062<p>Hi Tyler,</p>
<p>Haven&#39;t done this one. The issue isn&#39;t so much SQL server, it is that (AFAIK) UUID is not a standard SQL datatype and not all of the generation targets support it.</p>
<p>I suggested a modification to the generator files at <a href="http://www.ormfoundation.org/forums/p/601/1835.aspx#1835">http://www.ormfoundation.org/forums/p/601/1835.aspx#1835</a>. Basically, you hijack another data type based on a bogus&nbsp;facet info&nbsp;(I used DECIMAL with&nbsp;precision 1000). I&#39;m not sure what else SQL Server needs to make this auto-generate for an IDENTITY column.</p>
<p>-Matt</p>Re: Guid (uniqueidentifier) datatype, column casehttp://www.ormfoundation.org/forums/thread/3061.aspxMon, 02 Jul 2012 19:51:18 GMT9d039735-a311-4a8d-9c49-a0bb2572af9e:3061Tyler Young0http://www.ormfoundation.org/forums/thread/3061.aspxhttp://www.ormfoundation.org/forums/commentrss.aspx?SectionID=10&PostID=3061Just a quick follow-up... did UUID ever make it into NORMA? I&#39;m doing a bit of work where we&#39;re using UUIDs in SQL Server 2008, and at the moment I&#39;m just doing a search / replace in the generated script. My next step will be to customize our output transform, but it&#39;ll just be a dirty hack.Re: Guid (uniqueidentifier) datatype, column casehttp://www.ormfoundation.org/forums/thread/937.aspxWed, 21 May 2008 18:07:56 GMT9d039735-a311-4a8d-9c49-a0bb2572af9e:937Brian Nalewajek0http://www.ormfoundation.org/forums/thread/937.aspxhttp://www.ormfoundation.org/forums/commentrss.aspx?SectionID=10&PostID=937<p>Hello Sensei,</p>
<p>I&#39;d think the Numeric Auto Counter type would work well as a surrogate.&nbsp; You&#39;ll have a one-to-one for matching to UUID type, and will have the same (actually theortically better), assurance of uniquness (within the data structure).&nbsp; That should make the process of coverting to UUID easier.&nbsp; One thing I&#39;d check on is to see if your target DBMS has an integer to UUID conversion procedure already - and save that bit of work.</p>
<p>I can see the point of your request for a native UUID type, though; if it&#39;s important to the conceptual model to make that distinction - or just to automate the process.</p>
<p>One thing you get from the nORMa team, is that there are a lot of features they plan to add (or are willing to add on request), but it&#39;s just a matter of time.</p>
<p>BRN..</p>Re: Guid (uniqueidentifier) datatype, column casehttp://www.ormfoundation.org/forums/thread/936.aspxWed, 21 May 2008 13:46:41 GMT9d039735-a311-4a8d-9c49-a0bb2572af9e:936sensei0http://www.ormfoundation.org/forums/thread/936.aspxhttp://www.ormfoundation.org/forums/commentrss.aspx?SectionID=10&PostID=936<p>Thanks Matt</p>
<p>&nbsp;For now it&#39;s no big deal to manually change some surrogate datatype to UUID i the DDL.</p>
<p>&nbsp;Again, thanks for the great effort with nORMa!</p>Re: Guid (uniqueidentifier) datatype, column casehttp://www.ormfoundation.org/forums/thread/930.aspxSat, 17 May 2008 04:28:11 GMT9d039735-a311-4a8d-9c49-a0bb2572af9e:930Matthew Curland0http://www.ormfoundation.org/forums/thread/930.aspxhttp://www.ormfoundation.org/forums/commentrss.aspx?SectionID=10&PostID=930<p>Welcome to NORMA.</p>
<p>We haven&#39;t yet included the UUID datatype, but we should eventually do so. This is a little harder than, say, bigint because not all generation targets support it. Also, we&#39;ve currently built the autoincrement and identifier notions into a datatype, when in fact the notion of datatype and autogeneration need to be separated. We&#39;ll evaluate the cost of adding this next week, hopefully it won&#39;t be worse than tinyint (a recent addition).</p>
<p>To change the column capitalization, open the &#39;Name Generation Settings&#39; branch in the ORM Model Browser (Ctrl-W, Ctrl-M from the designer, or on the context menu), find the relational branch, then Column Specific. You&#39;ll see casing options in the Properties Window. Change it from the default (Camel) to Pascal.</p>
<p>-Matt</p>Guid (uniqueidentifier) datatype, column casehttp://www.ormfoundation.org/forums/thread/929.aspxFri, 16 May 2008 14:58:39 GMT9d039735-a311-4a8d-9c49-a0bb2572af9e:929sensei0http://www.ormfoundation.org/forums/thread/929.aspxhttp://www.ormfoundation.org/forums/commentrss.aspx?SectionID=10&PostID=929<p>Hi</p>
<p>&nbsp;Sorry if this has been asked before</p>
<p>&nbsp;Just starting to do some minor ORM work with nORMa, previous Visio user.</p>
<p>I dont care very much for &quot;uniqueifiers&quot; but unfortunetly they are sometimes necessary. Does nORMa support this datatype, I can&#39;t find it anywhere.</p>
<p>Also I have tried to get the DDL generation to produce Capital column names without success, is it possible to change?</p>
<p>&nbsp;</p>
<p>Thanks for the great work</p>