Hello, I have generated the code successfully of an entity Customer. I am able to search the databause using the primarykey field(CustomerId) of entity customer. But what if I want to implement another constructor in the entity class where instead of passing he primary key field I want to pass for Non PrimaryKey field for example(FirstName) of Customer entity?

Appreciate your help

Regards

Are you using Adapter or SelfServicing? Anyway, adding custom code it's easy. I recommend to read Adding your own code to the generated classe. You can add code to the same file using USER_CODE_REGIONS and that code is kept when you re-generate from LLBLGen Designer. You also can use partial classes (preferred). Be aware that your new constructor makes sense. Please let us know if you need further help.

Hello I have added a new constructor in the ClientGroupEntity and trying to pass a ClientGroupName as string. I am doing the same thing what i saw in the generated code as mentioned below

public ClientGroupEntity(System.Decimal clientGroupId):base("ClientGroupEntity")
        {
            InitClassEmpty(null, null);
            this.ClientGroupId = clientGroupId;
        }

This what I have implemented as a new constructor to fetch the entity by a customer name. But Unable to get the entity, It is returning null. I have added my code in the custom entity code region. Please help..

public ClientGroupEntity(System.String clientGroupName)
            : base("ClientGroupEntity")
        {
            InitClassEmpty(null, null);
            this.ClientGroupName = clientGroupName;
        }

In the client code I am writing the below code.

          ClientGroupEntity clientGroup = new ClientGroupEntity("ABC");
            DataAccessAdapter adapter = new DataAccessAdapter();
            adapter.FetchEntity(clientGroup);
            string s = clientGroup.ClientGroupCode;

Now in the client code i am expecting s should be filled bby ClientGroupCode. But it is returning as null....

Please help, what I am doing wrong.

Mmm. It doesn't work like that, because you are Using Adapter. So you didn't implement the logic to find the correct entity. So you don't need a method in your Entity. Instead outside write this:

EntityCollection<ClientGroupEntity> clientGroups = new EntityCollection<ClientGroupEntity>();
IRelationPredicateBucket filter= new RelationPredicateBucket(ClientGroupFields.ClientGroupName == "AAA");

DataAccessAdapter adapter = new DataAccessAdapter();
adapter.FetchEntityCollection(clientGroups, filter);

ClientGroupEntity theClientGroup = null;
if (clientGroups.Count > 0)
{
     theClientGroup = clientGroups[0];
}

You can put that in a special method in your business logic.

Thanks buddy, by following this approach I have done it but what if I need to put this type of method as a constructor in the entity class. So it means I will do this type of code inside the entity class. By the way thanks for the tip it is working now...

In the Adapter model, the entities are not aware of the persistence info, and they should not be aware of it. So you should not put any fetching logic inside the entity class.

The entity default CTor that acepts a PK parameter, just sets the PK value, and the DataAccessAdapter is the class that is responsible of fetching he entity based on the PK value.

It seems to me that maybe the FirstName in this case is unique, that's why you want to use it to fetch a customer, if this is the case then you may define a Unique Constraint on the database field, which let's you do something like the following (provided that you have refreshed the schema and regenerated the code using the Designer):

DataAccessAdapter adapter = new DataAccessAdapter();
CustomerEntity customer = new CustomerEntity();
customer.FirstName = "Austin";
adapter.FetchEntityUsingUniqueConstraint(customer, customer.ConstructFilterForUCFirstName());

Walaa wrote:

In the Adapter model, the entities are not aware of the persistence info, and they should not be aware of it. So you should not put any fetching logic inside the entity class.

The entity default CTor that acepts a PK parameter, just sets the PK value, and the DataAccessAdapter is the class that is responsible of fetching he entity based on the PK value.

It seems to me that maybe the FirstName in this case is unique, that's why you want to use it to fetch a customer, if this is the case then you may define a Unique Constraint on the database field, which let's you do something like the following (provided that you have refreshed the schema and regenerated the code using the Designer):

DataAccessAdapter adapter = new DataAccessAdapter();
CustomerEntity customer = new CustomerEntity();
customer.FirstName = "Austin";
adapter.FetchEntityUsingUniqueConstraint(customer, customer.ConstructFilterForUCFirstName());

Thankx alot friend. your detail description really helped me alot. appreciate.

regards Austinn