Browse by Tags

HasPrimaryKey: System.Data.SqlTypes.SqlNullValueException

Hi there, I've got a strange problem with codemith, I'm trying to generate code from a database and when I try, I receive the following error message. System.Data.SqlTypes.SqlNullValueException: Data is Null. This method or property cannot be called on Null values. apparentently the generation fails...

Posted to General Support (Forum) by Joel Rewers on 05-31-2007
Filed under: SchemaExplorer, Visual Studio, SchemaProvider, primary key, Entities, generating templates
Many to Many issue when both entity tables have the same name for the primary key field

The code generated for the many to many relationship I think is getting confused when two Entity Tables both have the same column name for the primary key. Table structure. Dealer --------- PKID int Name varchar(100) Address1 varchar(150) .... Country ---------- PKID int Name varchar(150) Code char(4...

Posted to .netTiers - General Support (Forum) by millerwa on 05-09-2007
Filed under: primary key, many to many
Table XXX does not have a primary key, it will not be generated. (oracle 9.2i)

While generating code using NetTiers template-set for oracle 9.2i schema, i recieved a message: "Table TRATE does not have a primary key, it will not be generated." Then i've read a post about the same situation under MS SQL server and implemented the same schema under Oracle, here is it's sql code:...

Posted to General Support (Forum) by timafyozzi on 03-22-2007
Filed under: Oracle, nettiers, primary key
Does anyone know how to use nettier with Oracle

Hi all, I've download the Oracle provider for CodeSmith, and use nettier to generate code from my oracle database (9i), but the nettier say Message:Table ABC does not have a primary key, it will not be generated. with all table (I've add contraint primary key to table, sure). Does any one know...

Posted to .netTiers - General Support (Forum) by mhz_bk on 08-07-2007
Filed under: Oracle, primary key
Self-referencing FK insert?

I have a table where I want to FK to the table's Primary key (so as to create parent/child relationships among the rows). The problem I have is getting the PK value on insert. I do an DataRepository .MyObjectProvider. Insert(TransactionManager, o_myobject) but obviously get an error when the FK value...

Posted to General Support (Forum) by MeasuredSpace on 09-21-2007
Filed under: .netTiers, ForeignKeys, primary key
1:1 with Composite PK that is also Composite FK

I am having a few difficulties getting NetTiers to understand my database. Basically i've got a database that looks like this: DB Paradigm So basically the MarketProduct is related to a Product table (ProductId), and a Market table (MarketId), and uses that association as a composite primarykey....

Posted to .netTiers - Bug Reports (Forum) by Ottomeister on 09-20-2007
Filed under: foreign key field, OneToOneRelationship, NetTiers, Fieldname, primary key, ProviderBaseCore, composite key
Composite Primary key (two FK columns, rowguid = true) GetByFK Return only ONE item instead of a TList

There are three tables say TableA, TableB and TableC as TableA( TableA_PK uniqueidentifier, <----------- rowguid=true Name nvarchar(100) ) TableB( TableB_PK uniqueidentifier, <----------- rowguid=true Name nvarchar(100) ) TableC( TableA_PK uniqueidentifier, TableB_PK uniqueidentifier, Name nvarchar...

Posted to .netTiers - Bug Reports (Forum) by roy2825 on 06-28-2007
Filed under: foreign key field, bug, primary key
ParseDbColDefaultVal is not working for primary keys

I have a table with two fields (for example K1, K2) as primary keys. Both of them are nvarchar(50) with default value '' (string.empty). When generating nettiers entities the default value for K1 and K2 is null and not string.empty which is, by my oppinion, wrong. The problem that I have is that...

Posted to .netTiers - Bug Reports (Forum) by geochatz on 06-27-2007
Filed under: ParseDbColDefaultVal, primary key
Re: How to retrieve auto-generated uniqueidentifier primary key after an insert?

So, is there no one using the UNIQUEIDENTIFIER as the PK of their tables and generating with .netTiers? If anyone has the solution to this problem, please post it! Thanks!

Posted to .netTiers - General Support (Forum) by sjd0103 on 02-03-2008
Filed under: GUID, unique identifier, primary key

Page 1 of 1 (9 items)