Developers

C# .Net Express edition...

exahertz — Thu, 14 Feb 2013 19:50:57 GMT

Are "Express" additions of the VS 2010 IDE components supported by NORMA?

Missing Relational View Table?

neutrino0112 — Wed, 21 Nov 2012 17:06:39 GMT

I've been using NORMA_VS2008_2012-04CTP Build 1487 to model university class meeting patterns for a physics education research database. The attached, zipped .orm and .docx files show the tables generated in the relational view. It seems that there may be a missing table that should be called Campus. The verbalization seems to imply that it should be there. The Building, CampusName and CampusIdentifier tables all have entries (i.e., CampusNr) that, while not specifically identified as such, could possibly be identified as foreign keys. Am I wrong about this, or is something actually missing?

:-)

Richard

.orm xml structure

rik.vanmechelen — Sun, 12 Aug 2012 12:59:14 GMT

I am trying to parse the .orm file's xml structure in ruby. Is there any documentation on the structure of the xml? thank you all in advance

Adding a reference to NORMA .msi fails

Tyler Young — Mon, 30 Apr 2012 22:11:09 GMT

Is there a way to reference these assemblies in my own project? When trying to load the .msi file I get the error "Could not load file or assembly 'Natural ORM Architect for Visual Studio 2010.msi' or one of its dependencies. An attempt was made to load a program with an incorrect format. This file may not be a managed assembly." I feel like I'm missing something absurdly obvious. :-\

Custom data types mapped to unary fact types

josecarlus — Sat, 26 Nov 2011 04:25:27 GMT

Hi,

When mapping a unary fact type to a relational view, a column is created with a logical True/False data type. When this model is exported to Oracle a column with NCHAR(1) is created.

I prefer to use numeric data types in Oracle for boolean values, 0 for false and 1 for true, so in the relational view I tried to assign a numeric data type to this column, such as an unsigned integer, and set the ValueRange of the role to {0,1}. However, it wasn't possible because after reloading the model the unary fact type is converted into a binary fact type, which is obviously not desirable.

I thought it would be a good idea to at least comment this here.

Jose Carlos

What are the current intermediary formats for code generation?

Tyler Young — Fri, 23 Sep 2011 15:46:23 GMT

At my work we're updating a bunch of spaghetti code to Entity Framework 4.1 using the Fluent interface to map our POCOs. While we're not doing any conceptual modeling at this point, it's given me an itch to write a transform to create an object model and then write a DAL to map them to their corresponding tables. Last time I did a transform it was using DCIL and OIAL. I've heard rumors that those have been abandoned / updated. Any tips on the newest hottest?

Adding new datatypes

lozdown — Fri, 01 Jul 2011 14:29:50 GMT

Hi,

I am using NORMA to create a SQLServer database with a hybrid SQL/XML structure (using NORMA to create the SQL schema and the XML schema I need). Is there anyway I can adapt the configuration of NORMA to include a datatype XML, that can be selected in the ORM and will propagate through to the SQLServer generator?

Thanks

Laurie

Exclusion constraint in XML representation

ralberts — Mon, 28 Feb 2011 12:43:17 GMT

Hi,

I am looking for the representation of the exclusion constraint (between different roles) in the XML representation of my NORMA schema.

Could you please point me in the right direction?

I found the supertype and associated subtype roles in the orm:EntityType/orm:PlayedRoles tag, but I cannot figure out how the exclusion constraint defined on the subtypes is represented in the XML.

Any help with this will be highly appreciated.

Ronell

NORMA XML representation

ralberts — Wed, 26 Jan 2011 15:32:20 GMT

Hi,

I need some information on the XML representation of the ORM models in NORMA.

Is it possible to get access to the XML schema?

I tried to have a look at http://schemas.neumont.edu/ORM/2006-04/ORMCore etc. which is indicated in the head of the .orm file but this is not functioning anymore.

Any help or point in the right direction will be highly appreciated.

Exclusion constraint

oliver — Sun, 02 Jan 2011 12:43:37 GMT

Hi,

When I add Exclusion constraint on diagram I expect that NORMA generate some code behind, for example:

alter table Employee add constraint Employee _excl check

( (ParkingSpaceID is null) or

(ExpenseID is null) )

alter table Employee add constraint Employee_MR check

( (ParkingSpaceID is not null) or

(ExpenseID is not null) )

But in SQL generated code I don't find what I expected. Why?

Does the Readme note for non-LINQ outputs still apply?

shada22 — Mon, 16 Aug 2010 21:59:47 GMT

The ConceptualDB -> DCIL transform appears to be the updated (or processes the results of) R-Map/absorbstoin logic. I haven't quite been able to spend enough time to determine if this DCIL is the one currently used by the SQL outputs. If it is, then I'll probably look into cleaning up the SQL Server SQL output. (Like not spitting out the schema creation statement if the schema is 'dbo', etc..) Thanks, Bill

Adding Support for Additional Databases

rjperes — Thu, 18 Sep 2008 15:05:30 GMT

Hi,

What would it take to add support for additional databases, apart from SQL Server, PostgreSQL, Oracle, MySQL, DB2 and SQL Standard?

What I mean is: what classes are involved in the process of generating the DDL scripts for each of these DBs, and how can I implement support for additional ones, such as, for example, Access?

Thanks,

Ricardo Peres

PS - I originally posted this on the Open Discussion & Feature Requests forum, but I think it belongs here instead.

WCF service generated by LinqToSqlAttributeMapping does not work

jbailey — Wed, 17 Sep 2008 23:07:05 GMT

I've been using nORMa and I've been very happy with the tool and its SQL script generation. I was excited to see that it generated a WCF service to generate Linq to SQL, but I was disappointed that the service does not function. The contract being generated is incorrect. Example is below:

#region Insert, Select, Update, and Delete Operations for Customer
[OperationContract(IsOneWay=true)]
[TransactionFlow(TransactionFlowOption.Allowed)]
void InsertCustomer(Customer customerToInsert);
[OperationContract(IsOneWay=false)]
Customer SelectCustomerByCompanyName(String companyName);
[OperationContract(IsOneWay=false)]
Customer SelectCustomerByPreferredIdentifier(Int32 customerId);
[OperationContract(IsOneWay=true)]
[TransactionFlow(TransactionFlowOption.Allowed)]
void UpdateCustomer(Customer newCustomer, Customer oldCustomer);
[OperationContract(IsOneWay=true)]
[TransactionFlow(TransactionFlowOption.Allowed)]
void DeleteCustomer(Customer customerToDelete);
#endregion // Insert, Select, Update, and Delete Operations for Customer

This contract is not correct. The only allowed TransactionFlow option with a one way contract is TransactionFlowOption.NotAllowed. I'm not sure if there is a configuration option to correct this or if it is a problem with the code. Any assistance would be appreciated.