Not Getting FetchUsingUC...

Posts   
 
    
cmprogrock
User
Posts: 40
Joined: 16-Nov-2008
# Posted on: 12-Apr-2009 15:51:06   

Hi All, I have added a Unique Contraint on a varchar(100) feild....called UserName. I expected to get 'FetchUsingUCUserName...when building LLBLGen.

Method was not created. What to do?

Thanks,

daelmo avatar
daelmo
Support Team
Posts: 8245
Joined: 28-Nov-2005
# Posted on: 12-Apr-2009 20:36:44   
  1. Refresh the catalog at LLBLGen Designer.
  2. Regenerate code.
  3. Use the method. If you are using Adapter, use it this way, and for SelfServicing read this

In the future please post more info (http://llblgen.com/tinyforum/Messages.aspx?ThreadID=7725).

David Elizondo | LLBLGen Support Team
cmprogrock
User
Posts: 40
Joined: 16-Nov-2008
# Posted on: 12-Apr-2009 21:34:13   

I've done this. LLBLgen does not seem to recognize the Unique Constarint. Im in Sql 2005. Iv'e used a Index on the column set to unique. Is there anything i have to do in LLBLgen?

Does not build a FetchUnque method.

Walaa avatar
Walaa
Support Team
Posts: 14993
Joined: 21-Aug-2005
# Posted on: 13-Apr-2009 10:43:44   

This should be created as a Unique Key rather than a Unique Index.

robertgeifman avatar
Posts: 1
Joined: 24-Apr-2009
# Posted on: 24-Apr-2009 16:50:35   

How do I create a unique constrain, not an index -- please, I'm desperate!!! simple_smile

thanks in advance

daelmo avatar
daelmo
Support Team
Posts: 8245
Joined: 28-Nov-2005
# Posted on: 24-Apr-2009 21:34:37   

When you create the constraint on your database, on the "Type" combobox, select "Unique Key".

David Elizondo | LLBLGen Support Team