Hello, Say I have 2 tables Users and Workers

In Users I have: UserId DateAdded DateLastLogin Password Email

In Workers I have WorkerId UserId Name LastName DateBirth

As you see there is a relation between Workers and Users table (Workers.UserId=Users.UserId). In stead of creating 2 Entities I would like to have only one Entity named Workers in which I would like to have all fields from within Users table. How can I create a such entity using LlblGen Pro code generator.

Version: 3.1 using Adapter mode. Language C# DB: Sql Server 2008

Hi there,

I assume the Users - Workers relationship is 1:m. There is no way to merge those entities into one. You can however add fields mapped onto related entities. That means you can add User's fields in the Worker entity.

In generated code, you can access the User object through the worker entity like

worker.User.SomeField...

If you add fields mapped onto User entity you can access those fields directly:

worker.SomeFieldInUser...

If you want a custom mixed entity you could create a DB view and map that view into an entity as well.

How about creating TypedList ? In this case I know my TypedList is going to be read only. Am I right ?

TypedList is read-only indeed.