Open Discussion & Feature Requests

Re: Guid (uniqueidentifier) datatype, column case

Matthew Curland — Mon, 02 Jul 2012 20:20:04 GMT

Hi Tyler,

Haven't done this one. The issue isn'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.

I suggested a modification to the generator files at http://www.ormfoundation.org/forums/p/601/1835.aspx#1835. Basically, you hijack another data type based on a bogus facet info (I used DECIMAL with precision 1000). I'm not sure what else SQL Server needs to make this auto-generate for an IDENTITY column.

-Matt

Re: Guid (uniqueidentifier) datatype, column case

Tyler Young — Mon, 02 Jul 2012 16:51:18 GMT

Just a quick follow-up... did UUID ever make it into NORMA? I'm doing a bit of work where we're using UUIDs in SQL Server 2008, and at the moment I'm just doing a search / replace in the generated script. My next step will be to customize our output transform, but it'll just be a dirty hack.

Re: Guid (uniqueidentifier) datatype, column case

Brian Nalewajek — Wed, 21 May 2008 15:07:56 GMT

Hello Sensei,

I'd think the Numeric Auto Counter type would work well as a surrogate. You'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). That should make the process of coverting to UUID easier. One thing I'd check on is to see if your target DBMS has an integer to UUID conversion procedure already - and save that bit of work.

I can see the point of your request for a native UUID type, though; if it's important to the conceptual model to make that distinction - or just to automate the process.

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's just a matter of time.

BRN..

Re: Guid (uniqueidentifier) datatype, column case

sensei — Wed, 21 May 2008 10:46:41 GMT

Thanks Matt

For now it's no big deal to manually change some surrogate datatype to UUID i the DDL.

Again, thanks for the great effort with nORMa!

Re: Guid (uniqueidentifier) datatype, column case

Matthew Curland — Sat, 17 May 2008 01:28:11 GMT

Welcome to NORMA.

We haven'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'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'll evaluate the cost of adding this next week, hopefully it won't be worse than tinyint (a recent addition).

To change the column capitalization, open the 'Name Generation Settings' 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'll see casing options in the Properties Window. Change it from the default (Camel) to Pascal.

-Matt

Guid (uniqueidentifier) datatype, column case

sensei — Fri, 16 May 2008 11:58:39 GMT

Sorry if this has been asked before

Just starting to do some minor ORM work with nORMa, previous Visio user.

I dont care very much for "uniqueifiers" but unfortunetly they are sometimes necessary. Does nORMa support this datatype, I can't find it anywhere.

Also I have tried to get the DDL generation to produce Capital column names without success, is it possible to change?

Thanks for the great work