DevForce Community Forum : First time trying to use Generate Id

First time trying to use Generate Id : Glad you got it working! Thanks...

Thu, 05 Aug 2010 13:25:56 -700

Author: ting
Subject: 2039
Posted: 05-Aug-2010 at 1:25pm

Glad you got it working! Thanks for letting us know.

First time trying to use Generate Id : I finally got it to work. I made...

Wed, 04 Aug 2010 15:26:21 -700

Author: BillG
Subject: 2039
Posted: 04-Aug-2010 at 3:26pm

I finally got it to work. I made two mistakes. I didn't change the namespace in the NumericGenerator and I didn't change the datasourcekey(). I did have to change the code to look for a field called nextid1 because the designer would not allow me to have a fieldname with the same name as the table.

First time trying to use Generate Id : So afew comments: 1) When...

Wed, 04 Aug 2010 15:09:17 -700

Author: ting
Subject: 2039
Posted: 04-Aug-2010 at 3:09pm

So a few comments:

1) When you are using invoiceno as the primary key, are you using our NumericIdGenerator or did you implement your own IIDGenerator? (Or if you have none, that might also explain the null insert exception.)

2) If you use Identity columns for the primary keys, you don't need to implement an IIdGenerator or call EntityManager.GenerateId().

3) For the SalesInvoice table, it may be simpler to declare the invoiceno as an Identity column, but if this invoiceno is visible to the end user, you will buy some future flexibility by having a separate column as the primary key. It's a little more work though as you still have to create a unique invoiceno for each SalesInvoice.

If you want to keep things simple, just declare everything as an Identity column and then you don't have to worry about any ID Generation. Using GUIDs as primary keys is also simple and has the advantage that the entities don't have to use a temporary ID before being assigned one from the server. Their disadvantage is of course that they are long and hard to read.

First time trying to use Generate Id : Are you suggesting this? SalesInvoice...

Tue, 03 Aug 2010 17:28:21 -700

Author: BillG
Subject: 2039
Posted: 03-Aug-2010 at 5:28pm

Are you suggesting this?

SalesInvoice table

Id int identity

int invoiceno generated by nextinvioceno from a lookup table

SalesInvoiceLine table

id in identity

int invoiceno

int lineno

First time trying to use Generate Id : This is actually the error I am...

Tue, 03 Aug 2010 17:26:25 -700

Author: BillG
Subject: 2039
Posted: 03-Aug-2010 at 5:26pm

This is actually the error I am getting

Cannot insert the value NULL into column 'InvoiceNo', table 'SEIU99.dbo.SalesInvoices'; column does not allow nulls. INSERT fails.
The statement has been terminated.

Salesinvoices is the parent table. Right before it goes into the SaveChanges method SalesInvoice.InvoiceNo = -100

and the lone detail record is -100,1

First time trying to use Generate Id : Can you confirm that each SalesInvoiceLine...

Tue, 03 Aug 2010 17:08:56 -700

Author: ting
Subject: 2039
Posted: 03-Aug-2010 at 5:08pm

Can you confirm that each SalesInvoiceLine is pointing to the correct SalesInvoice?

What is the "invoices" property on SalesInvoice that the exception is complaining should not be null?

Also, if you have flexibility on the schema, consider creating a dedicated primary key with no semantic information on your tables instead of using a compound key. Performance will be better, and if the application grows, it supports a larger variety of scenarios.

First time trying to use Generate Id : Any ideas?

Tue, 03 Aug 2010 09:53:21 -700

Author: BillG
Subject: 2039
Posted: 03-Aug-2010 at 9:53am

Any ideas?

First time trying to use Generate Id : I have two tables in my database...

Sun, 01 Aug 2010 14:04:02 -700

Author: BillG
Subject: 2039
Posted: 01-Aug-2010 at 2:04pm

I have two tables in my database SalesInvoices and SalesInvoiceLines. The SalesInvoices table has a pk of invoiceNo

and the SalesInvoicesLine table has a pk of InvoiceNo and LineNo. The SalesInvoiceLines table has a FK to invoiceno of SalesInvoice. I have a table named NextId with a field called Global and it has a value of 100 in it.

Here is my SalesInvoice.Create

public static SalesInvoice Create(IbEm.EntityManager mgr)

{

SalesInvoice aSalesInvoice = mgr.CreateEntity<SalesInvoice>();

aSalesInvoice.InvoiceDate = DateTime.Now;

aSalesInvoice.InvoiceTotal = 0;

aSalesInvoice.AmountPaid = 0;

mgr.GenerateId(aSalesInvoice, SalesInvoice.PropertyMetadata.InvoiceNo);

aSalesInvoice.EntityAspect.AddToManager();

return aSalesInvoice;

}

Here is my save. I am saving the currentSalesInvoice which is an object of the SalesInvoice class and the detail lines which are a collection of the SalesInvoiceLines class.

try

{

List<Entity> changedEntities = new List<Entity>();

changedEntities.Add(currentSalesInvoice);

foreach (SalesInvoiceLine s in invoiceLines)

{

changedEntities.Add(s);

}

entityManager.SaveChanges(changedEntities);

invoiceLines = null;

}

catch(Exception ex)

{

throw new Exception(ex.Message);

}

when the save occurs I am getting a cannot insert into salesinvoices table with a null value for invoices.